Archive for the ‘Excel 2007’ Category

« Older Entries

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 »

Toggle the Display of Formulas in MS Excel

Wednesday, December 9th, 2009

Sometimes we just need to see the formulas in our MS Excel worksheet. I have had more than one inquiry regarding this topic. When this situation presents itseld, you may want to turn on Excel’s formula display.  Follow the steps below to learn how:

Simply click on Ctrl + ~ (tilde).

There is a more convoluted method of doing this in version 2003 via Tools | Options but as you all know I am all about saving time and keystrokes. In version 2007, you have the Show Formulas button in the Formula Auditing group of the Formulas tab, but as I said, why waste time and keystrokes?

If you select a cell whose formula you would like to troubleshoot before turning on the formula display feature, MS Excel will also show you the dependent cells for the formula!

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

Move to the End of a Long Column in MS Excel Quickly

Monday, April 6th, 2009

This is one of those little tips that most folks aren’t aware of but are ever so grateful for the knowledge once they have learned it. Why??? Because it saves time and keystrokes of course!

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

In a nanosecond you will be at the bottom of the data in that column, regardless of whether its 12,000 rows long!

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

Now aren’t you glad I shared that with you? Just think what else you could learn if you were a Premium subscriber!

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

« Older Entries