![]() |
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 |
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 |
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 |
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 |
How to Unhide Columns A,B,C after hiding them
Thank you to all
Will now never forget Rgds Mark |
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