Share via

Using two different formats on same worksheet__

Anonymous
2011-01-01T21:24:24+00:00

Can I have two different column widths on two sections of the same sheet of a worksheet?  If so, how?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2011-01-01T21:45:49+00:00

You can merge cells, and also center text across several cells. This is often used to create titles or headings at the top of a worksheet.

See for example http://thenewpaperclip.com/2008/04/14/merge-and-center-in-excel-2007/ andhttp://thenewpaperclip.com/2008/04/15/center-across-selection-the-merge-and-center-alternative-in-excel-2007/.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-01-01T21:39:03+00:00

    I have seen a worksheet that has one format at the top for several lines and then a totally different one at the bottom.  No way to do this?

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2011-01-01T21:33:21+00:00

    In the same column? No, that is not possible, but you can merge cells in two (or more columns), using the Merge and Center button in the Alignment group of the Home tab of the ribbon.

    Was this answer helpful?

    0 comments