How do you easily copy formulas that are linked in multiple worksheets? I have 5 of my support analysts worksheeets all linked to the summary sheet, but setting up the formulas manually is mind-numbing. Is there an easy way to copy them?
This conversation is currently closed to new comments.
You can select all five worksheets (Use the Ctrl key or Shift select the first and last sheets). Grouped sheets will allow you to enter information on one sheet that will be duplicated in the same position on all selected worksheets.
I might be able to give a better answer if I knew more about the problem. Where are you copying the formulas? To a new book? Are you changing the summary sheet? What kind of formulas?
If you want them copied exactly without relational changes, copy the formula without the = mark past them in and then add the sign back in.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
copying linked formulas in Excel