Quick Answer: How Do You Select A Large Range Of Cells In Excel Without Scrolling?

How do you quickly select a large range without dragging?

A quick Excel keyboard trick for selecting large rangesSelect A5.Press [F5].Enter C21 in the Reference field, but don’t click OK yet.Press and hold the [Shift] key.While holding down [Shift], click OK.Jun 11, 2012.

How do I select 100 rows in Excel?

You can also do various things like hitting Shift + Space and Ctrl + Shift + Down assuming 100000 is the end and your range is contiguous, Ctrl + A to select the entire used range, etc. I simply use the End key. Start with A1 selected. Hold down Shift , then press End and then → .

What is the fastest way to select data in Excel?

Quick Excel Tip – Quickly Select Cells In A RangeSelect the top-most cell in the desired range.Hold down CTRL (or if using a Mac COMMAND) and SHIFT on the keyboard and then press the down arrow key. This will select all of the cells in the range as long as there are no empty cells in the range.Sep 28, 2011

How do I select only data in a cell in Excel?

To select only the filled cells on a worksheet, you can use the Find dialog box.On the Excel Ribbon’s Home tab, click Find & Select, then click Find (or use the keyboard shortcut — Ctrl+F)Type an asterisk (*) in the “Find what” field.Click the “Find All” button.Press Ctrl+A to select all the ranges in the list.More items…•Mar 1, 2012

How do I select and scroll down?

Now, use the scroll bar to scroll down in the text until you reach the end of the desired selection. Hold down the Shift key and click to select it all.

How do you select cells without dragging?

To select a range of cells without dragging the mouse:Click in the cell which is to be one corner of the range of cells.Move the mouse to the opposite corner of the range of cells.Hold down the Shift key and click.Jul 14, 2018

How do I quickly select thousands of rows in Excel?

Select Multiple Entire Rows of Cells. To select a contiguous set of rows, click the row number of the first row. Continuing to hold down your mouse button, drag your cursor across all the rows you want to select. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select.

How do I select alternate rows in Excel?

How to select every Nth row (alternate rows)Select the first 3rd row in your shading pattern, e.g. “Name C”.Use the keyboard shortcut combination Ctrl + Shift + R.Define the range where you want to repeat the shading pattern, e.g. range A2:K15. … Click OK. … Now you can delete, copy, color, etc.

How do I select without scrolling in Excel?

“Easily select all the way down without the mouse/scrolling” By default you can start this tool with the shortcut Control+Alt+L.

How do you bulk select cells in Excel?

Select one or more cellsClick on a cell to select it. Or use the keyboard to navigate to it and select it.To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. … To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

How do you select a range of data in Excel?

A quick way to select an Excel data rangeClick any cell in the data range. … Press [F5].In the Go To dialog, click the Special button in the bottom-left corner.In the resulting dialog, click the Current Region option.Click OK, and Excel will select the current data range (the current region).May 10, 2012

How do I select multiple rows in Excel?

To select an entire row, you just need to select one cell, then press Shift + Space keys together, then the entire row where the selected cell in is selected. If you want to select multiple rows (contiguous rows), you can select one row first, then press Shift + ↓ or Shift + ↑ to expand the selection.

How do I select 50 random rows in Excel?

To use it, simply type the formula =RAND() into a cell of your choice, and a random number will be placed in that spreadsheet cell by the generator. If you want to use the random number generator in Excel to randomly sample a set of rows, add a column at the end of the spreadsheet.

How do I select the first and last cell in Excel?

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.