Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.