Forum Discussion
uyanga
Jan 06, 2023Copper Contributor
Unable to insert a column without losing data
Hi all, I'm humbly asking you to help me with this issue. What do I need to do to insert a column without deleting any data, rows and columns when it says "MS Excel can't insert new cells because i...
NikolinoDE
Jan 06, 2023Gold Contributor
Insert or delete rows and columns
Formatting options
When you select a row or column that has formatting applied, that formatting will be transferred to a new row or column that you insert. If you don't want the formatting to be applied, you can select the Insert Options button after you insert, and choose from one of the options as follows:
If the Insert Options button isn't visible, then go to File > Options > Advanced > in the Cut, copy and paste group, check the Show Insert Options buttons option.