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
Jean-François Pillou

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

Learn more about the CCM team

Published by . Latest update on by jak58.

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 (https://ccm.net/).

0 Comments