Posts Tagged ‘insert’

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?

MS Word 2007: Voice Comments

Friday, August 8th, 2008

A reader wrote to me recently inquiring about voice comments in the latest version of MS Word (2007). She said she knew how to create voice comments in MS Word 2003, but couldn’t figure out how to go about it in version 2007. I was able to show her very easily. I think if you have upgraded to the latest version of MS Office it’s a little bit like being in a new country – you know how to do everything you have always done and you know how to travel – you just don’t know the lay of the land and how to navigate to get where you want to go.
In earlier versions of MS Word, such as 2002 and 2003, if you wanted to add a voice comment to a document you simply clicked the drop-down arrow of the New Comment button on the Reviewing toolbar and selected Voice comment. The Sound Object dialog box then would then open for you to record your comment.

However, if you would like to add a voice comment in MS Word 2007, you will need to add the Insert Voice button to the Quick Access toolbar (QAT).

Follow the steps below to learn how:

Click the Word Options button.

Click Customize.

Choose Commands From box and select Commands Not In Ribbon.

Insert Voice.

Click the Add button.

Click OK.

The Insert Voice button will now be available for you to add voice comments to your Word 2007 documents.