Posts Tagged ‘formula’

« 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 »

Add AutoNumbering to your MS Excel Spreadsheet

Thursday, February 26th, 2009

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row.

Unfortunately, MS Excel does not ship with an autonumbering feature like that found in MS Access, that increments a number each time you add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list.

Say you want to create a list of all of your school’s classes and their corresponding learning materials.

Follow the steps below to add autonumbering to the list:

  • In A1, enter the formula below:

=TEXT(Row(A1),”000-000″)

  • Enter the name of the first class in B1.
  • Enter the learning material of the first class in C1.
  • Copy cell A1 to A2.
  • Enter the name of the second class in B2.
  • Enter the learning material of the second class in C2.
  • Select A1:C2.
  • Go to Data | List and select Create List.

Data List Dialog Box

  • In Excel 2007, press CTRL + T and then click OK.

Notice, that when you type the name of the next class in B3 and press Tab, MS Excel will automatically provide the next number for you.

Autonumbered List

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

Clean Up Copied Data in MS Excel Easily

Monday, February 16th, 2009

Sometimes when you copy and paste data in MS Excel you copy over non-printing character and other strange looking things that you did not intend to copy.

Well the good news is that there is an easy way to clean up that data with a very easy to use MS Excel function called the Clean Function.

Follow the steps below to learn how:

  1. Select the cells with the data that needs to be cleaned.
  2. Enter the following formula: =CLEAN(A2) or whatever cell you are referencing.
  3. Click CTRL + Enter.
  4. MS Excel will now display the contents of the cells without the non-printable characters.

You can now copy the results to another part of your workbook using the Paste Special option to copy the values without the formulas.

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

« Older Entries