A subscriber wrote to me last week asking why there isn’t an AutoComplete feature in MS Excel. My reply: Well it’s not exactly AutoComplete but it will do the trick for you. Follow the steps below to learn how: Whenever you want to repeat data that already appears in a column, simply click: ALT +
A subscriber recently wrote to me with this plaint: “Why does my calendar look like a patchwork quilt with different colors? I know it is most likely related to color categories on appointments, but why are only some of the dates shaded when I use color categories on all of the appointment?” My Reply: When
You can make AutoText very easy to find on the Quick Access Toolbar (QAT). Follow the steps below to learn how: Click on the Office Button | Word Options | Customize. Under Choose commands from look for All Commands. Scroll until you see AutoText and click Add. You will now have a drop-down box to
Adding a new column to an MS Excel table is as easy as falling off a log! Follow the steps below: Place a formula, such as SUM, in the first cell of a new data column. That formula is then automatically applied to all the cells in that column, which can also be sorted and
If you ever have the need to add a cents symbol in your spreadsheet, follow the step below: Hold down the ALT key and click 0162 on your Num Pad. Told you it was easy!
MS Outlook 2007 does not animate GIFs in your e-mail messages. Instead, it displays the first frame of the GIF only. In order to see the animated GIF it is necessary to open your HTML message in your browser to view the animation. Follow the steps below to learn how: Open the message. Click the
To adjust indents for individual paragraphs on a PowerPoint slide, first make the rulers visible. Follow the steps below to learn how: Click on View | Ruler. Select the paragraphs you would like to change. Drag on the First Line Indent and Left Indent markers on the ruler to change your indents. Pretty easy huh?
The default font in Word 2007, Calibri, is great but if you do not care for it you can change it permanently. Follow the steps below to learn how: Click CTRL + D. Select the font you would like to use. Click the Default button. This will change the default font in the template called
When you reopen an MS Word document, very often you just want to start working where you left off, but it can be tedius and time consuming to scroll through a large document finding exactly where your work left off. I have heard it said that you cannot go back, but guess what – you
One of the fairly cool things you can do in MS Word is draw tables. I think you will agree that this is a really cool feature. Another really cool feature is the Eraser tool. You can erase any lines that you have created in your table until it looks exactly the way you want.
