Thread: Adding columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Adding columns

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