That approach works well if you have only two files open-but the more files you add, the more you might cycle through them, going in the wrong direction and then wasting time circling back. You can switch between worksheets by pressing Ctrl-Tab or, to go in the other direction, Ctrl-Shift-Tab. Unless your worksheets are exceptionally small, you should keep the inner windows maximized (the default setting) so that they fill the whole Excel window. You can maximize internal windows so that each one fills the entire Excel window, or restore them to view them all at once.
When you open or create another workbook (an Excel file that can contain one or more worksheets), that opens an internal window within the Excel window. When you launch Excel, it opens a single window on the Windows desktop. In Excel you have two clear and obvious ways to work on three or more spreadsheets: You can have too-small windows that don't give you the big picture, or you can clumsily switch between them.Īrrange your windows so that you can see multiple workbook files at the same time.
#Get excel to stop prompting for network connection at startup on mac how to
I'll tell you how to manage multiple workbooks effortlessly, speed up a slow file, track changes from multiple users, find the feature you need among all the ribbons, and enter data more easily. I'm here to help, with solutions to five common nightmares found in Excel 20. And if you find that using Excel is more difficult than tracking your finances with a pencil and paper, something isn't adding up properly.
Let's face it: If you do a significant amount of important work in Excel, you're dealing with one nightmare after another. Trying to edit multiple files at one time becomes a game of "Find the worksheet." You know that the feature you need is on one of the ribbons, but which one? And a large, funky workbook file can slow the program down so much, you need to take a coffee break after altering a single number. Have you ever wondered if Microsoft Excel was invented by a sadist?
0 kommentar(er)
