Function inserting

W

wolfmanjack81

..state reports I do each month have to total,average, max.,
min.,approximately 70 columns on 2 worksheets How do I insert function for
entire worksheet at once?? I have been doing each individually
 
J

JulieD

Hi

one approach (although not all at once), is to do the first column and then
drag (use the AutoFill handle at the bottom right of the cell) across the
other columns. You can do the columns on both worksheets if before you do
the first column on the first worksheet you group the sheets (click on the
sheet tab for the first one, hold down control, click on the second sheet
tab) - note, this will only work if the data is in the same columns in both
worksheets.

Hope this helps
Cheers
JulieD
 
Top