How to print separated, selected columns on a worksheet
 

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

How to print separated, selected columns on a worksheet
 

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

How to print separated, selected columns on a worksheet
 

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

How to print separated, selected columns on a worksheet
 

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


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.

How to print separated, selected columns on a worksheet
 

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

"Bontrager" wrote:



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


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.

How to print separated, selected columns on a worksheet
 

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.

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

--

Dave Peterson

How to print separated, selected columns on a worksheet
 

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



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


--

Dave Peterson

How to print separated, selected columns on a worksheet
 

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

"NavyPianoMan" wrote in message
...
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)?

How to print separated, selected columns on a worksheet
 

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

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

How to print separated, selected columns on a worksheet
 

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" wrote:

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.

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

--

Dave Peterson

How to print separated, selected columns on a worksheet
 

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

NavyPianoMan wrote:

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" wrote:

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.

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

--

Dave Peterson


--

Dave Peterson