| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Unhide Columns A,B,C after hiding them
Thank you to all
Will now never forget Rgds Mark |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide and hide columns | Excel Worksheet Functions | |||
| I cannot unhide columns | Excel Discussion (Misc queries) | |||
| How do I unhide columns | New Users to Excel | |||
| Unhide Columns A and B. | Excel Discussion (Misc queries) | |||
| Need to unhide 2 columns that I joined together - Help! | Excel Discussion (Misc queries) | |||
Hybrid Mode
