Hide a Column or Row

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles

Microsoft Excel

Print article

E-mail this page

Reader rating: 6 out of 10

Introduction

Do you have a row or column of data that you want hidden while working? Is there a column or row that you don't want to print?

This How-To Article shows how to hide a row or column in your worksheet.

Hide a Column or Row

1. Click the row number or the column letter of the row or column that you would like to hide.

2. Click the Format menu, point to Column or Row (depending on which you are trying to hide), and select "Hide" from the menu that appears.

3. The row or column that you selected will be hidden.

Note: The row that you just hid will not be deleted; it is just hidden.

Show a Column or Row

1. Click and drag, selecting the two row numbers or column letters that are at the sides of the hidden column or row. (Example: If column B is hidden, select the A and D column by clicking and dragging from "A" to "D".)

2. click the Format menu, point to Column or Row (depending on which you are trying to show again), and select "Unhide" from the menu that appears.

3. The row or column that you selected will now be shown again.

Rate this article:

Poor 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 Excellent

Books on Microsoft Excel

Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS

Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.