Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I unhide columns previously hidden
I hid a few columns earlier and now can not unhide them. I've done as
instructed - highlight the column before or after and click on unhide - but it does not seem to work - can anyone suggest another method? Thanks |
#2
|
|||
|
|||
Hi,
Highlight both the columns (before AND after) and click unhide. Regards, B. R. Ramachandran "Maureen" wrote: I hid a few columns earlier and now can not unhide them. I've done as instructed - highlight the column before or after and click on unhide - but it does not seem to work - can anyone suggest another method? Thanks |
#3
|
|||
|
|||
Maureen,
They may not be hidden, just very thin. Try the same method, but set the width to some number (say, 10) instead of using unhide. HTH, Bernie MS Excel MVP "Maureen" wrote in message ... I hid a few columns earlier and now can not unhide them. I've done as instructed - highlight the column before or after and click on unhide - but it does not seem to work - can anyone suggest another method? Thanks |
#4
|
|||
|
|||
You can use F5 (edit/go to) and go to any cell in the hidden column, like F1
(if F is hidden), then use Format/Column/Unhide. You can select the column before THRU the column after, like E:G and use Format/Column/Unhide. You can also position the cursor just a hair to the right of the column separator and the cursor will change shape to a vertical bar with a two-headed arrow. Click and drag to the right. Bob Umlas Excel MVP "Maureen" wrote in message ... I hid a few columns earlier and now can not unhide them. I've done as instructed - highlight the column before or after and click on unhide - but it does not seem to work - can anyone suggest another method? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
How to "ignore" hidden columns? | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
I can't unhide 3 columns previously hidden | Excel Discussion (Misc queries) |