Posts Tagged ‘hide’

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 »

Word 2007 – Hide and Restore the Ribbon

Monday, October 6th, 2008

Yes, you can hide the Ribbon in MS Word 2007 if you want to free up some valuable real estate on your screen.

  • All you have to do is double-click the tab, and click on CTRL + F1, or right-click and select Minimize the Ribbon.
  • The Ribbon will now be treated almost like a menu; that is, it will remain hidden until you click the tab or use the Alt key to bring up keystrokes.

It’s nice to know that you still have some choices!

Tags: , , , , , , , , ,
Posted in Word 2007 | No Comments »