Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Cathy
 
Posts: n/a
Default How do I unhide the data in Excel?

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Cathy
 
Posts: n/a
Default

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   Report Post  
Jambruins
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
RagDyer
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM
pasting excel data in a powerpoint slide James Excel Discussion (Misc queries) 4 January 28th 05 02:23 PM
How do I plot Excel data on a floorplan? tod1west Excel Discussion (Misc queries) 1 January 28th 05 02:11 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"