Homework Help Question & Answers

I need helpin figuring out how to use a textbox to change the value of a cell in a different spreadsheet(all in the same...

I need helpin figuring out how to use a textbox to change the value of a cell in a different spreadsheet(all in the same workbook) in excel. example spreadsheet 2 textbox1(value) changes spreadsheet1(cell value). please help.

0 0
Next > < Previous
ReportAnswer #1

In Microsoft Excel we can link a textbox to a specific cell to show the linked cell content in the text box. What's more, if the value of the linked cell is changed, the textbox will update automatically. You can do it with following steps:

Step 1: Click the Text Box button under Insert tab, and insert a textbox in your worksheet.

Sign in s -Excel ?Tell me what you want to do t Equation Ω Symbol 3D Line Column Win/ Slicer TimelinenText Header Map- Box &

Step 2: While text box is selected put your cursor in the formula bar, type in = symbol and then click on the cell you want to link to, and finally press the Enter key. See screenshot:

TextBox 2X fSA$3 words Kutools for Excel is a handy tool You can easily count the number of words in MS word. Unlike Word, Ex

Now the textbox displays the content of linked Cell A3 in the textbox. In addition, when we change the content in linked Cell A3, the content in textbox will update automatically.

Know the answer?
Add Answer of:
I need helpin figuring out how to use a textbox to change the value of a cell in a different spreadsheet(all in the same...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need help figuring this out

    I need help figuring this out. The area of a circle 28 square meters. What is its cicumference? (Use A=nr^2 and C=2nr to figure out the problem)

  • I need help figuring this out please

    I need help figuring this out please! :)Write an equation for this sequence and find the 15th term.Term Number 1 2 3 4Term 0 1 2 3

  • This is a PSYCH Statistical Math Question. I need help figuring this out. I need to...

    This is a PSYCH Statistical Math Question. I need help figuring this out. I need to show work as well so I know how to do it. What is the value of ΣΧ for the scores 1, 5, 2? 0 10 0 8 0 16 O 30 SHOW WORK

  • I need help figuring this out. 2. Find the percent composition of each element in acetamide,...

    I need help figuring this out. 2. Find the percent composition of each element in acetamide, C2H5NO (please use two places past the decimal (ie. 50.00%).

  • I need help figuring out how to get this hope you can help me. ΝΗ

    I need help figuring out how to get this hope you can help me. ΝΗ

  • I am not sure how to go about figuring this out

    I am not sure how to go about figuring this out ... Shuffle the numbered cards of an ordinary deck of cards (aces equal 1). Pick out one card to be the answer card. Then deal off the top four cards to use for an equation. Try to use 2,3,or all 4 cards to form an equation. Example: Answer card is 4. Equation cards are 2, 6, 8, and 10. Possible equations are(10 + 6 - 8)divided by 2 =...

  • Hello, I need help figuring out how to do this problem!? Please show all work as...

    Hello, I need help figuring out how to do this problem!? Please show all work as I want to learn how to get to the answer. Thank you ****For the first answer I get 1.25 and my book says 89th percentile, how do I know 1.25 is 89th percentile ??? Given that a population of scores is normally distributed with determine the following: 10 and ơ 8. a. The percentile rank of a score of 120 b. The percentage of...

  • I need help figuring out what strategy is used to begin a essay

    I need help figuring out what strategy is used to begin a essay. Is it Development by example, process analysis, comparison and contrast, definition, classification or causal analysis?Last June, as I stood behind the bright orange guard door of the machine, listening to the crackling hiss of the automatic welders, I thought about how different my life had been just a few weeks earlier. Then, I was writing an essay about French literature to complete my last exam of the...

  • I just need help figuring out which equations to use for part a and part b...

    I just need help figuring out which equations to use for part a and part b (Fetter, p216, 2 and 4, 10 and 12) A well that is screened in a confined aquifer is to be pumped at a rate of 165,000 ft/day for 30 days. The aquifer transmissivity is 5320 ft/day, and the storativity is 0.0007. (You are encouraged to use spreadsheet for this problem) A. What is the drawdown at distances 50, 150, 250, 500, 1000, 3000, 5000,...

  • I need help figuring out what formula to use for the following question: Using the cash...

    I need help figuring out what formula to use for the following question: Using the cash flows below, what is the NPV of all the cashflows using an interest rate of 10% ? Now: - $120 After 1 year: + $20 After 2 years: + $90 After 3 years: - $10 After 4 years: + $30 After 5 years: + $30 After 6 years: + $30 After 7 years: + $40

Free Homework App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.