How To Select All Cells Below In Excel
Bottom Line: Salvage time past learning 7 means to select cells and ranges using keyboard shortcuts.
Skill Level: Beginner
Download the Excel File
If you'd like to follow forth with the video using the same worksheet I'thousand using, you lot can download it here:
Navigating Cells And Ranges.xlsx (24.5 KB)
Keyboard Shortcuts to Select Cells
Who doesn't love a keyboard shortcut to help brand things faster and easier? In this post I'd similar to share vii keyboard shortcuts that will help make navigating your worksheet a better experience. If yous ever discover yourself scrolling downward thousands of rows with the mouse, and so these shortcuts volition relieve you time.
1. Select the Last Used Cell
The keyboard shortcut to select the last used cell on a canvas is: Ctrl+End
No matter where you first from in your worksheet, Ctrl+End will accept you to the intersection of the last used column and last used row.
Sometimes, when yous use this shortcut, Excel volition move your option so that is farther to the right or farther down than the data range you can run across.
This is unremarkably considering there was previously information or formatting in those cells, but it has been deleted. Yous tin clear that by deleting whatever of those previously used rows or columns and then saving your workbook. (Sometimes just hitting Salvage will do the trick, without having to delete whatsoever cells.)
Ctrl+End will select the final used cell on the canvass. However, there could exist shapes (charts, slicers, etc.) on the sheet below or to the right of that jail cell. So make certain your canvas doesn't contain shapes before deleting those rows/columns.
2. Select the Beginning Visible Cell
The keyboard shortcut to select the first visible cell on a sheet is: Ctrl+Home
Using Ctrl+Home volition always have you to the outset visible jail cell (excluding hidden rows/columns) on the canvas, unless your sheet has Freeze Panes.
Freeze Panes lock rows and columns in place so that they are always visible, no thing where you coil to in the worksheet. Freeze panes are specially helpful when you want to see titles, headers, or production names that help to place your data.
If you are using Freeze Panes, the Ctrl+Dwelling house shortcut will accept y'all to the offset cell in your sheet that is beyond the Freeze Panes. In this example, Row one and Column A are frozen, so the Ctrl+Domicile shortcut takes us to Prison cell B2.
iii. Select Last Cell in Face-to-face Range
The keyboard shortcut to select the terminal prison cell in a contiguous range is:
Ctrl+Pointer Key
Using Ctrl along with your arrow keys allows you to move to the start or end of face-to-face information in a row or column. For instance, if y'all start at the peak of a cavalcade and then press Ctrl+? you will spring to the terminal cell in that cavalcade before an empty cell. Repeating this process volition move you further downwards the column to simply before the next blank prison cell.
Ctrl+? will reverse that process in the upward direction. And of course, holding Ctrl while using the left or right arrow fundamental accomplishes the same action horizontally instead of vertically.
An Alternative Using the Mouse
You can attain this same action using your mouse instead of the keyboard, if yous like. But hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). Then double-click. That will spring you down to the last cell in the contiguous gear up of data for that column.
4. Add Cells to the Selected Range
The keyboard shortcut to add cells to the selected range is: Shift+Pointer Key
If you utilize Shift along with your pointer keys, you lot can select multiple cells, 1 at a fourth dimension. For example, if yous start in whatever cell and press Shift+?, it highlights the original cell and the jail cell merely beneath information technology.
The same idea applies to the left, right, or up arrows. And if y'all go along the Shift key held down, you can go along to move over multiple cells in multiple directions to select an unabridged range of data.
five. Select Multiple Cells in Contiguous Range
The keyboard shortcut to select multiple cells in a contiguous range is:
Ctrl+Shift+Pointer Key
Using the same process as in Shortcut 3, but calculation the Shift key, allows yous to select multiple cells simultaneously. It will highlight everything from the prison cell yous started in to the cell that you leap to.
Equally before, the same concept applies using arrows that go in other directions.
This process only selects cells that come before a blank jail cell. However, sometimes a column can have many blank cells. If then, this method may not exist your best option. To select large amounts of information containing many blanks, I recommend checking out this mail service for some alternatives:
2 Keyboard Shortcuts to Select a Column with Blank Cells
vi. Select All Cells to First or Last Prison cell
Shortcuts ane and two taught u.s. how to jump from whatsoever jail cell we are in to the beginning corner (Home) or catastrophe corner (Finish) of our data range. Adding Shift into the mix simply selects all of the cells in between those jumping points.
So if, for example, we starting time in Prison cell C5 and Press Ctrl+Shift+Abode, the following range will exist selected.
The keyboard shortcut to all cells to from the agile cell to the beginning visible jail cell is:
Ctrl+Shift+Dwelling
If instead nosotros were to begin at C5 and press Ctrl+Shift+Terminate, this range of data will be selected:
The keyboard shortcut to all cells to from the active cell to the last used cell is:
Ctrl+Shift+Stop
vii. Select All Cells
The keyboard shortcut to all cells in the current used range is:Ctrl+A
Press Ctrl+A a 2nd time to select all cells on the sheet.
If your spreadsheet has multiple blocks of data, Excel does a pretty expert job of selecting the block of data that is surrounding your cell when you press Ctrl+A. You'll detect in the example below that the Shipper Proper noun data is not selected. This is because in that location are bare columns between it and the block of data that surrounds our original jail cell, B3.
If your intention is to select all of the cells on the sheet, you just press Ctrl+A a second time and your unabridged worksheet volition be highlighted.
The keyboard shortcut to all cells on the sail is:Ctrl+A,A
Better, Faster, Smarter
I promise you are able to commit some of these shortcuts to memory. As y'all put them into practise you'll exist able to navigate and maintain your worksheets more than efficiently and quickly.
Have a keyboard shortcut that y'all want to share? Leave a comment beneath. I will do my best to include information technology in a follow-upward video so that everyone can benefit.
Source: https://www.excelcampus.com/keyboard-shortcuts/select-cells-ranges/
Posted by: shawsmandertne.blogspot.com
0 Response to "How To Select All Cells Below In Excel"
Post a Comment