View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Code no longer runs


Display or hide rows or columns
Display a hidden row or column
1.. Select a row or column on each side of the hidden rows or columns you
want to display.
2.. On the Format menu, point to Row or Column, and then click Unhide.
Tip

If the first row or column of a worksheet is hidden, click Go To on the Edit
menu. Type A1 in the Reference box, and click OK. Point to Row or Column on
the Format menu, and then click Unhide.

Also, the row or column may have had the height or width set to zero. Point
to the border of Select All until the cursor changes to or , and drag to
widen the row or column.

Hide a row or column
1.. Select the rows or columns you want to hide.
How?

To select Do this
Text in a cell If editing in a cell is turned on, select the cell,
double-click in it, and then select the text in the cell.
If editing in a cell is turned off, select the cell, and then select
the text in the formula bar.



A single cell Click the cell, or press the arrow keys to move to the
cell.
A range of cells Click the first cell of the range, and then drag to
the last cell.
A large range of cells Click the first cell in the range, and then
hold down SHIFT and click the last cell in the range. You can scroll to make
the last cell visible.
All cells on a worksheet Click the Select All button.


Nonadjacent cells or cell ranges Select the first cell or range of
cells, and then hold down CTRL and select the other cells or ranges.
An entire row or column Click the row or column heading.


Adjacent rows or columns Drag across the row or column headings. Or
select the first row or column; then hold down SHIFT and select the last row
or column.
Nonadjacent rows or columns Select the first row or column, and then
hold down CTRL and select the other rows or columns.
More or fewer cells than the active selection Hold down SHIFT and
click the last cell you want to include in the new selection. The
rectangular range between the active cell and the cell you click becomes the
new selection.
Cancel a selection of cells Click any cell on the worksheet.


2.. On the Format menu, point to Row or Column, and then click Hide.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeR" wrote in message
...
Don Guillett wrote:

I wondered why I sent it?


Huh?

Try going to the help index and typing in
unhide column
When all else fails, RTFM


I did RTFM. It didn't work.