Posts Tagged ‘MS Excel’

« Older Entries

USING THE STATUS BAR IN MS EXCEL

Wednesday, May 6th, 2009

The lowly status bar just sits at the bottom of your MS Excel screen and most folks don’t pay it much mind, but it can come in quite handy sometimes.

For instance, I am sure that you all know how to sum a range of cells in MS Excel, but did you know that you can get the sum of that range of cells without clicking on AutoSum? Yep, you sure can! Suppose you are in the middle of keying in the collected fees for the week and the attorney stops by and says “how much have we netted thus far?”  Well, there is a very easy way to tell him within a second, using the lowly Status Bar!

Follow the steps below to learn how:

Select the range of cells.

Look down at the right-hand side of your Status Bar (at the bottom of the MS Excel screen).

You will now see the word Sum and the total of the selected cell range.

Now that you have gained a bit more respect for that lowly Status bar, I will let you in on some other smooth actions that it is capable of that can save you time and keystrokes.

If you right-click on your Status Bar in MS Excel, it will give you the option of:

  • None
  • Average
  • Count
  • Count Nums
  • Max
  • Min
  • Sum

Pretty cool huh?

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

Move to the End of a Long Column in MS Excel Quickly

Monday, April 6th, 2009

This is one of those little tips that most folks aren’t aware of but are ever so grateful for the knowledge once they have learned it. Why??? Because it saves time and keystrokes of course!

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

In a nanosecond you will be at the bottom of the data in that column, regardless of whether its 12,000 rows long!

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

Now aren’t you glad I shared that with you? Just think what else you could learn if you were a Premium subscriber!

Tags: , , , , ,
Posted in Excel 2003, Excel 2007, 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 »

« Older Entries