G Guest Dec 20, 2004 #1 is it possible to have one excel sheet with different colum widths. i guess like having two excel sheets on one page?
is it possible to have one excel sheet with different colum widths. i guess like having two excel sheets on one page?
G Gord Dibben Dec 20, 2004 #2 cneal Width is a column property and is the same top to bottom. Depending upon why you need the differing widths........ You can enter text in say A1 then choose A1:F1 and Format>Cells>Alignment>Horizintal>Center across selection. OR(and I hate to mention this) merge A1:F1 into one cell. Format>Cells>Alignment>Merge Cells or from Formatting Toolbar click the "merge and center" button. Note: only the contents of the left-most cell will be retained. Merged cells cause many problems when it comes to copying, pasting, sorting and other stuff. Gord Dibben Excel MVP
cneal Width is a column property and is the same top to bottom. Depending upon why you need the differing widths........ You can enter text in say A1 then choose A1:F1 and Format>Cells>Alignment>Horizintal>Center across selection. OR(and I hate to mention this) merge A1:F1 into one cell. Format>Cells>Alignment>Merge Cells or from Formatting Toolbar click the "merge and center" button. Note: only the contents of the left-most cell will be retained. Merged cells cause many problems when it comes to copying, pasting, sorting and other stuff. Gord Dibben Excel MVP
H hrlngrv Dec 20, 2004 #3 cneal said: is it possible to have one excel sheet with different colum widths. i guess like having two excel sheets on one page? Click to expand... No. The closest you could get would involve using merged cells, but they introduce a lot of problems in calculations and operations like sorting.
cneal said: is it possible to have one excel sheet with different colum widths. i guess like having two excel sheets on one page? Click to expand... No. The closest you could get would involve using merged cells, but they introduce a lot of problems in calculations and operations like sorting.
