Help with Excel anyone?

I'm printing from a long list in Excel 2003 , but picking out individual rows..does anyone know how to make print 'selection' the default rather than print 'active sheet (s)'
Cheers
Just dawned on me it could be the printers settings..Canon ix4000

 

There should be an option somewhere to "set print area". That would them be default.

But I am scratching the grey matter trying to remember 2003 though

 

But might not have read your post correctly thougg

 

What version of excel are you using?

 

Edit just read your post properly and can see you're using 2003.

 

I'm not certain in 2003 as its a long time since I've used it but I think the way to do it is to:

. highlight the cells you want to print.
. file, select print area, set print area.
. do a print preview first.
. print.

I know there are better ways in newer versions but not sure if they will work in 2003.

 

Cheers for that Nez. ..only snag...each selection could be a different number of rows.

 

I that case I think your out of luck if you are using different rows and want that option as the default. Don't think you can set it like that

 

Can't you just delete or hide the rows you don't want to print? Or perhaps use a filter.

Not quite sure what your issue is.

 

Hi.. the issue is , it would be useful to set 'print selection' as default...default currently is 'print active sheets' , I'm addressing hundreds of envelopes ..sometimes there may be one line of addresses...but there could be more...at the moment I'm having to set it to print selection every time..if I forget it prints out a whole sheet on one envelope.

 

I don't think you can default to 'print selection' as you have to select it each time you print. But you can filter unwanted rows and just do a print (active sheets) which would mean not having to change anything.

 

Probably this is best bet.

Although can you do something with mailmerge in word. And excel becomes the data source....

 

This.

Might be a bit of a faff to begin with because you'd need the formatting of each line to be the same. You can them just set up a mail merge in word and get it to print each line of a new envelope all in one go.

 

Agreed mailmerge is the tool you need, using excel as the source it takes the data and formats it into the correct prinatable format i believe.