Headers and Footers?
What exactly is a header or footer?
I think that the MS Office Assistant gives the best definition for headers and footers. According to that cute little guy in the help window:
“A header or footer is text or graphics—such as a page number, the date, or a company logo—that is usually printed at the top or bottom of each page in a document. A header is… Continue reading
MS Word: Headers & Footers Demystified
So, now you know what they are, I’d bet that the next question you’re dying to ask is “How do I get to these wonderful little miracles?” (All right, I can hear the groans and moans from here. Maybe they’re not little miracles but they’re pretty useful little gadgets anyway.)
The way to access headers and footers is to go to the View menu… Continue reading
MS Excel: Headers & Footers Demystified
Let’s continue on our journey through the world of headers and footers. The train stops next at the MS Excel station.
To access headers and footers in Excel, you will go to the View menu, Header and Footer choice.
The Page Setup window will open with the Header/Footer tab already selected. (You can also get to this location via the File menu, Page Setup… Continue reading
Selecting Multiple Worksheets in an MS Excel Workbook
We all know that to select one sheet you simply click on the sheet tab. The next logical question might be “How do I select several consecutive sheets at once?”
Easy enough answer. First, you’ll need to locate the worksheet tabs in order to select the ones you want.
Then, simply select the first sheet by clicking on its tab then… Continue reading
I’m having a hard time with my word processor. When I go to highlight a large section of text with my mouse (more than what’s currently shown on the screen), I zip right past the point where I want to stop. So, I keep my mouse button down and go back up – only to zip by my stopping point again. This can go
Have you ever been working in MS PowerPoint and wish you could select more than one of the slides at a time? Maybe you have several slides for which you’re going to set the slide transition the same? Wouldn’t it be nice to set these things all at once instead of over and over again, one slide at a time?
Of course it would, who wouldn’t want to save the… Continue reading
Paste Options?
You just completed a copy / paste in MS Word XP and you happen to notice this little button appear at the end of you pasted text.
What’s that you ask? Hmmm…
Good question.
And here’s a good answer.
The little button offers you the Paste Options.
(Now I know a few of you just had the Paste Special thing pop into your mind, but just keep… Continue reading
Next Text Please
Ever find yourself frustrated while working in MS PowerPoint as you jump back and forth between the keyboard and the mouse to move from text box to text box?
Let me clarify… you’re working on a slide with a couple of text boxes and a title box and you’re tired of jumping between the mouse and the keyboard every time you want to move to the next… Continue reading
Cut vs. Copy in MS Excel
So we all know the difference between a cut / paste and a copy / paste.
I mean, it’s pretty obvious, one actually moves the cell contents and the other makes a duplicates.
But, did you know that there’s a difference in the way each of them treats formulas with relative cell references?
(Relative Cell References are formula references to other cells based on… Continue reading
The Word Font Window On Demand
OK, so when working in MS Word we all know about the usual toolbar buttons and lists that allow us quick access to things like font type, size, bold, Italics, underline, color, etc.
But did you know that there are even more aspects of your fonts that can be manipulated?
There are things like character spacing and text effects to be explored along with… Continue reading
Changing Directions
Have you ever wished that you could change the direction of text? I mean literally have it read in another direction.
Maybe you want to change the look of the documents or maybe you need to maximize the space you have to work with in the horizontal direction. (Change direction, get more space… If only that would work in my living room. Change the direction of the couch… Continue reading
Click, Click — Text Formatting Trick
Many of you may be aware of the Change Case text options in the Format menu of MS Word. This wonderful feature will allow you to take text and, in one quick swoop, change the case of every letter to match your needs.
From the Change Case options, you can make text all lower case, all upper case, sentence case, toggle case or… Continue reading
Changing Directions – Part 2 – MS Excel
Well, now that we’ve looked at the options for turning text in MS Word, let’s move on to MS Excel.
Excel allows for a lot of flex in text direction. You’re actually allowed to set the text angle as opposed to the limited choices of vertical and horizontal offered by Word.
So, let’s get started.
The first thing you need to do… Continue reading
Quick Email Sorting
You’re sorting through a huge list of email, wishing you knew of a quick way to find the specific one needed.
Smile 
There is!
To get MS Outlook or Outlook Express to sort email all you have to do is click!
When you’re looking at your inbox do you see the column titles at the top? The ones that label the columns at From, Subject, Received… Continue reading
Add A Little Color To Your Life
Ok, so maybe not exactly to “your life”, but would you settle for a little color added to your Excel worksheet tabs?
Yes?
Good.
Of course I’ve got to mention one small catch… this one wasn’t in Excel 97 or 2000. It seems to be an additional feature of the newer versions.
So, anyway, here’s the deal—you can now turn this…
Into… Continue reading
The Four Direction “Zoom” Scroll
Tired of the scroll bars in MS Excel?
Looking for a quicker way to move through the worksheet—one that doesn’t involve you dragging around the horizontal or vertical scroll bars?
If this sounds like it might be a handy thing to know then you’re in the right place, that is, if you have a scroll wheel on your mouse.
Click down on the scroll wheel.… Continue reading
Navigation Shortcuts for MS Word
Here’s the picture: you’re working on the ultimate document, it’s a masterpiece! Too bad the masterpiece is also a nightmare. It’s easily the longest document you’ve ever edited and the navigation through all those pages is a huge headache. (Not to mention the back and forth, back and forth between the keyboard and the mouse.) Help!
Never fear, help is on the way. While these… Continue reading
MS Excel: A Quick AutoFit Solution.
Have you ever been working in MS Excel and found yourself spending all kinds of extra time trying to manually adjust column width or row heights? Or are you one of the many people who simply skip a column whenever text gets too long?
Well, here’s one of the many solutions to these time-consuming problems.
AutoFit.
What’s AutoFit, you ask?
Well, it’s exactly what… Continue reading
Brrrr… It’s Cold in the Freeze Pane Zone
OK, so it’s not really that cold here, but the real question is, “What’s Freeze Pane?”
Well, to answer a question with questions, have you ever been frustrated while working in an MS Excel worksheet because you were so far down the columns that you no longer could see the column titles? Did you find yourself constantly scrolling up to make sure… Continue reading
Tear It Up
Have you ever been working in an MS Office application and realized that you kept accessing the same menu or palette of choices over and over and over again?
Ever wonder if there was a way to keep the choices open for a while (or maybe permanently)?
One quick way to tell is by taking a good look at the menu or palette when you open it.… Continue reading
Have you ever needed a quick way to really make a statement stand out on a flyer, presentation, worksheet or some other document? (You know, a way to really catch their attention.) Are you tired of the plain old text boxes in MS Excel? Want a way to make text more interesting?
Do you want to turn this…
into this?
(Sorry, beginning to sound like an infomercial… Continue reading
Ever find yourself squinting at the buttons on the toolbars? Wish they were bigger?
Your wish is my command… Relief is just a few clicks away.
To begin you need to go to the Tools menu, Customize choice. (Or right click over any toolbar and choose Customize from the toolbar list.)
On the Options tab you should see the Large Icons choice. Check this box. Instantly you should see the… Continue reading
Taking Control of Your Menus
Here’s the scenario:
You’re cruising through the menus in an MS Office program (version 2000 or newer). Maybe you’ve even upgraded recently. Anyway, you’re looking for that really cool thing you did a few months ago. Unfortunately, you can’t seem to find the right menu choice and you can’t remember exactly what you did the last time.
Suddenly you realize that your menus seem to… Continue reading
Just “Cruising” Through The Day
Have you ever heard anyone refer to “cruising” when working in a program?
Were you wondering what in the world they were talking about? (I’m sure you figured it out that it had nothing to do with cars.)
Well, for many people, “cruising” on the computer means to slide through the menus in a program looking at the choices listed.
There are some people who… Continue reading
Give Me A Break!
Since we’re all here for the same reason—to find out all about MS Word’s section breaks—I’ll get right to the “how to”.
The most obvious step is to have a Word file open that would benefit from having different sections.
Once your file is open you’ll need to place your cursor at the point where you want to create a section break.
Now use the Insert… Continue reading
Paragraphs, Pages And Now There’s Sections?
OK, so we all have experience with paragraphs and pages in MS Word… but did you know you have further options for sub-dividing your documents?
No?
Well, let me fill you in.
According to Word’s online help, Sections are “a portion of a document in which you set certain page formatting options. You create a new section when you want to change such properties… Continue reading
Breaking the Connection of Word’s Headers and Footers
Here’s the scenario: you’re working in MS Word and it’s time to set up your header or footer information.
Everything is going well except there’s one small catch. (Isn’t there just always “one small catch”?)
Anyway… the document you’re working on requires different header or footer information at different locations. (Maybe you need the first few pages numbered with Roman Numerals and… Continue reading
