View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
NavyPianoMan NavyPianoMan is offline
external usenet poster
 
Posts: 25
Default How to print separated, selected columns on a worksheet

I right-clicked the top of the column and hit "Hide".
I also figured out how to "Unhide": I just right-clicked the columns on
either side and then hit "Unhide".
Thanks,
--NavyPianoMan

"bj" wrote:

how did you hide it?

if it is column D try selecting columns C:E and
format-column-width select a value

"NavyPianoMan" wrote:

Ok, I just tried the "hide" method with a column. But now I can't unhide
it--I can't even CTRL-Z (undo) it.
How do I get it back?

"bj" wrote:

Two ways to do what you want.
set up a sheet for printing and format it as you want and just have cells
you want on the sheet
or
hide the columns you don't want to print

"NavyPianoMan" wrote:

I only want to print certain columns from my worksheet. I'm using CTRL to
select discrete columns. Is it possible to just print these columns fitted
to one page (without space inbetween and without each column placed on a
separate page)?