I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?

Hi

It can not be done :-(

Regards,
Per

"gsmjackie" skrev i meddelelsen
...
I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change
the
colum size for the next 20 rows without changing the columns above them.
Then
I want to be able to print the sheet. Any ideas?

That's been my conclusion. thanks.

"gsmjackie" wrote:

I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?

One way to get around this would be to merge the cells from two columns for
the 20 rows you refer to.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gsmjackie" wrote:

That's been my conclusion. thanks.

"gsmjackie" wrote:

I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?

Thanks, I thought of that but I'm still restricted to column width, in this
case twice the original which still won't suit my purpose. I do appreciate
the thought.

"Luke M" wrote:

One way to get around this would be to merge the cells from two columns for
the 20 rows you refer to.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gsmjackie" wrote:

That's been my conclusion. thanks.

"gsmjackie" wrote:

I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?

As an extention to the 2 column merging, how about this:
Set 50 columns to width 5
In rows 1-10 merge columns A - D, merge columns E - H etc.
In rows 11 -20 merge columns B - F, merge columns G - K etc.
In rows 20 - 100 merge colums A & B, merge C & D etc.
In fact any combination that you want!
You can the adjust column widths to suit your requirements.
However, the possible drawback - if you propose using a lot of formulae then
copying, pasteing or dragging becomes a nightmare!


"gsmjackie" wrote:

Thanks, I thought of that but I'm still restricted to column width, in this
case twice the original which still won't suit my purpose. I do appreciate
the thought.

"Luke M" wrote:

One way to get around this would be to merge the cells from two columns for
the 20 rows you refer to.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gsmjackie" wrote:

That's been my conclusion. thanks.

"gsmjackie" wrote:

I want to have a spreadsheet with columns that have different sizes. I want
perhaps 10 columns with one margine/size and I want to be able to change the
colum size for the next 20 rows without changing the columns above them. Then
I want to be able to print the sheet. Any ideas?