Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel: what is a link?
I would like to update a range of cells with any number that is input into a
specific cell |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel: what is a link?
Duma,
Select the range of cells, type the formula =$A$1 (but with the cell address of the specific cell) and press Ctrl-Enter. Or, type = and then select the specific cell and press Ctrl-Enter. This is the better way if the cell is on another sheet. HTH, Bernie MS Excel MVP "Duma" wrote in message ... I would like to update a range of cells with any number that is input into a specific cell |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel: what is a link?
Do you mean you want to perform some math operation on all the cells when you
input a number into one specific cell? Assume number is entered in A1. Assume range is B1:B100 In C1 enter =B1*$A$1 which will multiply by the number in A1 Double-click on fill handle of C1 to copy down. Another method is to enter a number in an unused cell. Copy that cell. Select the range to change and Paste SpecialMultiplyOKEsc Change the number and do it again. Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 05:44:00 -0700, Duma wrote: I would like to update a range of cells with any number that is input into a specific cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link a Master Template Excel file to different excel source files | Excel Worksheet Functions | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
How to create a link between(Excel) Gantt chart and Excel source | Setting up and Configuration of Excel |