2
Thanks

A few words of thanks would be greatly appreciated.

Excel - Apply a function to all sheets




Issue


I have an Excel file consisting of hundreds of sheets. I would like to apply a function (count, for example) to all cells in E3, how can this be done quickly?

Solution

  • A simple solution is to select all the sheets.
  • To apply the multiple selection: click on the first tab (sheet) and then go on to the last tab (pressing Shift + Left click).
  • Thus all sheets are selected.
  • You can then type a function for E3 and validate this function, it will be applicable for all the cells in E3 (for all the sheets).
2
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 « Excel - Apply a function to all sheets », 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