|
Posted to microsoft.public.excel.misc
|
|
|
how do I resize a range of cells in a column in excel?
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
|