I have a recurring formula down an entire column but every time I add a row the formula isn't applied to those new cells in that column. How can I make the formula permanent so it is consistently applied to all cells in that column?
Thank you!
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI have a recurring formula down an entire column but every time I add a row the formula isn't applied to those new cells in that column. How can I make the formula permanent so it is consistently applied to all cells in that column?
Thank you!
In Excel: Convert your data to a table:
Insert tab - Table
This way the formulas will be automatically inserted in new rows (you may need to edit formula entered before conversion to table, to let Excel know that it's the formula to be used in the column (just press F2 then ENTER))
Rather than selecting a row and choosing to Insert rows Select the row. COPY ... then Insert copied cells