Ask a question »

Excel - Apply a function to all sheets

April 2015


[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).
For unlimited offline reading, you can download this article for free in PDF format:
Excel-apply-a-function-to-all-sheets.pdf

See also

In the same category

Published by jak58.
This document entitled « Excel - Apply a function to all sheets » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.