98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting
Formatting
Resolved · High Priority · Version 2010
Mon 15 Aug 2011, 16:47Delegate Dina said...
Dina has attended:
Excel Advanced course
Project Management - Framework & Processes course
Introduction to Management course
Time Management course
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?
Tue 16 Aug 2011, 10:55Trainer Andrew said...
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
Tue 16 Aug 2011, 13:49Delegate Dina said...
RE: Formatting
I've tried that it only affects this particular workbook, not sure what i have done to it.
Tue 16 Aug 2011, 16:14Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |
