0
What do you do if you want to select cell A1 and cell B4 in Excel?
Wiki User
∙ 11y ago
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
To select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoTo select just the two cells, click on one of them, then press and hold the Ctrl key and click on the other. Both cells will now be selected. To select them and the cells between them, click on one, then press and hold the Shift key and click on the other. The range from A1 to B4 will now be selected.
Add your answer:
Earn +20 pts
What is the range of cell when you select all cells in Excel?
That depends on the version of Excel. Up to Excel 2003 it would be A1:IV65536. From Excel 2007 onwards it would be A1:XFD1048576.
How do you combine Excel data?
If you want to combine data of multiple cells in a single cell, use '&' funtion. Ex. if you want to add the data of cell A1 and cell A2 in the cell A3, 1- Go to A3 2- Type "=" 3- Select A1 4- Type "&" 5- Select A2 Content of cells A1 and A2 will be combined in the cell A3.
Which short cut key is used to select the top leftmost cell of the Excel sheet?
Ctrl-Home will bring you to cell A1 in a worksheet in Excel.
In Excel is cell A1 designated the active cell?
If you select one cell, it will be active. However, if you select multiple cells at once, only one can be the active cell. That is usually the cell you select first.
What is the home cell of Microsoft Excel?
A1
What key combination will move the cell to A1?
Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.
What do you divide by if you want 20 percent in Excel?
To get 20% of anything you divide by 5. In Excel you could do it several ways. If the value you want to divide was in cell A1, then in another cell you could put the following formula: =A1/5 Alternatively you could put the 5 into another cell, like A2, and then refer to it in the formula as follows: =A1/A2
Describe the division function in Excel?
If you want Excel to divide one number by another, use the "/" character. For example, if I want to divide 4 by 2 this is what I would enter in a cell: =4/2 Excel will display the result of the division. In this case, 2. You can also divide using cell references. Lets say cell A1 contains the number 4 and A2 contains the number 2. Enter the following in the cell where you want the result: =A1/A2 Again, Excel will display the result (2) in the cell where you entered the formula.
How would you calculate 10 percent of something in excel?
There are a few ways. Assuming the value you want 10% of is in cell A1, then in another cell you could use any of the following formulas: =A1*10% =A1/10 =A1*0.1 =A1/100*10
How do you write a formula in cell b1 in excel that shows if cell a1 is greater than 4 enter the number 150 or if cell a1 is less than 4 enter 75?
=IF(A1>4,150,75) In this case if A1 is 4, then 75 will show. If you want 150 to show when A1 is 4 then the formula would be: =IF(A1>=4,150,75)
How do you write to the 12th power in excel?
Let's say you want to take the value of what's in cell A1 and take to the 12th power, then you would type =A1^12 in the formula bar for the cell you want this calculated value to be in.
What would the Excel formula be for If the text in Cell A1 matches the Text in Column A on Sheet 2 then place an X in Cell B1 on Sheet 1?
If you want to compare the contents of cell A1 on Sheet1 to A1 on Sheet2 and put an X in cell B1 on Sheet1, then in cell B1 on Sheet1 you would put the following formula: =IF(A1=Sheet2!A1,"X","")
