Print Preferences

[Kerry]

You can use the File>Print Area>Set Print Area function
to define the specific section of the worksheet you wish
to print.

 

[Gord Dibben]

Bruce

On my two versions of Excel, the default is "Active Sheet". I cannot recall
anyone coming up with a way to change this default to "selection".

I attempted once to see if any Registry entry could be modified, but found
none.

Next best if you want a one-click method is a macro.

Sub Print_Selection()
Selection.PrintOut Copies:=1
End Sub

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Dave Peterson]

If you show the dialog box, you can hit alt-n to print the selection. (might be
quicker than mousing).

If you wanted a macro, maybe you could put Gord's macro into your personal.xls
file and assign it a memorable shortcut key. (Ctrl-shift-P)