Posts Tagged ‘worksheet’

« Older Entries

Insert Rows and Columns Quickly in MS Excel

Monday, December 14th, 2009

Inserting rows and columns into your MS Excel worksheet is a fairly easy task.

  1. Select a row or column.
  2. Click on Insert | Row or Column, respectively.

MS Excel will insert a new row above the selected row and a new column to the left of the selected column.

As you all know, I like to take the quicker route with less keystrokes and save some time!

Alternative to the steps above, you can also achieve the same results using your keyboard:

  • Select a row or column and click Ctrl + Shift + =.
  • You can delete a row or column just as speedily by clicking Ctrl + Shift + -.
  • Should you change your mind, and decide you do not want that new row or column immediately after you added it/them, simply click Ctrl + Z.

Who doesn’t love to save time?

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

Print your Recurring MS Outlook Appointments

Friday, December 11th, 2009

Wouldn’t it be nice to have a handy list of appointments that you have scheduled for recurring events? One might think that would be available in MS Outlook but alas, it is not. There is, however,  a way to get around MS Outlook’s limitation and print out a list of those recurring appointments.

You can export your calendar to MS Excel!   Once you have done that, you can then sort and filter the list and then print it.

Follow the steps below to learn how:

To export your calendar to Excel:

  1. In Outlook, click on File | Import And Export.
  2. Select Export To A File from the Choose An Action To Perform list.
  3. Click Next.
  4. Select Microsoft Excel 97 – 2003 from the Create A File Of Type list.
  5. Click Next.
  6. Click Calendar in the Select Folder To Export From list.
  7. Click Next.
  8. Click Browse and navigate to the folder where you would like to save the workbook.
  9. Name your workbook.
  10. Click OK.
  11. Click Finish.

Specify the appropriate date range for your export.

Once MS Outlook completes the export, ope the workbook and click the Calendar tab.

If there is no tab visible named Calendar, you may have to click around some to find your Calendar items.

You can use a filter to exclude all but the recurring items and then sort the filtered results to arrange them as necessary.

You can now print your filtered list!

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

Create a Drop-Down List From a Range of Cells in MS Excel

Tuesday, February 10th, 2009

There are many reasons why one would want to create a drop-down list in MS Excel, but mostly I think, because it makes your data entry much easier and you can limit the entries to certain items that you can determine.

You can create a drop-down list of entries that is compiled from cells elsewhere on your worksheet and when you create the drop-down list, it will display a drop-down arrow next to that cell. When you want to select an item from that list, you can simply use the drop-down arrow and click the item that you want.

To create a drop-down list in MS Excel 2003, follow the steps below:

  • Use a single column or row without blank cells to create your valid entries for your drop-down list.

 

  • Make sure that you have sorted the list in the order in which you would like it to appear in your list.

You can use another worksheet or workbook if you like. To use a different worksheet in the same workbook:

  • Type the list on that worksheet.
  • Define a name, such as classes.
  • Select the range of cells.
  • Click the Name box at the left end of the Formula Bar.

  • Type the name for the cells.
  • Click Enter.

Pretty simple to do and it looks so very professional and is very helpful to boot!

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

« Older Entries