A few options:

1. Streamline the process of hiding the columns you don't want to
print. In the row below your print range, put an X (anything but a
blank will do) in the columns you want to print. Before you print,
you select that row, then Go To (F5) then special, then select blanks,
format columns hide to hide the ones you don't want all at once. You
can build that into the Before Print Event if you like.

2. Rearrange your data so the columns you want to print are
contiguous.

3. Echo the columns you want to print somewhere to the right of where
you work on the columns. For example, you could have columns 9
through 13 equal 1,2,3,7 and 8; and make columns 9 through13 your
print range, but, manipulate the data in columns 1 through 8.

Good luck.

Ken
Norfolk, Va


On Jul 9, 2:52 pm, MariVi wrote:
I made a sheet in Excel of 9 columns, when I print them, I only need to see
printed columns number 1, 2, 3, 7 and 8 in one page and like if column number
4, 5 and 6 weren't there. Is there any way to do this, without doing "right
click" then "hide" the columns and then print, and then select them again and
unhide when I have to work with them? I hope, I really hope I made myself
understood... Thanks.