| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying formulas for all sheets selected
i am working on a spreadsheet with over 60 sheets. i am trying to apply one
formula to all the sheets but it won't. this is the formula =SUM(K24:K28,K32:K34,K36,K38:K39,K42:K43,K55:K56,K 59:K62,K68:K69,K97:K105,K116,K133,K137:K138,K148:K 149,K159,K157,K161:K164,K181:K182) does anyone know why this wouldn't apply to all of them. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying formulas to filtered data | Excel Discussion (Misc queries) | |||
| Applying J-Walk's SheetOffset() to SUM across sheets - possible? | Excel Worksheet Functions | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| Applying Formulas to Visible Cells Only | Excel Discussion (Misc queries) | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Threaded Mode
