New Logo White mail

By Lisa Griffin, Mar 28 2019 02:44PM

Do you recognise any of the culprits in this line up?


If you use Microsoft Excel, Word, Outlook or PowerPoint (in fact any of the Microsoft products), then you actually have buttons like this appearing on your screen every day. Most people I teach acknowledge that they see them but confess to ignoring them - in fact they say they are annoying. Their perception has completely changed when they leave my course at the end of the day!


Others admit to being cautious about trying the different options out because they don't know what they mean - you can experiment with each option until you achieve the desired result. The button will only disappear once you start doing something else.


Let me give you some examples:....


So, in Excel, do you ever feel like you're constantly re-doing borders after autofilling formulas? Below you can see how the double border from the first cell has been copied down when I copied the formula.



To quickly remove the borders, click the tag that appears at the bottom of the range and choose Fill Without Formatting. This way you have chosen to copy the formula down but not the formats.


When you insert columns/rows use the "Paint brush" tag to determine whether your newly inserted item adopts the look of one of it's neighbours or no look at all.


Pasting cut/copied data is easy thanks to the (Ctrl) tag that offers a number of options (in Excel I often choose Keep Source Column Widths). The options offered will vary depending on the product you are using and the item you are cutting/copying).





The next time you select some data in Excel take a minute to explore the Quick Analysis Button that always appears in the bottom right-hand corner of your selected range.


You may discover a fast new way to insert totals, charts or learn about some other tools available in Excel.



When working with numbered lists, use the "lightning" button when it appears to the left to control how your numbering appears.



Have you ever noticed your font size in a PowerPoint slide shrinking as you type lots of text in a placeholder? Use the tag that appears to the left to explore alternatives.




As you can see, these option buttons can be extremely useful and save lots of time. So, the next time you see one, expecially if something's just happened that you're not happy with, click the tag and explore the options available. You'll wish you had never ignored them!