In your spreadsheets, it's nice to sometimes have a heading situated above multiple columns. It makes things easier to read, and makes your spreadsheets look more professional. Here's how to do it.
Highlight the cells you want the heading to span. In this example it is B12..C12. On Home tab, Format, get dropdown to Format Cells and the box shown will appear. On Alignment tab, Text alignment, Horizontal, click on Center Across Selection. Excel will create one cell and center the text in that cell. If column widths are later adjusted, the text will still be centered over the desired columns.
Easy peasy. How will you use this in your spreadsheets?
Mary Kircher Roddy is a genealogist, writer and lecturer, always looking for the story. Her blog is a combination of the stories she has found and the tools she used to find them.