I want to resize a range of cells in a column. How is this done?

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?

In an excel worksheet I have two tables - one on top of the other. Each
table contains different data in the columns, and therefore the columns are
not of equal size all the way down the sheet. I.E.:

Table #1: Part Name Part # Part Description QTY

Table #2: QTY Part# Part Description Ordered By

The tables must be displayed this way when printed (one on top of the
other) but I do not want the QTY column in table 2 to be as wide as the Part
Name column in table 1. Does this make sense?














"Don Guillett" wrote:

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?

I've found that the best way to make these kinds of tables is to use two
different worksheets. It really makes life much easier.

If there's a reason that you have to print on a single sheet, then you could do
this--after you put the tables on separate sheets.

Select the table on Sheet1
edit|Copy
select A1 of Sheet3 (the new sheet)
Shift-edit|Paste picture link

Then off to the table on sheet2
edit|copy
select the cell under the picture of the first table.
shift-edit|Paste picture link

By pasting the pictures as links, any updates you make to the table will show up
in the picture.

terri wrote:

In an excel worksheet I have two tables - one on top of the other. Each
table contains different data in the columns, and therefore the columns are
not of equal size all the way down the sheet. I.E.:

Table #1: Part Name Part # Part Description QTY

Table #2: QTY Part# Part Description Ordered By

The tables must be displayed this way when printed (one on top of the
other) but I do not want the QTY column in table 2 to be as wide as the Part
Name column in table 1. Does this make sense?













"Don Guillett" wrote:

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?




--

Dave Peterson

It looks like it will definetly work, but with some practice. I keep getting
the message that my table (the second one) is too big and will be truncated.
I played with it until I got what I wanted on the sheet, but when I do a view
I can see that the worksheet contain gridlines. This is where I have trouble
- I unchecked Gridlines in the Page Set Up, and did a practice print, but the
gridlines are printing on the entire worksheet. I don't want that. I'm
still playing with it, and thanks for your help.

"Dave Peterson" wrote:

I've found that the best way to make these kinds of tables is to use two
different worksheets. It really makes life much easier.

If there's a reason that you have to print on a single sheet, then you could do
this--after you put the tables on separate sheets.

Select the table on Sheet1
edit|Copy
select A1 of Sheet3 (the new sheet)
Shift-edit|Paste picture link

Then off to the table on sheet2
edit|copy
select the cell under the picture of the first table.
shift-edit|Paste picture link

By pasting the pictures as links, any updates you make to the table will show up
in the picture.

terri wrote:

In an excel worksheet I have two tables - one on top of the other. Each
table contains different data in the columns, and therefore the columns are
not of equal size all the way down the sheet. I.E.:

Table #1: Part Name Part # Part Description QTY

Table #2: QTY Part# Part Description Ordered By

The tables must be displayed this way when printed (one on top of the
other) but I do not want the QTY column in table 2 to be as wide as the Part
Name column in table 1. Does this make sense?













"Don Guillett" wrote:

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?




--

Dave Peterson

Tools|Options|View tab|uncheck gridlines????????

terri wrote:

It looks like it will definetly work, but with some practice. I keep getting
the message that my table (the second one) is too big and will be truncated.
I played with it until I got what I wanted on the sheet, but when I do a view
I can see that the worksheet contain gridlines. This is where I have trouble
- I unchecked Gridlines in the Page Set Up, and did a practice print, but the
gridlines are printing on the entire worksheet. I don't want that. I'm
still playing with it, and thanks for your help.

"Dave Peterson" wrote:

I've found that the best way to make these kinds of tables is to use two
different worksheets. It really makes life much easier.

If there's a reason that you have to print on a single sheet, then you could do
this--after you put the tables on separate sheets.

Select the table on Sheet1
edit|Copy
select A1 of Sheet3 (the new sheet)
Shift-edit|Paste picture link

Then off to the table on sheet2
edit|copy
select the cell under the picture of the first table.
shift-edit|Paste picture link

By pasting the pictures as links, any updates you make to the table will show up
in the picture.

terri wrote:

In an excel worksheet I have two tables - one on top of the other. Each
table contains different data in the columns, and therefore the columns are
not of equal size all the way down the sheet. I.E.:

Table #1: Part Name Part # Part Description QTY

Table #2: QTY Part# Part Description Ordered By

The tables must be displayed this way when printed (one on top of the
other) but I do not want the QTY column in table 2 to be as wide as the Part
Name column in table 1. Does this make sense?













"Don Guillett" wrote:

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?




--

Dave Peterson


--

Dave Peterson

Oops- that works! Thanks!!

"Dave Peterson" wrote:

Tools|Options|View tab|uncheck gridlines????????

terri wrote:

It looks like it will definetly work, but with some practice. I keep getting
the message that my table (the second one) is too big and will be truncated.
I played with it until I got what I wanted on the sheet, but when I do a view
I can see that the worksheet contain gridlines. This is where I have trouble
- I unchecked Gridlines in the Page Set Up, and did a practice print, but the
gridlines are printing on the entire worksheet. I don't want that. I'm
still playing with it, and thanks for your help.

"Dave Peterson" wrote:

I've found that the best way to make these kinds of tables is to use two
different worksheets. It really makes life much easier.

If there's a reason that you have to print on a single sheet, then you could do
this--after you put the tables on separate sheets.

Select the table on Sheet1
edit|Copy
select A1 of Sheet3 (the new sheet)
Shift-edit|Paste picture link

Then off to the table on sheet2
edit|copy
select the cell under the picture of the first table.
shift-edit|Paste picture link

By pasting the pictures as links, any updates you make to the table will show up
in the picture.

terri wrote:

In an excel worksheet I have two tables - one on top of the other. Each
table contains different data in the columns, and therefore the columns are
not of equal size all the way down the sheet. I.E.:

Table #1: Part Name Part # Part Description QTY

Table #2: QTY Part# Part Description Ordered By

The tables must be displayed this way when printed (one on top of the
other) but I do not want the QTY column in table 2 to be as wide as the Part
Name column in table 1. Does this make sense?













"Don Guillett" wrote:

A bit more specific perhaps?

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I want to resize a range of cells in a column. How is this done?




--

Dave Peterson


--

Dave Peterson