excel computer training london - closing spreadsheets

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - Closing spreadsheets

excel computer training london - Closing spreadsheets

resolvedResolved · Low Priority · Version Standard

Nick has attended:
Excel Introduction course
Word Introduction course
Word Introduction course

Closing spreadsheets

When I close a spreadsheet in excel it closes down all other spreadsheets that are open on my computer. This occurs even if i have minimised the sheet, meaning it can not be attributed to a sticky key. Any ideas please?

RE: closing spreadsheets

Hi Nick

Thanks for your question.

This might be occuring because you are clicking on the 'X' button to close the Excel program (which will close all Excel files you have open) rather than the 'X' button just to close the file you are working on.

The 'X' button in the very top right of your screen closes all Excel files whereas the 'X' button underneath it closes just the one Excel file.

Let me know if this solves your problem or not.

thanks
Amanda

RE: closing spreadsheets

Thanks for that, it did the job!

thanks for being so quick as well, you've saved me a day's worth of frustration

RE: closing spreadsheets

Hi Nick

No problem, happy to help.

The same applies to closing a program and closing files across all Microsoft applications.

Have a good day
Amanda


 

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Server loaded in 0.14 secs.