Tuesday, November 23rd, 2004
Do you find yourself constantly entering the current date and / or time in MS Excel?
Wish you had a quick key combination to get the job done for you?
Good-because that’s what you’re going to get.
Next time you’re
Quick Slide Margins – Part 2 – MS Excel
As a follow-up to the last issue, I thought it might be relevant to discuss quick margin adjustments in MS Excel.
As with Word, you can set margins in the Page Setup (under the File menu) on the Margins tab.
Works well—but, as you may already know, in Excel you have to go to the Print Preview to take a look… Continue reading
Close It Up In A Hurry
Here’s another piece of information for the function key enthusiasts.
I checked this one out in MS Excel, Word, PowerPoint and Access and found success in all four.
Here’s the deal…
Just a couple more tricks to put on your keyboard list.… Continue reading
Quick Slide Margins In MS Word
Just picture it—you just finished working on a document that you really need as a one-page memo. Unfortunately, it ran over to page two.
What do you do?
One solution is to adjust margins.
So… some of you go to the File menu, Page Setup choice, Margins tab, make your adjustments, then click OK.
Sounds good—but when you return to your document you find… Continue reading
Here’s a quick tip for my readers who love to use the function keys. It turns out that the F12 key is very versatile in MS Word, Excel and PowerPoint.
Interested in its abilities?
Was that a “yes” I heard?
Good, so let’s take a look at its uses.
Playing The “Shifty Cell” Game
Have you ever found yourself happily working in a large MS Excel worksheet only to discover that you need some cells in the middle of the thing?
You’d add rows or columns, but that will mess with everything else in the worksheet. (You know—data way off yonder in the far reaches of the worksheet will suddenly be displaced causing mass chaos in the middle of… Continue reading
The Wonders Of F2 In MS Excel
When you’re working in Excel and you need to edit something that is already in a cell what do you do?
Do you click on the cell, then click into the formula bar to edit the contents?
Sounds like a lot of clicking?
Yeah, it did to me too.
For people who don’t really care for their mouse, it can turn into a… Continue reading
Here’s the situation: you have a really great MS PowerPoint presentation—it covers “everything”. It’s a masterpiece, if you do say so yourself.
Now you need a slightly different presentation—this one should cover only part of the “masterpiece” mentioned above.
What do you do?
You could simply skip through the unneeded slides while giving the presentation. Not a very slick or wonderful way to do it—distracting for the audience—definitely not your… Continue reading
Templates, Templates, Templates
I often get requests from readers for templates. You know, where they can they download templates for use with the MS Office Suite.
Now, while I’m sure there are many places you can look—many people don’t seem to know that you can download quite a few directly from the Microsoft site.
Next time you’re looking for some sort of template of anything, give this a click.