If multiple workbooks are opened then at any given time only one workbook will be active. To switch to another workbook, you have to activate that workbook. There are several ways for switching among open workbooks in Microsoft Excel.
1. From the Windows taskbar, click the Excel workbook that you need to open.
2. In Microsoft Excel, click View tab from the Ribbon and click Switch Windows. You will see the list of workbooks that are opened. The same can be performed by pressing Alt + W + W + (The number corresponding to the workbook).
3. You may add the Switch Windows button to the Quick Access Toolbar so that you can switch among workbooks quickly. To add the Switch Windows button, click the down arrow that is present in the Quick Access Toolbar and then click More Commands… to open Excel Options dialog box. From the Choose commands from dropdown box, click View Tab. Select Switch Windows from the left side of the selection box and then click Add >>. Finally click OK.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
