spreadsheet contents have become hidden from view

G

Guest

I was able to view the entire contents of my spreadsheet ,which contains
names and number data only and no formulae ,but something has happened and now
I can see the contents of 1 cell only which is displayed in the toolbar and
yet
I can still view the entire spreadsheet contents via print preview.
Can someone tell me how to recover my spreadsheet data back into view so
that I can edit it.
 
C

Clivey_UK

Not quite sure what caused this but try selecting the whole sheet and
doing Edit/Copy and then going to another sheet and doing Edit/paste
special/Value. Or could just be Excel having problems so close/reopen
Excel if you haven't already tried.
Clive (a different one!) :)
 
B

broro183

Hi Clive,

I have seen something similar when a workbook was protected, is yours?
If so, unprotect it & you should be able to change the view.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience..
 

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

Similar Threads

spreadsheet disappeared 2
print excel spreadsheet splitting cell contents on multiple pages 2
How do I print only cell contents of a Excel 2007 spreadsheet? 2
Hidden content 4
Excel 2007 - Spreadsheet does not appear 5
Printing Entire Contents of Cell 1
Macro: finding a cell on one worksheet and copying to another worksheet 0
Hidden cell contents with text wrapping 2

Top