Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I did not want to hide the worksheet completely but did not want to display
the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! |
#2
![]() |
|||
|
|||
![]()
Goto FormatSheetsUnhide and see if you can select it there.
-- HTH Bob Phillips "Cathy" wrote in message ... I did not want to hide the worksheet completely but did not want to display the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! |
#3
![]() |
|||
|
|||
![]()
No. When you hide the worksheet in Excel, the tab and everything disappears.
In this case, the tab is available but the sheet is gray. "Bob Phillips" wrote: Goto FormatSheetsUnhide and see if you can select it there. -- HTH Bob Phillips "Cathy" wrote in message ... I did not want to hide the worksheet completely but did not want to display the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! |
#4
![]() |
|||
|
|||
![]()
Use the shift command and highlight the column to the left and right of the
hidden columns. Then right click and select unhide. "Cathy" wrote: No. When you hide the worksheet in Excel, the tab and everything disappears. In this case, the tab is available but the sheet is gray. "Bob Phillips" wrote: Goto FormatSheetsUnhide and see if you can select it there. -- HTH Bob Phillips "Cathy" wrote in message ... I did not want to hide the worksheet completely but did not want to display the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! |
#5
![]() |
|||
|
|||
![]()
Maybe you hid all the rows (or columns).
Ctrl-a (twice in xl2003) to select all the cells (even if you can't see them) Format|column|Unhide or format|row|unhide Cathy wrote: No. When you hide the worksheet in Excel, the tab and everything disappears. In this case, the tab is available but the sheet is gray. "Bob Phillips" wrote: Goto FormatSheetsUnhide and see if you can select it there. -- HTH Bob Phillips "Cathy" wrote in message ... I did not want to hide the worksheet completely but did not want to display the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! -- Dave Peterson |
#6
![]() |
|||
|
|||
![]()
Try either of these:
<Format <Row <Unhide <Format <Column <Unhide -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Cathy" wrote in message ... No. When you hide the worksheet in Excel, the tab and everything disappears. In this case, the tab is available but the sheet is gray. "Bob Phillips" wrote: Goto FormatSheetsUnhide and see if you can select it there. -- HTH Bob Phillips "Cathy" wrote in message ... I did not want to hide the worksheet completely but did not want to display the information until a specific date so I did something that made the entire worksheet grey. Problem is I forgot how I did it and how to restore it. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
pasting excel data in a powerpoint slide | Excel Discussion (Misc queries) | |||
How do I plot Excel data on a floorplan? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |