Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formatting

Resolved · High Priority · Version 2010

Reply Mon 15 Aug 2011, 16:47Delegate Dina said...

Dina has attended:
Excel Advanced 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?

For upcoming training course dates see: Pricing & availability

Reply 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

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

Reply 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

Excel articles

· How Excel Can Transform All Of Your Office Documents
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· How To Create Formulas In Excel
· How To Use The Cell Styles Functionality In Excel 2010
· From the Classroom to the Corporate World

Please browse our web site to find out more about
excel vba training course london and other Microsoft training courses.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips