Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have setup a excel worksheet that uses multiple sheets for calculations that don't need to be printed. My entire workbook has 8 sheets and I normally only print the first 4. The workbook may be printed multiple times as I am editing it.

My problem is after selecting the sheets I want to print, and printing them, they stay selected. I often forget to un-select them and start editing. That in turn affects the given cell on all of the selected worksheets. I usually realize this too late and have to rebuild part of my worksheet.

Is there a way to either:
a) force the group of worksheets to be un-selected after printing
b) Set a print area over multiple sheets so I can print without needing to select multiple sheets.

I am using Excel 2007

share|improve this question
up vote 1 down vote accepted

Just record a macro.

I would save the macro to the file itself, and create a shortcut key for it so that all you have to do is press 'ctrl+shift+p', for example, and it will print the desired sheets and return the workbook to just having one sheet selected.

  1. Press record
  2. select the sheets to print
  3. Print
  4. ungroup the sheets
  5. stop recording.
share|improve this answer

I'm not sure if there's a way to automatically force it to do so, but you could attempt to get in the habit of using the hot keys to navigate off of the multiple spreadsheets by using CTRL + PageUp/PageDown.

share|improve this answer

You could use a macro assigned to a hot key, for either of the options



share|improve this answer
Looking at those links I see ways to set or clear a print area on multiple sheets, but that is not what I need. I either need to clear the selected sheets, or print out multiple sheets - i.e. sheets 1-4 without first selecting them. – Mark Elder Sep 10 '09 at 4:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .