#1   Report Post  
Junior Member
 
Posts: 3
Default Different column widths?

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!
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2,480
Default Different column widths?

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 FormatCellsAlignmentMerge 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
FormatCellsAlignmentHorizontalCenter across Selection.
--
Regards
Roger Govier

"NorCalHomeFinance" wrote in
message ...

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!




--
NorCalHomeFinance


  #3   Report Post  
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by Roger Govier[_3_] View Post
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 FormatCellsAlignmentMerge 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
FormatCellsAlignmentHorizontalCenter across Selection.
--
Regards
Roger Govier

"NorCalHomeFinance" wrote in
message ...

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!




--
NorCalHomeFinance

Thank you so much Roger...it worked like a charm! I'm really happy with the way my spreadsheet flyer turned out.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Widths Kooky Excel Discussion (Misc queries) 2 June 3rd 07 11:39 AM
column widths eleeng Excel Discussion (Misc queries) 1 April 2nd 07 08:09 PM
Can I have different column widths below each other Dizzy Des New Users to Excel 3 February 8th 07 01:52 PM
Column widths are the same but look different. Suzan Excel Discussion (Misc queries) 0 December 29th 05 05:29 PM
Column widths jrpOR Excel Worksheet Functions 2 August 6th 05 01:44 AM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"