Posts Tagged ‘display’

« Older Entries

Control the Display of your Formula Bar in MS Excel

Friday, January 13th, 2012

For those of you who do not know, your Formula Bar in MS Excel is located at the top of your screen, bust underneath your Ribbon or the Formatting toolbar, depending upon which version of Excel you have a license for.

The Toolbar is comprised of two parts:

  • On the left-hand side is the Name Box;
  • On the right-hand side is the contents of your currently selected cell.

Now sometimes you may need more real estate to view one of your worksheets and sometimes you just don’t need to see the information provided in your Formula Bar and the good news is that you can turn it off if you do not need it!

Follow the steps below to learn how:

Versions 2007 – 2010:

  1. Click the Office button | Excel Options to display the Options dialog box.
  2. Click Advanced on the left-hand side.
  3. Scroll down until you see the Display options.
  4. Click on the Show Formula Bar check box.  If it is currently selected, then your Formula Bar is displayed. If you deselect it then your Formual Bar will not be displayed.
  5. Click on OK.

Earlier Versions:

  1. Click on Tools | Options to display the Options dialog box.
  2. Be certain the View tab has been selected.
  3. Click on the Formula Bar check box. If it is selected then your Formula Bar is selected. If you deselect it, your Formul Bar will not display.
  4. Click OK.

Note:   You can also view your Formula Bar option from the View tab of your Ribbon or from the View menu. This operates as a toggle: Click on it one time and the Formula Bar disappears – click on it again and it will reappear.

Tags: , , , , , , , , ,
Posted in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Microsoft Office, Microsoft Office Excel | No Comments »

Deleting all Tab Stops in MS Word

Tuesday, August 30th, 2011

A reader wrote to me recently inquiring whether there was a keyboard shortcut to delete all tab stops in her document.

Unfortunately there is no keyboard shortcut to accomplish this task. You must use the Tabs dialog box instead.

Follow the steps below to learn how:

Click CTRL + A to select your entire document.

Display the Home tab of your Ribbon.

Click the small icon at the bottom-right of the Paragraph group to display the dialog box.

Click the Tabs button at the bottom-left to display the Tabs dialog box.

Click the Clear All button.

Click OK.

In version 2003, simply click on Format | Tab | Clear All.

I have read different posts that suggest a quick way to delete tab stops is to select all the text and then click CTRL + Q. This removes all explicit paragraph formatting from your text.  While the tab stops are a paragraph format, CTRL + Q just removes any explicitly added tab stops and sets the paragraphs back to whatever formatting is defined for each paragraph’s style. So if the underly paragraph style has tab stops defined, those stops remain after CTRL + Q is clicked and not all tab stops are removed.

More importantly, you should know that when you get rid of your paragraph stops, Word’s default tab stops automatically take place. The default tab stops in MS Word are set for every half inch. You can set them to a different setting, but you cannot cleanse your document of all tabs completely. There is no method to do this.

Should you need to remove tab stops from a large number of documetns you may want to use a macro to accomplish the task for you. The macro below will remove all tab stops from all paragraphs in yoru document:

Sub TabsGone()

     ActiveDocument.Paragraphs.TabStops.ClearAll

End Sub

Tags: , , , , , , , ,
Posted in Microsoft Office, Word 2007, Word 2010 | No Comments »

Display From and BCC Fields in MS Outlook

Wednesday, May 25th, 2011

When I open MS Outlook and click on CTRL + N to open a new e-mail, a new blank e-mail message opens complete with a From and BCC (Blind Carbon Copy) fields displayed and ready for me to fill in.

I can use the From drop-down arrow to change e-mail accounts because I have more than one. The BCC field allows me to hide one or more recipients from the other recipients.

However, I get lots of mail from subscribers and readers who tell me that the From field is not visible in their new, blank e-mails. This simply means that you do not have more than one e-mail account and let’s face it, why would you need a From field if aren’t going to use it to change accounts?

In versions 2007 and 2010 it is fairly easy to display these two fields. As a matter of fact, it is a simple as clicking a button!

Follow the steps below to learn how:

  1. Open a new, blank e-mail.
  2. Click the Options tab and click the BCC and From options in the Show Fields group.

They are toggle options, meaning click to display and click to hide.

In version 2003, follow these steps:

  1. Using Outlook as the e-mail editor, click on View and select BCC Field and From Field.
  2. If MS Word is your e-mail editor, click the Options drop-down and select BCC and From.

Tags: , , , , , , , ,
Posted in Microsoft Office, Microsoft Office Outlook, MS Outlook 2010, Outlook 2003, Outlook 2007 | No Comments »

« Older Entries