Computertim Technologies - free computer training, tips, and support



Home Articles Help Shop Business Education

> 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

Hide a Column or Row

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.

Home  |  Articles  |  Help  |  Shop  |  Business  |  Education  |  Contact Us

Privacy Policy

Copyright 2003 Computertim Technologies.  All rights reserved.