Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unhide columns after worksheet was closed
im at work and accidentally closed an excel sheet with name address ect. I had
hide all columns except 2 i was working in , and when closed i hit save changes. Now i need to unhide those columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
unhide columns after worksheet was closed
Select the entire worksheet by clicking in the upper left hand corner of the
worksheet. Right click on one of the column headings and select "unhide" Note that if you have frozen the window you may need to unfreeze the window via the Window menu in order for your columns to appear. Dave -- Brevity is the soul of wit. "cheryl_phillips" wrote: im at work and accidentally closed an excel sheet with name address ect. I had hide all columns except 2 i was working in , and when closed i hit save changes. Now i need to unhide those columns. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
unhide columns after worksheet was closed
Select all cells in your worksheet. Select Format-Column-Unhide.
Regards, Paul "cheryl_phillips" wrote in message ... im at work and accidentally closed an excel sheet with name address ect. I had hide all columns except 2 i was working in , and when closed i hit save changes. Now i need to unhide those columns. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
unhide columns after worksheet was closed
cells button or select columns before to columns afterformatcolumnunhide
-- Don Guillett SalesAid Software "cheryl_phillips" wrote in message ... im at work and accidentally closed an excel sheet with name address ect. I had hide all columns except 2 i was working in , and when closed i hit save changes. Now i need to unhide those columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reduce the no. of rows & columns in a worksheet ? | Excel Discussion (Misc queries) | |||
Columns A, B, C , D & E won't unhide in Excel 2003 | Excel Discussion (Misc queries) | |||
How to auto hide and unhide columns using 1 and 2 icons | Excel Worksheet Functions | |||
Trying to do Vlookup on multiple columns from different worksheet | Excel Worksheet Functions | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) |