Subdividing columns in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1546000%22%20slang%3D%22en-US%22%3ESubdividing%20columns%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546000%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20setting%20up%20a%20spreadsheet%20on%20which%20I%20want%20to%20have%20a%20set%20of%20major%20columns%20across%20the%20sheet%20with%202%20or%203%20sub-columns%20under%20each%20major%20column.%20So%20far%2C%20I've%20been%20unsuccessful%20in%20doing%20that.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAUTO%20INSURANCE%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BAUTO%20REPAIRS%3C%2FP%3E%3CP%3EBalance%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BDeposit%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BBalance%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BDeposit%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20older%20Excel%2C%20it%20was%20so%20easy%20to%20do%20this%2C%20but%20in%20365%2C%20I'm%20baffled.%20I%20could%20do%20this%20in%20Word%2C%20but%20I%20wouldn't%20have%20the%20ability%20to%20calculate%20changes%2C%20so%20that's%20not%20satisfactory.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20step-by-step%20directions%20for%20doing%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1546000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546007%22%20slang%3D%22en-US%22%3ERe%3A%20Subdividing%20columns%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F739971%22%20target%3D%22_blank%22%3E%40blondie1313%3C%2FA%3E%26nbsp%3B%2C%20You%20can%20either%20select%20the%20cells%20above%20the%20sub-headings%20and%20%22Merge%20and%20Center%22%20the%20cells%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_0-1595717808295.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207925iF9E8CB41759C2D55%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_0-1595717808295.png%22%20alt%3D%22TheAntony_0-1595717808295.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%2C%20you%20can%20select%20the%20cells%20and%20go%20to%20Format%20cells%20and%20choose%20the%20%22Center%20Across%20Selection%22%20option%20for%20the%20Horizontal%20text%20alignment%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_1-1595717881308.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207926i820FEF9FF2C6F531%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_1-1595717881308.png%22%20alt%3D%22TheAntony_1-1595717881308.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 INSURANCE                       AUTO REPAIRS

Balance       Deposit                     Balance     Deposit

 

In the older Excel, it was so easy to do this, but in 365, I'm baffled. I could do this in Word, but I wouldn't have the ability to calculate changes, so that's not satisfactory.

 

I would really appreciate step-by-step directions for doing this.

 

Thanks!

1 Reply

@blondie1313 , You can either select the cells above the sub-headings and "Merge and Center" the cells like this:

TheAntony_0-1595717808295.png

 

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:

 

TheAntony_1-1595717881308.png