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 a simple solution to apply a function to all sheets.
How to Apply a Function to All Sheets
Image: © 123RF.com
- Firstly you need to select on 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.