ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I unhide columns previously hidden (https://www.excelbanter.com/excel-discussion-misc-queries/44235-how-do-i-unhide-columns-previously-hidden.html)

Maureen

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

B. R.Ramachandran

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


Bernie Deitrick

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




Bob Umlas

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





All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com