Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Selection Range (XP)

    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!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Print Selection Range (XP)

    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>post 118382</post#> for <!profile=LegareColeman>LegareColeman<!/profile>'s tutorial ) with the code:

    <pre>Sub PrintSelection()
    Selection.PrintOut
    End Sub</pre>


    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

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Selection Range (XP)

    Thanks, Steve. I'll tackle that today. Haven't done all that much with macros in Excel so this ought to be fun. <img src=/S/groan.gif border=0 alt=groan width=16 height=15>

    Peggy

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Print Selection Range (XP)

    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.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Selection Range (XP)

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

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •