Adding columns

B

BJS

How do you select 3 columns then skip the next four columns, select the next
5 columns and then make a report that will fit and print landscape mode?
 
G

Gary''s Student

Temporarily hide the columns you don't want printed. Pick Landscape in the
print setup menu.
 
D

Dave Peterson

Record a macro when you hide the columns, print the report, and then unhide the
columns.

Then rerun this macro whenever you need to print.

The columns won't be hidden permanently (unless you want them hidden). They'll
be visible before you even notice!
 
B

Bill Sharpe

BJS said:
I can't hide the columns as it is an active report. Any other suggestions?
Click to expand...

Copy the columns of interest to a new worksheet, then print.

Bill
 
Top