Adding columns

  • Thread starter Thread starter BJS
  • Start date Start date
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?
 
Temporarily hide the columns you don't want printed. Pick Landscape in the
print setup menu.
 
I can't hide the columns as it is an active report. Any other suggestions?
 
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!
 
BJS said:
I can't hide the columns as it is an active report. Any other suggestions?

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

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top