K Kerry Jul 30, 2003 #1 You can use the File>Print Area>Set Print Area function to define the specific section of the worksheet you wish to print.
You can use the File>Print Area>Set Print Area function to define the specific section of the worksheet you wish to print.
G Gord Dibben Jul 30, 2003 #2 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
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
D Dave Peterson Jul 31, 2003 #3 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)
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)