Recently I’ve experienced the following:

– When a row is inserted (using keyboard shortcut Alt-I-R), some existing formulas on the sheet would not shift down accordingly, resulting in misaligned formulas. 

– I’m using Office 365, and this has happened across multiple spreadsheets.

Has anyone else also run into this issue?

Edit: might have something to do with frozen panes.

​Recently I’ve experienced the following:- When a row is inserted (using keyboard shortcut Alt-I-R), some existing formulas on the sheet would not shift down accordingly, resulting in misaligned formulas. – I’m using Office 365, and this has happened across multiple spreadsheets. Has anyone else also run into this issue? Edit: might have something to do with frozen panes.  Read More

​