Archive | May, 2016

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

Tame your computer – check it out!

7 May

Anybody who ever attended one of my courses or is an astute reader of my tip of the week knows I absolutely love keyboard shortcuts and that I am always on the lookout for new ones, especially if they are intuitive. Well, this week is for those people who prefer to use their mouse. It will help you to select multiple files, without having to hold down the CTRL key while clicking.

Here’s how:

  1. Press the WIN key (or click on the Start button if you must).
  2. Type folder options.
  3. Press ENTER.
  4. Press CTRL + TAB to open the View tab. (I know, I know, this is a tip about how not to use your keyboard, but I cannot help myself!)
  5. Scroll down the alphabetical list and tick the Use check boxes to select items box.
  6.  Click OK.

In future, in Windows Explorer (WIN + E, anyone?) you will see check boxes next to your items, making it easy to select multiple files or folders. And if you want, you can still hold down CTRL to select multiple items, without using the check boxes.