![merging cells in excel 2003 merging cells in excel 2003](https://www.techonthenet.com/excel/cells/images/merge_wrap2016_002.png)
Web site are provided "as is" and we do not guarantee that they can be used in all The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. You may not be able to sort this range, nor can you paste another range here that does not have identically merged cells. Keep in mind that there are limitations when using merged cells. I prefer to have the text in A1 appear at the top of the cell, so while you are in the Format Cells dialog, change the Vertical: dropdown to “Top”. This would make your heading in cell A1 line up roughly with cell B3 instead of B1. The Excel default is that all text is aligned with the bottom of the cell. This will ensure that cell A1 is 3 rows high and will correspond to cells B1, B2, and B3. Near the bottom left, check the box for Merge Cells. On the Format Cells tab, go to the Alignment tab.
![merging cells in excel 2003 merging cells in excel 2003](https://i.ytimg.com/vi/1tRkkKsNbig/maxresdefault.jpg)
This effect is achieved by using the merge cells feature to merge cells A1, A2, and A3. How do I have cell A1 correspond with 3 rows in column B?
![merging cells in excel 2003 merging cells in excel 2003](https://www.techonthenet.com/excel/cells/images/merge_cells2007_003.png)
I’ve seen a spreadsheet where for each cell in column A, they managed to have 2 or 3 rows in column B.