Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formatting

ResolvedVersion 2010

Formatting

I have a spread sheet when i minimise the sheet the data disappears, you can see in the tool bar the information is there but can't see it just blank cells appear back to full screen information appears, is it that i have too many formulars on the sheet or colour?

RE: Formatting

Hi Dina

Thanks for your question. I don't recognise the symptoms you describe as being a known problem with Excel.

One step towards troubleshooting the cause of the issue is to try and replicate the problem in a new spreadsheet. To do this create a new workbook, create some test data (rather than copy from the original workbook) and repeat the minimise / fullscreen actions. Do the cells is the new workbook also appear blank?

Kind regards,
Andrew

RE: Formatting

I've tried that it only affects this particular workbook, not sure what i have done to it.

RE: Formatting

Hi Dina

Thank you for coming back to me.

If the new workbook is OK the next step is to copy some data from the problem spreadsheet and paste it into your new spreadsheet and test again this time using real information.

Let me know how you get on.

Kind regards,
Andrew

Excel tip:

Quick Zooming in Excel with rollerball mouses

To zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.