0
Click on the label for the row you want, then hold 'Ctrl' and click on any extra row you want. You can also press the Shift key and the spacebar to select the current row or rows, if cells from more than one row are already selected.
Wiki User
∙ 8y ago
Wiki User
∙ 6y agoThe simplest and most common way is to click on a cell with the mouse, and then while holding the left mouse button, cells can be selected by dragging across the cells. It can also be done by using the keyboard. You can press and hold the Shift key and then use the cursor keys, which are the ones with the arrows, to move the selection and select cells. The F8 key can also be used to turn a selection mode on and off. This is the least common way of selecting cells and one that many people don't know about. It is useful for selecting cells that are not together, especially for people who have difficulty using a mouse.
Wiki User
∙ 9y agoPoint and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Point and click.
Wiki User
∙ 8y agoClick on any cell to select it. You can click in the name box (left side of the formula bar, just above the worksheet) and type in the cell address if you prefer that. You can also select a range reference by entering the first cell, a colon, and the last cell to select a range.
Click and drag to select a range of cells. Click on a cell, then CTRL-click to select several non-contiguous cells. Put cursor on the first cell you want and then press the F8 key and then use the arrow keys to select cells around it, with the first cell being the anchor. Press F8 again to stop.
Wiki User
∙ 14y agoSelecting cells in Excel is the process of highlighting them, usually with a view to doing something with them, like format them or delete their contents or copy something into them. Selecting can be done in several ways, both with the mouse and keyboard. Go to the first cell you want. Then press and hold the left mouse button and start to drag out over the cells you want to select. Alternatively, press and hold one of the shift keys and press the arrow keys in the direction you want to select cells. The F8 key can also be used to select cells, in conjunction with the arrow keys. It can turn selection on or off, having the same effect as holding the shift key. The Page Up, Page Down, Home and End keys can also be used to do selections.
Normally you select cells that are together. Sometimes you will want to select cells that are in separate parts of the spreadsheet, what are known as non-contiguous cells. If you select the first group of cells in the ways already mentioned, when you go to select a separate set, you lose the selection on the first set. To prevent this happening, you press and hold the Ctrl key, when you select the second set or any subsequent sets. It can also be done with the F8 key by turning the selection mode on or off, though it is far easier with the Ctrl key.
Wiki User
∙ 11y agoclicking on them is the usual way. if you want to select several use a click-drag.
Wiki User
∙ 9y agoPoint and click.
Add your answer:
Earn +20 pts
When you select a row and ask Excel to insert a row where is the new row inserted?
It is inserted above it.
How do you select nonadjacent columns or rows in excel?
After selecting the first row or column, press and hold the ctrl key and click on the header of the next row or column you want to select.
When merging and centering in Excel you select the entire row to infinity then click merge and center?
Not sure why you would want to do that, but Excel supports it if that is what you decide to do.
How do you delete rows and columns from am Microsoft Excel table?
many a time you may require to add a row of data or a coloumn of data which you forgot to enter earlier .excel proveides you the facility to insert rows or columns onto the sxisting worksheet very easily .it is that inserting a row of data will shift the rest of the rows down and cause the ladt row of the worksheet ,the rest of the columns shift right ,if there is any data in the last row or column of the worksheet that will be lost .
What button causes Excel to insert dollar symbols in front of the row?
Right click on the cell, select format cells, select currency and $.
What is a small box or bar that is used to select an entire row?
It is often referred to as the row header or row heading or row number.
How do you lock the first row in excel so you always see the label?
Select cell A2. Then, on the menu bar, select Window, Freeze Panes.
How do you select an entire row and column in Excel?
Clicking on the header of the row or column will select it. So for example, to select row 3, click on the 3 at the start of it or to select column R, click on the R at the top of it. Pressing Ctrl and the spacebar will select the current column. Shift and spacebar will select the current row.
Excel rows are inserted the selected row?
You can insert rows above or below the selected row. You select what you would like to do on the insert worksheet rows menu.
Does Microsoft Excel automatically select the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart?
no
How do you Select row 3 and freezer rows 1 and 2 in place in excel?
You can select the entire row by clicking on the row number on the left end of the row. Then you can choose the Freeze Panes option. To freeze the first two rows you don't need to select all of row 3. Put the cursor in cell A3 and then do Freeze Panes and rows 1 and 2 will be frozen.
How do you transpose a row of data to a column in Excel?
Select and copy the row data.Go to the top cell of the column where you would like to copy the data.Click on copy - transpose.Observe the data from the row in the column.Go back and delete the row data.
