spreadsheet disappeared

D

DT

Somehow my spreadsheet disappeared while I was working in it. This is a
multi-worksheet spreadsheet & I am still able to view the other worksheets.
When I look at the screen everything is there except the cells & the column
bar so it is not hidden. By clicking control+home I am able to view the
contents of cell A1 in the formula box. By using the arrow keys I can view
the other cells in column A. No other cells are accessible. Nothing is
available in print preview & I can’t print anything. The same settings are
used on this worksheet as the others in the Tools/Options/View. Any ideas?
 
O

OssieMac

Your comment “When I look at the screen everything is there except the cells
& the column barâ€

You may have accidently hidden the columns. Can you still see the row
identifiers? If so then click in the blank rectangle above the top row number
and then select Format -> Column -> Unhide.

If you can’t see the row numbers then Ctrl/Home and then select Format ->
Row -> Unhide then repeat the above step for both column - > Unhide and if
necessary Row -> Unhide.

If working in xl2007 then on the Home ribbon, cells block it is Format ->
Hide & Unhide -> Unhide Rows or Unhide columns.
 
D

DT

Magic - Thank you!!!!
--
DT


OssieMac said:
Your comment “When I look at the screen everything is there except the cells
& the column barâ€

You may have accidently hidden the columns. Can you still see the row
identifiers? If so then click in the blank rectangle above the top row number
and then select Format -> Column -> Unhide.

If you can’t see the row numbers then Ctrl/Home and then select Format ->
Row -> Unhide then repeat the above step for both column - > Unhide and if
necessary Row -> Unhide.

If working in xl2007 then on the Home ribbon, cells block it is Format ->
Hide & Unhide -> Unhide Rows or Unhide columns.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top