Tag Archives: 2007

Excel – Paste a link and Paste Special transpose your data

SharynAvatarBlog120x120Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Continue reading Excel – Paste a link and Paste Special transpose your data

Word – How to change measurements from inches to centimetres

SharynAvatarBlog120x120If you are familiar with working in centimetres, not inches, it can be a tad frustrating if Word is displaying measurement settings in inches.

For example, if I wanted to set my Hanging Indents to 1.25cm I know for a fact I would be lost if my measurement settings were only being displayed in inches.  Continue reading Word – How to change measurements from inches to centimetres

Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging

SharynAvatarBlog120x120PROBLEM: When you enter a post code that has a leading 0 (zero), e.g. 0642, you see only the last 4 digits, not the leading zero.  This is especially frustrating when using an Excel file in a Mail Merge!

SOLUTION: learn how make the 0 stay!

 

Continue reading Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging

Office – Changing the screen to gain more screen real estate

SharynAvatarBlog120x120PROBLEM: Needing more screen and less Ribbon (great for tablets).

SOLUTION: Gain more screen “real-estate” by changing your display settings. Continue reading Office – Changing the screen to gain more screen real estate

PowerPoint, Word, Excel – nudging shapes so that they align nicely

SharynAvatarBlog120x120PROBLEM: Have you ever tried to perfectly align a line of check
boxes or shapes?  It’s not easy!

SOLUTION: Take control and easily knock wayward shapes back into line.  Note: check out the tip on nudging – it’s fabulous! Continue reading PowerPoint, Word, Excel – nudging shapes so that they align nicely