If you have several workbooks open, you can tile all open workbooks using Arrange All from the View tab. But did you know that you can also view all your worksheets at the same time?
Here's how:
- Open the workbooks that have the worksheets you want to tile and save as tiles.
- On the View tab, in the Window group, click the New Window button as many times as the number of additional sheets you want to view. (For example, click it three times to give you an opportunity to view four sheets at the same time.)
- Click on the Arrange All button on the View tab.
- Select the option you want. (I prefer Tiled.)
- Tick the Windows of active workbook check box and click OK or press ENTER.
- In each window, click the sheet you want to view.
- Save the workbook as normal. (CTRL + S, anyone?)
Next time you open the workbook you will see the same arrangement. To restore the workbook to full size, simply click the Maximize (the middle) button in the upper right corner of one of the worksheets.
* Unless stated otherwise, these tips were written for Microsoft Office 2010
9 May 2016
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk
Roem Ltd is a Learning Collaboration approved supplier, having come recommended by Cambridge Network member organisations. Network membership means you automatically have the right to book on to any LC course at any time, while some categories of membership actually include LC training units.