CAN YOU HAVE THE TOP OF AN EXCEL SHEET HAVE DIFFERENT COLUMN WIDT.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to have one excel sheet with different colum widths. i guess
like having two excel sheets on one page?
 
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 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.
 

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

Similar Threads

using the =page! feature to transpose a row to column 0
Cross Referencing two data worksheets and desciphering differences 1
Can columns be hidden accross multiple sheets in an Excel workboo 11
Creating a template that I can reproduce every month by keying ininformation from SAP 8
How do COUNTIF from two different coloumns but not all rows? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2007 Is it possible to vary the column width between rows? 3
Excel Unique last page footer 1

Back
Top