Questions regarding formatting Excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1801236%22%20slang%3D%22en-US%22%3EQuestions%20regarding%20formatting%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801236%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%205th%20row%20I%20need%20to%20eliminate%20the%20column%20lines%20and%20insert%20a%20title.%20How%20do%20I%20do%20it%3F%20Thank%20you.%20Gary%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1801236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801415%22%20slang%3D%22en-US%22%3ERe%3A%20Questions%20regarding%20formatting%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839742%22%20target%3D%22_blank%22%3E%40gdisantorose%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EManually%2C%20you%20can%20accomplish%20that%20by%20first%20selecting%20the%20cells%20you%20want%20to%20use%20for%20your%20title.%20Then%2C%20using%20the%20Format%20menu%2C%20select%20Cell%20as%20the%20secondary%20menu.%20Then%20look%20for%20the%20%22Merge%20Cells%20box%20down%20there%20at%20the%20bottom%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%22mathetes_0-1603228028720.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228147i4BF4E9576499881E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1603228028720.png%22%20alt%3D%22mathetes_0-1603228028720.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20other%20ways%20to%20do%20it%2C%20but%20that's%20the%20most%20basic.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Every 5th row I need to eliminate the column lines and insert a title. How do I do it? Thank you. Gary

1 Reply
Highlighted

@gdisantorose 

 

Manually, you can accomplish that by first selecting the cells you want to use for your title. Then, using the Format menu, select Cell as the secondary menu. Then look for the "Merge Cells box down there at the bottom

 

mathetes_0-1603228028720.png

 

There are other ways to do it, but that's the most basic.