Forum Discussion
blondie1313
Jul 25, 2020Copper Contributor
Subdividing columns in Excel
I am setting up a spreadsheet on which I want to have a set of major columns across the sheet with 2 or 3 sub-columns under each major column. So far, I've been unsuccessful in doing that. AUTO ...
TheAntony
Jul 25, 2020Iron Contributor
blondie1313 , You can either select the cells above the sub-headings and "Merge and Center" the cells like this:
Or, you can select the cells and go to Format cells and choose the "Center Across Selection" option for the Horizontal text alignment like this: