How do I print certain (specifics) columns in Excel spread sheet?
 

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.

How do I print certain (specifics) columns in Excel spread sheet?
 

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.

How do I print certain (specifics) columns in Excel spread sheet?
 

How about using a dedicated macro?

Record a macro when you hide the columns, print the worksheet and unhide those
columns. Then stop recording.

You can run that macro whenever you want to print.



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.

--

Dave Peterson

How do I print certain (specifics) columns in Excel spread sheet?
 

If you are doing this often, set up two Custom Views and just switch from one to
the other under ViewCustom Views


Gord Dibben MS Excel MVP

On Mon, 9 Jul 2007 11:52:06 -0700, 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.