I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.

Thanks!

Glenn

You can't do that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Glenn Chung" wrote in
message
...
I have tried inserting a break and split, didn't work. I just
want to
separate the top half of a page with the bottom half so I can
apply different
cell width on the same column. Or how would I be able to do
this? Same
column but different cell width.

Thanks!

Glenn

You could get kind of close by merging cells.

But it causes more trouble with other stuff (sorting/copy|pasting).

I wouldn't use it.

Select your cells that should be merged, then format|cells|Alignment tab
check the Merge Cells box.

It's nice for viewing, but it's a pain with other stuff.

Glenn Chung wrote:

I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.

Thanks!

Glenn

--

Dave Peterson

Glenn, if you simply highlight the rows on the rioght of the spreadsheet that
you want to make bigger (left mouse and drag), then go to format / rows,
change height of rows and you'll have cells the same column width but bigger
height.

Chris Jones

"Glenn Chung" wrote:

I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.

Thanks!

Glenn