0
A formula cannot change the contents of a different cell to itself.
Here's a method that might fill the bill:
- Paste an object into the spreadsheet. I selected a smiley face from the auto shapes. It can be anything. All it will do is function as a button...heck, there are even buttons that you can paste in.
- Next, right click the object and select assign macro.
- When the macro screen comes up, you select "Record Macro"
- Select the cell that you want to provide data.
- Copy the data
- Paste the data where it is supposed to go.
- Turn off the macro recorder.
The macro will look something like this:
Sub SmileyFace1_Click()
'
' SmileyFace1_Click Macro
'
'
Range("C4").Select
Selection.Copy
Range("E4").Select
ActiveSheet.Paste
End Sub
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoI am not sure why you would do so, but here is an option: =B3&" & "&C3
Add your answer:
Earn +20 pts
What is user generated formula in Excel?
It is a formula that the user creates themselves, instead of using the built-in functions.
When using the Insert Function button or the AutoSum list arrow it is necessary to type the equal sign?
Not in Excel.
When you copy a formula using the copy and paste buttons on the standard toolbar Excel uses what to temporarily store the formula?
The Clipboard.
Formula could be edited in excel using?
You can click on it in the Formula Bar near the top of screen, or you can press the F2 key.
A predefined formula a formula that excel has already built for you. that performs calculations by using specific values in particular order?
It is a function
Where can I find the option for using a data pivot table in Excel?
In versions up to Excel 2003, it is on the Data menu. From version 2007 onwards, you can find it on the Insert tab on the ribbon.
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called?
what-if analysis or sensitivity analysis Its What-if Analysis
In Microsoft Excel functions can be entered using what?
You can enter them by just typing them in with the keyboard. You can also use the Insert Function facility.
What best describes the result of using the fill handle on a cell containing a formula in Excel?
It is used to copy the formula down or across.
Can you create formulas in Excel using the mouse?
Not entirely, but you can use a mouse to select ranges you include in a formula.
How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?
You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.
Does the sizing handle allow you to copy a formula from 1 cell to another cell?
If the formula is something like AVERAGE, SUM, etc., then it will copy it to another cell. However, when using the sizing handle after just entering the formula alone, Excel will automatically fill in the answer. The formula is copied along with it, though. However, if the formula is in reference to the content of another cell, this will not happen. The formula changes if the formula uses the content of another cell. To keep it exactly the same to copy it down, you have to make the cell number in the formula an absolute value so it will not change.
