ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Unhide Columns A,B,C after hiding them (https://www.excelbanter.com/excel-discussion-misc-queries/131218-how-unhide-columns-b-c-after-hiding-them.html)

mark

How to Unhide Columns A,B,C after hiding them
 
Hello All,
I've hidden columns A,B,C and have forgotten how to unhide/show them
again.

Can someone help please?

Rgds
Mark


Gary''s Student

How to Unhide Columns A,B,C after hiding them
 
click that upper left-hand square where the row and column headers meet (to
select the entire worksheet)

Format Column Unhide
--
Gary''s Student
gsnu200706


"mark" wrote:

Hello All,
I've hidden columns A,B,C and have forgotten how to unhide/show them
again.

Can someone help please?

Rgds
Mark



Dave Peterson

How to Unhide Columns A,B,C after hiding them
 
Edit|goto
type
a1:c1
in that bottom box
Then format|column|Unhide.

If you still can't see them, try scrolling to the left.

If you still can't see them, try Window|Unfreeze Panes.

mark wrote:

Hello All,
I've hidden columns A,B,C and have forgotten how to unhide/show them
again.

Can someone help please?

Rgds
Mark


--

Dave Peterson

Bernard Liengme

How to Unhide Columns A,B,C after hiding them
 
Hide essentially make the column width zero.
Put the mouse cursor in the first left-hand column header (D), move it
slowly towards the square where column and row headers meet, watch for the
point to change to something like <-||- and drag to the right to restore
one column at a time.
These should be a better way!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mark" wrote in message
oups.com...
Hello All,
I've hidden columns A,B,C and have forgotten how to unhide/show them
again.

Can someone help please?

Rgds
Mark




mark

How to Unhide Columns A,B,C after hiding them
 
Thank you to all

Will now never forget

Rgds
Mark


MartinW

How to Unhide Columns A,B,C after hiding them
 
One more way,

Say columns D, E and F are hidden.
Your column headers will read A, B, C, G, H etc.

Just highlight the two columns either side of the hidden columns,
in this example it would be C and G.

Right click and select Unhide.

HTH
Martin




All times are GMT +1. The time now is 02:50 PM.

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