non vba way to print non continuous ranges

[DavidObeid]

Hi,

Is there a non vba way to print non continous ranges on the one shee
using excel?

Specifically, lets say I want to print data from columns A, B, C, G an
K down to row 35 in each column. Is there a way I can do that withou
manually making them continuous by cutting and pasting each range ont
a new sheet?

Regards,

David Obei

 

[Myrna Larson]

You can hide the columns before printing. That's a nuisance to do it manually
each time, but easy with VBA (which you say you don't want).

Another way is to insert a new worksheet to be used just for printing

Select the first of your 3 regions (i.e. A1:C35) then Edit Copy. Switch to the
new sheet, select the right location, then hold down the SHIFT key and click
Edit. Now you'll see the option to Paste Picture Link. Do that. Repeat for
regions G1:G35 and K1:K35. Print this sheet.

 

[Gord Dibben]

David

Set your print area columns A through K down to row 35.

Hide the columns you don't want printed.

Gord Dibben Excel MVP

 

[Debra Dalgleish]

You can use Custom Views -- one with all the columns visible, and one
with hidden columns:

Choose View>Custom Views
Click Add
Type a name for the Custom View, e.g. AllVisibile
Check the box for 'Hidden rows, columns and filter settings'
Click OK

Hide the columns you don't want to print
(right-click on a column heading button, and choose Hide)

Choose View>Custom Views
Click Add
Type a name for the Custom View, e.g. HiddenColumns
Check the box for 'Hidden rows, columns and filter settings'
Click OK

To print the worksheet, choose View>Custom Views, select the
HiddenColumns view, click OK

After printing, show the AllVisible Custom View.