Inserting columns with merged cells

[rchatter]

Once I set up a spreadsheet, I center the title (merge cells) across the whole worksheet. Of course, once I add another column I have move the title back.

Though, today I was working on an old spreadsheet and when I insert a column it didn't give me an error message. It inserted the column and automatically adjusted the title. What option in Excel can make this happen.

Thanks

Rita

 

[coyotem78]

Hiya

if you click on a cell just below the title (ie if title at row1 the click on a cell at row2) and then insert another column. It will not work if u try to insert another column at the start.

HTH
coyotem78