How to print separated, selected columns on a worksheet

[Guest]

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)?

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

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)?

You could use one sheet for "Data" and a second sheet for "Presentation" or
"Printing" with a reference in the "Presentation" cell to the cell in the
"Data" sheet. With this method you can separate calculation requirements
from viewing or printing requirements. This allows for more flexibility in
presenting the data in the format that you wish.

 

[Guest]

Sounds interesting. How would I "reference" between the two sheets? Can you
give an example?

 

[Dave Peterson]

You may be able to use this technique:

Insert a new sheet
copy the first range to be printed.
go to A1 of the new sheet
Shift-Edit|Paste picture link

Repeat for each range to be printed and paste under (or to the right) of the
pasted pictures.

Then print this new worksheet.

By pasting a picture link, if the original data changes, so will the picture.

 

[Dave Peterson]

Say you hid column Z.

Edit|Goto
type Z1
format|Column|Unhide

Say you hid columns Q to Z
Edit|goto
type Q:Z
format|column|unhide

 

[Zone]

Click on the rectangle above the row numbers and to the left of the column
letters. Click on Format on the menubar, then Columns, then Unhide. James

 

[Guest]

how did you hide it?

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

 

[Guest]

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

 

[Guest]

I tried it and it worked nicely. Later, I wanted to revise it and tried to
delete the first column. But EXCEL just slid the columns over it (it was
still visible). How can I make revisions using your suggested method
(without redoing the entire page)?

 

[Dave Peterson]

Do you mean you deleted a column from the picture worksheet?

Remember, you're not really working with columns. You're working with
pictures. You'd have to delete the picture. (And replace the picture with
another picture.)