Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a 650 sheet Excel document. I need to do some bulk additions to each of the sheets.

Are there ways to say add a bit of text to a specific row/column pair (A4), bulk search and replace, etc?

share|improve this question
you can select all the sheets and then edit the cell in the active sheet and it will edit it on all sheets. Or are you wanting to do something else? – Raystafarian Mar 27 '12 at 19:31
Yes, this seemed to work. I'm trying to normalize 650 sheets of data in preparation to create CSVs to in turn import into MYSQL. – Keefer Mar 27 '12 at 19:32
up vote 1 down vote accepted

To edit the same cell on several sheets, you can select all applicable sheets and edit the cells on the active sheet, this will, in turn, edit that cell on all selected sheets.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .