How to print separated, selected columns on a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)?
 
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
 
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?
 
NavyPianoMan said:
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)?
Click to expand...

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.
 
Sounds interesting. How would I "reference" between the two sheets? Can you
give an example?
 
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.
 
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
 
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
 
how did you hide it?

if it is column D try selecting columns C:E and
format-column-width select a value
 
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
 
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)?
 
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.)
 
Back
Top