Tame your computer – try tiling it!

14 May

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:

  1. Open the workbooks that have the worksheets you want to tile and save as tiles.
  2. 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.)
  3. Click on the Arrange All button on the View tab.
  4. Select the option you want. (I prefer Tiled.)
  5. Tick the Windows of active workbook check box and click OK or press ENTER.
  6. In each window, click the sheet you want to view.
  7. 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: