Column width and pasting sections in excel? Formatting questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a spreadsheet in which I need to have varied column
widths in different sections, one under another. (they don't need to relate
directly, and no major equations going on)

for example:
xxxxxxxxx|xxxxxxxxxx
xxxxxxxxx|xxxxxxxxxx
xxxxxxxxx|xxxxxxxxxx
xxxxxxx|xxxxx|xxxxxx
xxxxxxx|xxxxx|xxxxxx


How do I go about splitting the sheet or whatever I need to do so I can
manipulate columns differently based on the row I'm in?

Thanks!
Rich
 
Column widths apply to the whole column.

You may be able to use merged cells to give the appearance that you want, but I
try to stay away from merged cells--they cause more trouble than they're
worth--in copy|pasting, sorting, ...

Can't you just leave that column empty for the rows that only have 2 columns of
data.

Or if the data is really qualitatively different, I'd use two worksheets.
 
fractal,

Sound like you're making a form. You can't have different comlumn widths in
the same column. So here's what you can do

Design your form on paper.
Place your fields on the spreadsheet approximately where you want them.
Ignore where cells are for now, and adjust column widths to suit.
Use format cells/borders to outline the places you need.
Use tools/options/uncheck gridlines

Or you could set up a table in Word

Beege
 
Hey thanks for the reply!

I ended up doing it using inserted objects (seperate excel sheets with just
the subset of altered columns) so they're little expandable imbedded
worksheets. It serves the purpose for my needs well enough, but for a
larger strictly business oriented sheet it would be too cumbersome.

At least I learned something new. ;-)
 
Back
Top