Questions regarding formatting Excel spreadsheet

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



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




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