woole we double
( e) To turn on the
clich the cell.
7) To select adacent rows and colomon we pre
key to and select the row
8) The shortent
of 업
redo is
9) The cell contents can also modified by wring.
minimned hy pressing
key
Answers
Answer:
hi!
Explanation:
1. Select the Last Used Cell
The keyboard shortcut to select the last used cell on a sheet is: Ctrl+End
No matter where you start from in your worksheet, Ctrl+End will take you to the intersection of the last used column and last used row.
ctrl+end takes you to the intersection of the outermost colun and row that have been used
Sometimes, when you use this shortcut, Excel will move your selection so that is farther to the right or farther down than the data range you can see.
Ctrl+end you may have do delete previously used rows or columns
This is usually because there was previously data or formatting in those cells, but it has been deleted. You can clear that by deleting any of those previously used rows or columns and then saving your workbook. (Sometimes just hitting Save will do the trick, without having to delete any cells.)
Ctrl+End will select the last used cell on the sheet. However, there could be shapes (charts, slicers, etc.) on the sheet below or to the right of that cell. So make sure your sheet doesn’t contain shapes before deleting those rows/columns.
2. Select the First Visible Cell
The keyboard shortcut to select the first visible cell on a sheet is: Ctrl+Home
Using Ctrl+Home will always take you to the first visible cell (excluding hidden rows/columns) on the sheet, unless your sheet has Freeze Panes.
Ctrl+Home takes you to cell A1
Freeze Panes lock rows and columns in place so that they are always visible, no matter where you scroll to in the worksheet. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data.
If you are using Freeze Panes, the Ctrl+Home shortcut will take you to the first cell in your sheet that is beyond the Freeze Panes. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2.
Crtl+Home using freeze panes
3. Select Last Cell in Contiguous Range
The keyboard shortcut to select the last cell in a contiguous range is:
Ctrl+Arrow Key
Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. For example, if you start at the top of a column and then press Ctrl+? you will jump to the last cell in that column before an empty cell. Repeating this process will move you further down the column to just before the next blank cell.
5-Ctrl+Arrow Keys to Navigate Cells 2
Ctrl+? will reverse that process in the upward direction. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically.
An Alternative Using the Mouse
You can accomplish this same action using your mouse instead of the keyboard, if you like. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). Then double-click. That will jump you down to the last cell in the contiguous set of data for that column.
Mouse shortcut - Cursor change to crosshairs
4. Add Cells to the Selected Range
The keyboard shortcut to add cells to the selected range is: Shift+Arrow Key
If you use Shift along with your arrow keys, you can select multiple cells, one at a time. For example, if you start in any cell and press Shift+?, it highlights the original cell and the cell just below it.
Shift+Arrow key to select multiple cells
The same idea applies to the left, right, or up arrows. And if you keep the Shift key held down, you can continue to move over multiple cells in multiple directions to select an entire range of data.
5. Select Multiple Cells in Contiguous Range
The keyboard shortcut to select multiple cells in a contiguous range is:
Ctrl+Shift+Arrow Key
Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. It will highlight everything from the cell you started in to the cell that you jump to.
Ctrl+Shift+Arrow Keys select an entire range of cells
As before, the same concept applies using arrows that go in other directions.
2 Keyboard Shortcuts to Select Column with Blank Cells 640
2 Keyboard Shortcuts to Select a Column with Blank Cells
6. Select All Cells to First or Last Cell
So if, for example, we start in Cell C5 and Press Ctrl+Shift+Home, the following range will be selected.
The keyboard shortcut to all cells to from the active cell to the first visible cell is:
Ctrl+Shift+Home
Ctrl+Shift+Home
If instead we were to begin at C5 and press Ctrl+Shift+End, this range of data will be selected:
Ctrl+Shift+End
The keyboard shortcut to all cells to from the active cell to the last used cell is:
Ctrl+Shift+End
7. Select All Cells
The keyboard shortcut to all cells in the current used range is: Ctrl+A
Press Ctrl+A a second time to select all cells on the sheet.