Posts Tagged ‘click’

Displaying Different Toolbars in MS Word

Wednesday, February 8th, 2012

Your toolbars in Word are simply a bar with a collection of buttons and/or icons that you use to perform tasks in MS word.

As a rule, your toolbars will appear just below the menu and just above your ruler. However, they can also appear anyplace on your screen, depending upon the toolbar and how you have your Word screen configured.

Word will allow you to control which toolbars you have displayed at any time. It is a very simple process to display a toolbar.

Follow the steps below to learn how:

  1. In version 2003, simply click on View | Toolbar and a submenu will be displayed whowing which toolbars are available to you.
  2. Click on the toolbar and Word will display it for you.
  3. To close it, simply click it again.

Of course, in the latest versions of MS Word, we all know there are no longer toolbars, but ribbons!

Adjust Column Width and Row Height in MS Excel

Monday, February 6th, 2012

This may seem to you to be a very basic tip but there are always folks out there who can benefit from this information and this is for them!

  1. To adjust your column width, select the column you want to adjust and simply drag the vertical bar between any two columns to the width that suits you.
  2. You can also double-click that same vertical bar and the columns will automatically fit to the widest entry in each column.

The same applies for adjusting row height in Excel.

  1. Select the rows you want to adjust and drag the horizontal bar between any two rows to the desired row height. If you double-click on that same bar, Excel will automatically adjust the rows to the best fit.
  2. If you want to have your column width adjusted based ont he widest entry in part of the column, select the area where you want the column width based on and click on Format | Column | AutoFit Selection.

Add Menu Items in MS Excel

Thursday, April 21st, 2011

It doesn’t bother some folks to keep re-inventing the wheel, but for us power users, we want to streamline things so that we can save time and keystrokes.  Isn’t that the whole point of using the Microsoft Office Suite?  It is supposed to make life easier for us and save time and it can absolutely do that.  We just have to set it up to do our bidding.

If you find that you are always clicking around to find something that you do fairly frequently in your worksheets, it is time to customize things to save time. For instance, using macros.

Follow the steps below to learn how:

  1. Click on Tools | Customize.
  2. Be certain the Commands tab is selected.
  3. In Categories, select either the category of commands you would like to add to your menu, or select Macros if you would like to add a macro to a menu.
  4. In the list of available commands for the category, select the one that you would like to add to a menu.
  5. Drag your selected command to the menu where you would like it added.
  6. The menu appears as you move the selected command over the command name.
  7. Once you have reached the point where you would like your item to be added, release your mouse button.

Life will now be much simpler for you!

Versions 97, 2000, 2002, 2003