Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering same formula in multiple sheets
How do I enter same formula in the same cell on multiple sheets?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering same formula in multiple sheets
ab, group the sheets, click on one sheet and hold the ctrl key down and
click on the other ones, if you want them all select the first one hold down the shift key and click on the last sheet, put in your formulas, don't forget to ungroup the sheets, right click and ungroup. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "ab" wrote in message ... How do I enter same formula in the same cell on multiple sheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data exctraction from multiple sheets | Excel Discussion (Misc queries) | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |