Adding rows in multi worksheets

I have an employee listing in alph order that I have copied to different sheets in a workbook. If I insert a row and add text is there a way that it will insert on every sheet and how do I do this?

Originally Posted by Galaxy

I have an employee listing in alph order that I have copied to different sheets in a workbook. If I insert a row and add text is there a way that it will insert on every sheet and how do I do this?

Try selecting all of the worksheets together (by pressing the ctrl key and clicking the worksheet tabs of all the sheets you wish to include)

then insert your column or row and type your text. The column or row that you added and the text you typed will appear on each of your worksheets in the same column/row.

good luck

-Laura