Different column widths?

  • Thread starter NorCalHomeFinance
  • Start date

N

NorCalHomeFinance

Hello,

I am trying to set up an open house flier spreadsheet that will compute
monthly payments as I change the interest rate, term, purchase price,
etc. The problem that I'm having is I need to change column widths
further down the page to make my tables with the data format nicely for
the printing. Obviously, if I change one column, it changes all the
columns and messes up my previous formatting.

There has got to be a simple solution to this but I don't believe I can
have different column widths on the same page. What is the answer here?

Thanks so much!
 
Ad

Advertisements

R

Roger Govier

Hi

Every column can have its width set independently.
However, it has to be the same width down through all 65536 rows(XL2003 and
earlier) or for the 1 million+ rows of XL2007.
You cannot have cell widths within the same column different to any other
cell in the column.

This can be overcome using Format>Cells>Alignment>Merge where you can for
any row, cause the cell to "appear" wider by taking up two or more column
widths.
Merged cells can give all sorts of problems in other areas, so it is
preferable to use the option
Format>Cells>Alignment>Horizontal>Center across Selection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top