copying linked formulas in Excel

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
December 9, 2001 at 5:15 am #2130740

copying linked formulas in Excel

Locked

by mbennett · about 20 years, 5 months ago

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.
Creator

Topic

All Comments

Author

Replies
- December 9, 2001 at 6:16 am #3548627
  
  copying linked formulas in Excel
  
  by dklippert · about 20 years, 5 months ago
  
  In reply to copying linked formulas in Excel
  
  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.
Author

Replies

Viewing 0 reply threads

Start or Search

Start New Discussion

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

Software

General discussion