1

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
or
b) Set a print area over multiple sheets so I can print without needing to select multiple sheets.

I am using Excel 2007

Improve this question

3 Answers 3

Reset to default
1

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.
Improve this answer
0

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.

Improve this answer
0

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

a) http://www.vbaexpress.com/kb/getarticle.php?kb_id=125

b) http://excel.tips.net/Pages/T003157_Setting_Print_Ranges_for_Multiple_Worksheets.html

Improve this answer
1
  • 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, 2009 at 4:11

You must log in to answer this question.

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