Posts Tagged ‘bar’

« Older Entries

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.

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

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 »

Mark your Document as Final

Friday, April 22nd, 2011

You have finally finshed your document, proofed it, made edits, and it is ready to be sent to your colleagues. But you are certain this is the final draft and you do not want anyone changing your masterpiece. What to do???

Mark it as Final! This will prevent users from inadvertently making changes and gives you some protection against modifications to your document. This feature is also helpful when you share a computer and do not want someone modifying your documents.

Follow the steps below to learn how:

  1. Click on Office Button | Prepare | Mark as Final.
  2. You will receive a message that warns you “This document will be marked as final and then saved.”
  3. Click OK to save your document and mark it as final.
  4. Another message will appear.
  5. Click OK one more time.
  6. Now your document has been marked as Final and editing has been turned off.

Once you have marked your document as Final, you will see an icon in your status bar that indicates that it is final and your document cannot be edited.

Should you later decide to modify your document, you can turn off the Finalization by clicking Office button | Prepare | Mark as Final.

You should note that this feature can be reversed by anyone to opens your document if they know how.

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

« Older Entries