Posts Tagged ‘Excel’

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 »

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 »