Editing multiple worksheets at once?

[vfr700f2]

Hi y'all!

I have a workbook with about 60 worksheets. They all have the same column headings. I wrote formulas in 3 columns on sheet 1, copied them down the rows, then started copying and pasting them into the corresponding columns in the other sheets. At the time, I didn't know there was a better way to do it. But here's the mystifying part: after I repeated this five times, each time I went to another worksheet, the formulas were already there! And they extended down the rows until the last entry, which was a different number of rows in each sheet. THAT'S AWESOME!! But I can't find an explanation of how that works. I found instructions to ctrl-click on each tab, or to click the first tab and shft-click the last tab, but I hadn't done either of those things. What is this amazing magic called??

Thanks!
kevin

[zico8]

Have you got TABLE created in your sheet? ,Check this by select cell with your data (can be cell with formula that has been extended) then go to INSERT menu. Is TABLE enable?

If no, read sth about tables. One of these properities are extending formulas or values trough whole column.

I agree with you that is awesome. Now each data i create for any calculating or comparing I create in TEBLEs.

Thats rrally cool