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.
--
Gary''s Student - gsnu200821


"BJS" wrote:

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?

I can't hide the columns as it is an active report. Any other suggestions?

"BJS" wrote:

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?

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 wrote:

I can't hide the columns as it is an active report. Any other suggestions?

"BJS" wrote:

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?

--

Dave Peterson

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

"BJS" wrote:

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?

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

Bill