Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Is it possible to vary the column width between rows?
Excel 2007 Is it possible to vary the column width between rows? Can column
C be made to be 12 characters wide in rows 10-20 and 18 wide in rows 21-25? I am trying to create a form with a block 12 columns wide and 10 rows at the top. Under that are two blocks of information that require widely different column widths, but mus fit in the same 8.5 x 11 sheet size. No calculations are performed in the two bottom blocks of data. They are merely data entry blocks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Is it possible to vary the column width between rows?
No, it can not be done.
You can however merge the cells in row 21-25 with the next column and adjust the width... "Reggie Kemp" wrote: Excel 2007 Is it possible to vary the column width between rows? Can column C be made to be 12 characters wide in rows 10-20 and 18 wide in rows 21-25? I am trying to create a form with a block 12 columns wide and 10 rows at the top. Under that are two blocks of information that require widely different column widths, but mus fit in the same 8.5 x 11 sheet size. No calculations are performed in the two bottom blocks of data. They are merely data entry blocks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Is it possible to vary the column width between rows?
Hi,
can't be done in any version of Excel. Nor can row heights vary along a single row. If you want those kind of features you can work with a Word table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Reggie Kemp" wrote: Excel 2007 Is it possible to vary the column width between rows? Can column C be made to be 12 characters wide in rows 10-20 and 18 wide in rows 21-25? I am trying to create a form with a block 12 columns wide and 10 rows at the top. Under that are two blocks of information that require widely different column widths, but mus fit in the same 8.5 x 11 sheet size. No calculations are performed in the two bottom blocks of data. They are merely data entry blocks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Is it possible to vary the column width between rows?
You can use Merged Cells to achieve a similar effect.
For example. set the column widths to 6 characters, then to get cells 12 characters wide you can merge 2 adjacent cells, and to get cells 18 characters wide you can merge 3 adjacent cells. "Shane Devenshire" wrote in message ... Hi, can't be done in any version of Excel. Nor can row heights vary along a single row. If you want those kind of features you can work with a Word table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Reggie Kemp" wrote: Excel 2007 Is it possible to vary the column width between rows? Can column C be made to be 12 characters wide in rows 10-20 and 18 wide in rows 21-25? I am trying to create a form with a block 12 columns wide and 10 rows at the top. Under that are two blocks of information that require widely different column widths, but mus fit in the same 8.5 x 11 sheet size. No calculations are performed in the two bottom blocks of data. They are merely data entry blocks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 default column width different to 2003 | Setting up and Configuration of Excel | |||
Excel 2007 Standard column width | Excel Discussion (Misc queries) | |||
Vary column width and row height in the same worksheet | Excel Discussion (Misc queries) | |||
How can i vary the width of columns in a histogram? | Excel Worksheet Functions | |||
Vary the column widths for different rows | Excel Discussion (Misc queries) |