Without 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
If 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
PROBLEM: 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
PROBLEM: having to retype text when your data is in UPPERCASE, lowercase or a Mix oF bOTH.
SOLUTION: quickly change the text back to the proper case without having to retype it. Continue reading Excel – change the text to uppercase, lowercase or first capital
PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?
SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates. Continue reading Excel – Why is my figure displayed as a date?
PROBLEM: wasting time mucking around with column widths and font sizes so that Excel worksheet data will print on one page.
SOLUTION: within seconds ensure Excel worksheets always fit to the width and height of a printed page.
Continue reading Excel – Fit your worksheet on 1 page when it prints
PROBLEM: Wasting time filling out a new Outlook Contact form for
someone who has just sent you an email message.
SOLUTION: Save the sender’s name and email address in just 3 clicks. Continue reading Outlook – Quick ways to save a contact’s details into the Contacts folder
PROBLEM: 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
PROBLEM: 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
PROBLEM: Charting data with a starting and ending point. This method of charting is sometimes referred to as floating and is often used to create waterfall charts.
SOLUTION: Quickly create a floating chart. Continue reading Excel – Creating a floating (waterfall) chart