answersLogoWhite

0


Best Answer

By Copy and Paste

If you highlight the cells which need the same value, copy from Cell (A1) and then highlight all the cells which need the same value and Click paste

Voila!

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you copy a cell to a range of cells. For example copy a value in A1 from A2 - A2000?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the definition max in Microsoft Excel?

MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)MAX gives the highest value from a range of cells or values. So if you have a range of cells with different values and you want to know what is the highest value, then you can use the MAX function. In the following example it will find the highest value in the cells from B3 to B20:=MAX(B3:B20)


You can identify the smallest value in a range of cells using the?

Min();


What is the value of a Browning A2000 12 gauge shotgun?

Between 300-425 dollars depending on condition.


How can you get the range?

You can get the range of a mathematical sequence by subtracting the lowest value from the highest value. Example: 1,3,5,7,9,11,23. Highest Value - 23 Lowest Value - 1 Range=23-1 Range=22 You can get the range of a function by finding all the y-axis values.


How to find the range in a set of data?

Subtract the largest value and the smallest value. (example: 12, 23, 49, 62) 62-12 range:50


What is the Normal value sputum squamous epithelial cells?

According to my doctor. 0 to 2 is a normal range.


What allows you to create rules that change the formatting of a cell or range of cells based on the value of a cell?

conditional


What does INDEX mean in Excel?

INDEX is one of Excel's functions. It returns a reference to a cell that lies in a specified row and column of a range of cells. There are two formats of the function, which are the Array Format and the Range Format of the function. You can use it to find a value from a list. Here is a very simple example, where the function takes the value in the third cell in the range A5 to A15, which is a single column. The value that is in cell A7 would be returned in this case. =INDEX(A5:A15,3) A more complex version can get a value from a table. The following example will take the value from the cell in the range B8 to F30 that is at the 4th row and 2nd column. =INDEX(B8:F30,4,2) It can also be used to get values when more than one range is specified. This is the Array format of the function. The ranges are listed inside brackets. Here it gets the value in the 3rd row and 5th column from the 2nd range that is specified. =INDEX((A7:F15, K11:M20),3,5,2) It is a complicated but very powerful function, so it is worth trying to get used to using it.


What the range in maths for kids?

In a function, the "range" is the set of all possible values of a function for the values of the variable, or the values that result when a function takes in the domain.For example, the function y=2X+3, the range is all real numbers.In statistical data, the range is the difference between the smallest value and the largest value in the set. To find range, you subtract the smallest value in the data set from the largest value.For example, this data set:73, 77, 84, 87, 89, 91, 94The range is the difference of the smallest value and the largest value, so 94-73=21. The range is 21


What is the value of a Browning A2000 12 gauge still new in the box?

If you mean a Browning B-2000 12 gauge shotgun then the value would be 495 dollars for a shotgun in the condition you describe.


What does MIND3D12 mean?

Presuming that is:=MIN(D3:D12)That will give you the lowest value in the range of cells from D3 to D12.


What allows you to create rules that change the formatting of a cell or a range of cells based on the value of cell?

conditional formatting