How to apply a function to multiple sheets on Excel

Anyone who uses Excel will know that shortcuts and functions to make repetitive actions easier are very much welcomed. Therefore, in this article we will show you how to apply a formula to multiple sheets in Excel.

To apply a function to all or multiple sheets:

  • Firstly you need to select all sheets. To do this, click on the first tab (sheet) and then go on to the last tab while pressing Shift + Left click.

  • All sheets should then be selected.
  • You can then type a function for a specific column, for example E3 and validate this function. It will then be applied to all cells in E3 on all sheets.

Need more help with Excel? Check out our forum!

Excel