Archive for December, 2009

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

Unhide Hidden Rows or Columns in MS Excel

Thursday, December 10th, 2009

I have, on occasion, become the recipient of an MS Excel workbook that has hidden rows or columns. Mind you, it doesn’t happen often but when it does it can be a real problem because I don’t always remember how to unhide them and as you all know, I hate wasting time floundering around trying to find a resolution.

Follow the steps below to learn how to unhid rows and columns:

  1. Highlight the row above and the row below the hidden row(s), or the column to the left and right of the hidden column(s).

There are a couple of methods to reveal the hidden rows and columns:

  • Click on Shift + Ctrl + zero.
  • Right-click your selection and select Unhide.
  • Click on Format | Column (or Row) and select Unhide.
  • In version 2007, in the Cells group on the Home tab, clcik Hide & Unhide and select Unhide Rows or Unhide Columns.

Very simple eh?

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

« Older Entries