Share via

Extending formula in column

Anonymous
2011-01-07T17:45:56+00:00

Is there a way to make it so that all cells in a given column will get the formula other than having to drag the black cross down? I've created a spreadsheet that will be continuously added to by multiple users and am not confident everyone will remember to extend the formula otherwise. Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-01-07T17:57:58+00:00

Hi,

  1. CTRL+Shift+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.
  2. Select the appropriate cells, enter the formula in the active cell and press Ctrl+Enter.
  3. Format your data range as a table. Formulas will be automatically expand if you enter new rows.

Regards,

Frank

If this post answers your question, please mark it for all readers as the Answer or vote if the reply has been helpful.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest