Tidy up your formatting with Format Painter

Posted Posted in Word

I often compile new documents by gathering text from documents I’ve created in the past.  It’s just so much easier and more efficient to copy and paste text you know is relevant instead of starting from scratch.  To avoid bringing across unwanted formatting, I always suggest using Word’s Keep Text Only feature, but the next best […]

Five sure-fire ways to jazz up your Excel spreadsheet

Posted Posted in Excel

Sometimes it’s the simplest things that make the biggest impact, and this is definitely the case when it comes to formatting your Excel spreadsheet. Following are five sure-fire ways to jazz up your spreadsheet, with the least amount of effort.  Remember to take into consideration the content of your spreadsheet before trying any of these […]

PowerPoint: reboot your slide with Reset

Posted Posted in PowerPoint

Have you ever formatted a PowerPoint presentation slide with the best of formatting intentions only to find it just didn’t look right?  How do you fix it? Like Word and Excel, if there are only a few formatting wrongs to make right, you could use Undo (Ctrl+Z).  However, with PowerPoint, there’s a little function which […]

Smarten up your SmartArt

Posted Posted in Word

So you’ve added SmartArt to your Word document because you know how effective a graphic can be in catching your readers’ attention.  But, have you taken the next step of formatting your SmartArt so that it looks the best it possibly can? There are a number of quick and easy ways to change the overall […]

Automatically update wreaking havoc?

Posted Posted in Word

Styles that automatically update … sounds good, I know, but (just secretly) I’ve been caught out by this Word feature a number of times in the past.  Have you? Let me give you a scenario.  I’m working away on my document and decide that a heading which has the Heading 1 style applied needs to […]

Data replication using Ctrl+D

Posted Posted in Excel

Copy and paste is a popular way to replicate data, but did you know that Excel has a shortcut which does the same thing but in less time?  The shortcut I’m talking about is Ctrl+D, and it enables you to copy all data and/or formatting located in the cell immediately ABOVE the active cell. Similar […]

Page Layout View

Posted Posted in Excel

Does the nature of an Excel spreadsheet – lots of data, displayed in rows and columns – really necessitate drab looking documents?  Personally, I don’t believe so.  And the good news is that, by working in Page Layout View, making your Excel spreadsheet pop becomes a breeze. Here’s an example.  I recently set up a […]

Keep text only

Posted Posted in Word

Have you ever worked on a lengthy Word document, pasting text from other documents / programs, to then find your final document is a mishmash of different styles and formatting?  Well there’s a simple way to avoid this. Here’s how: Paste the text at the appropriate point within your document; A clipboard icon with Paste […]