Print Selection Range (XP)

Topic

New Reply

I normally use QuattroPro and I when I have selected a range of cells I want printed and go to the print menu, “print the selected cells” is automatically chosen. However, in Excel I have to expressly click that choice. Is there a way to make Excel default to the range selected when printing as QuattroPro does?

Thanks!

Reply | Quote

Replies

As far as I know, I know of no way to change the default in excel.

You could create macro in your personal.xls (see post 118382 for LegareColeman‘s tutorial ) with the code:

Sub PrintSelection()
    Selection.PrintOut
End Sub

and then attach it to a toolbar button and add it to a toolbar (next to the regular print button perhaps) and when you clicked on this it would print just the selection.

Steve

Reply | Quote

Thanks, Steve. I’ll tackle that today. Haven’t done all that much with macros in Excel so this ought to be fun.

Peggy

Reply | Quote

You could also permanently put the “Set Print Area” icon to the ToolBar; that will get you down to two clicks, but may also require that you reset the Print Area for “publishing”. View |Toolbars |Customize | Commands | from the Categories box select File, then in the Commands Box scroll down to Set Print Area, drag the icon onto the TB.

Reply | Quote

That sounds like a good alternative. I’ll try both ways.

Thanks.

Reply | Quote

That sounds like a good alternative. I’ll try both ways.

Thanks.

Reply | Quote

You could also permanently put the “Set Print Area” icon to the ToolBar; that will get you down to two clicks, but may also require that you reset the Print Area for “publishing”. View |Toolbars |Customize | Commands | from the Categories box select File, then in the Commands Box scroll down to Set Print Area, drag the icon onto the TB.

Reply | Quote

Thanks, Steve. I’ll tackle that today. Haven’t done all that much with macros in Excel so this ought to be fun.

Peggy

Reply | Quote