When you are using Excel, you are not limited to working with a single workbook. You can open as many workbooks as you like, and Excel keeps track of them individually. You can then switch between workbooks by using the Windows menu.
If you have a single workbook open and you choose the Windows menu, you will notice the workbook name at the bottom of the menu. If you have multiple workbooks open, each workbook name is listed at the bottom of the menu and the currently active workbook is indicated by a checkmark to the left of the workbook name. To work with a different workbook, simply select the desired workbook from the menu.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1987) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
You can create a default template for both your workbooks and worksheets. These should be placed in the xlstart folder, ...
Discover MoreNeed to open a bunch of workbooks from within Excel? It's easy to do when you construct a selection set in the Open ...
Discover MoreWhen you copy workbooks that contain links, you may be at a loss as to how to update those links. There are a couple of ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-08-25 15:29:48
TA Stone
I just did the 2016 upgrade to my Windows 7 system. I am unable to run a macro in one Excel workbook and work in another workbook. Is there a setting with will make the workbooks independent? I open them independently not stacked.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments