spreadsheet disappeared
 

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 cant print anything. The same settings are
used on this worksheet as the others in the Tools/Options/View. Any ideas?

--
DT

spreadsheet disappeared
 

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 cant 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.

--
Regards,

OssieMac


"DT" wrote:

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 cant print anything. The same settings are
used on this worksheet as the others in the Tools/Options/View. Any ideas?

--
DT

spreadsheet disappeared
 

Magic - Thank you!!!!
--
DT


"OssieMac" wrote:

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 cant 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.

--
Regards,

OssieMac


"DT" wrote:

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 cant print anything. The same settings are
used on this worksheet as the others in the Tools/Options/View. Any ideas?

--
DT