6
Thanks

A few words of thanks would be greatly appreciated.

Apply a Function to All 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 a simple solution to apply a function to all sheets.


How to Apply a Function to All Sheets

  • 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.



Image: © 123RF.com
6
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « Apply a Function to All Sheets on Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments