Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
|
|||
|
|||
Quote:
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Widths | Excel Discussion (Misc queries) | |||
column widths | Excel Discussion (Misc queries) | |||
Can I have different column widths below each other | New Users to Excel | |||
Column widths are the same but look different. | Excel Discussion (Misc queries) | |||
Column widths | Excel Worksheet Functions |