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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Not satisfied with the way that default workbooks and worksheets look in Excel? You can easily create your own defaults for ...
Discover MoreWhen you need to work on a workbook, you may want to do so without modifying the original contents of the workbook. This is ...
Discover MoreTired of your workbooks being left open on the screen where they can be seen by anyone passing by? Here's a way to have Excel ...
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 © 2017 Sharon Parq Associates, Inc.
Comments