Archive for February, 2009

« Older Entries

Open Multiple Files at Once in MS Office

Friday, February 27th, 2009

I am a multi-tasker. I almost always have several applications open at any one time, for instance, when I am creating my newsletter! So, in the interest of saving time, I usually open all of these documents, spreadsheets, etc. all at once.

Follow the steps below to learn how:

  1. Click on File | Open, or in 2007, click the Office button and Open. You can also use the keyboard shortcut CTRL + O.
  2. Find the files you would like to open.
  3. If the files are contiguous, click on the first one to highlight it and then depress your Shift key and while still holding it down, click on the last item in your list.
  4. If the files are NOT contiguous, simply click on the first one and then depress your CTRL key and keep it held down while you select your other files.
  5. Once you have selected your files, click on Open.

NOTE: These files must all reside in the same folder for this method to work.

Tags: , , , , , , , , , ,
Posted in Microsoft Office, Office Productivity | 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 »

Copy and Paste MS Excel Row Height

Tuesday, February 24th, 2009

I have had many inquiries regarding this tip and it is such an easy thing to do!

To learn how to copy and paste row height in MS Excel, follow the steps below:

  1. Select the row you would like to copy.
  2. Click on the Format Painter icon on your Standard toolbar (or on the Home tab is you are using version 2007).
  3. You will now see a small paint brush.
  4. Simply drag it where you would like to copy the row height.

That’s all there is to it! You have now copied the format to your new row.

If you are not a subscriber of Carol’s Word Bytes Newsletter, you should be!  Visit http://www.carolscorneroffice.com to subscribe.

Tags: , , , , , , , , , ,
Posted in Excel 2003, Excel 2007, Microsoft Office, Microsoft Office Excel, Office Productivity | 1 Comment »

« Older Entries