Archive for January, 2011

Simple screenshots with dual monitors

Screenshots need to happen from time to time. For my tips I use them all the time, but many of you need to share a screen grab for many and varying reasons. Sometimes we have an error we need to show to IT, or we just got an awesome new desktop wallpaper that deserves attention. Since dual screens are becoming much more common, screenshots are a little more difficult. Here is a quick and easy way to make sure you get what you want.

Screenshots showing only one screen:


  1. Place your cursor on the screen from which you want a screenshot. Make sure there is a program window on that screen, otherwise you will get a shot of both screens anyway.
  2. Hit CTRL + ALT + PrtScn on your keyboard.
  3. Hit CTRL + V to paste the screenshot in Word, Paint, an email, or whatever else you can paste it into.

Screenshot showing both screens:


  1. Hit CTRL + PrtScn on your keyboard.
  2. Hit CTRL + V to paste the screenshot in Word, Paint, an email, or whatever else you can paste it into.

Screenshot of just the active window (no matter the size):


  1. Hit ALT + PrtScn on your keyboard.
  2. Hit CTRL + V to paste the screenshot in Word, Paint, an email, or whatever else you can paste it into.

If you want WAY more options when creating screenshots, see my post on ZScreen.



Excel: tutorial on controlling conditional formatting with a checkbox has a cool tutorial on a unique use of conditional formatting in Excel. How and when to use this method is only limited to your creativity, but I can see it being useful for applying a format only when printing a document.

From the tutorial:

The checkboxes from the Forms toolbar return either a TRUE or FALSE value (checked/not checked) to their linked cell. By combining a checkbox from the Forms toolbar with conditional formatting using the Formula Is option (shown in Figure 2-1), you can turn conditional formatting on and off via a checkbox.

Figure 2-1. The Conditional Formatting dialog with the Formula Is option


The whole routine is a little involved and pretty nerdy, but the results are super cool.

Have a look for yourself: Control Conditional Formatting with Checkboxes

1 Comment

DownloadSquad: “How to hide the Ribbon menu in Microsoft Office applications”

I may have shared a similar tip before, but this one is always useful. Some folks feel like the Ribbon is just a little too bulky, and the DownloadSquad shares a couple of ways to keep it hidden but accessible.

From the article:

To collapse it, simply double-click one of the Ribbon’s tabs, such as “Home”. The whole thing will instantly shrink down to the line of tabs. Clicking a tab will temporarily expand it back. If you’d rather do the same thing using the keyboard, simply hit Ctrl+F1 (that’s what I normally do).

DownloadSquad: How to hide the Ribbon menu in Microsoft Office applications

1 Comment

Excel: Check the print area quickly for all sheets in a workbook

We all hate it when we print a workbook that contains several dozen worksheets only to find out later that one worksheet had a column cut off or split to another page. Many of us have adopted the practice of checking the print area of each worksheet one by one to make sure this doesn’t happen. The problem is that you have to set the view to “Page Break Preview” for each worksheet. I have found a little trick to speed up that process.

To set the view for all worksheets at once:

  1. Click on the first tab in the workbook.
  2. While holding SHIFT, click on the last tab in the workbook.
  3. On the ribbon, go to the View tab and click “Page Break Preview”
  4. OR click on the Page Break Preview button at the bottom of the screen (next to the zoom slider)
  5. For good measure, zoom out to around 50%
  6. Currently, the tabs are selected in a group. Before doing anything else, go back to single-worksheet mode.
    1. If ALL tabs are selected: click on one of them.
    2. If only some of the tabs are selected: click on an unselected tab.
    3. You’ll be safe when the title bar no longer contains the “[Group]” as shown below:

Now all of the worksheets should be in Page Break Preview mode. Now you may check each worksheet’s print area.


Click and drag the blue lines to change the print area.


%d bloggers like this: