A quick Excel keyboard trick for selecting large ranges
- Select 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.
Cause: The Copy area and the Paste area are not the same size and shape. Solution: Select the upper-left cell instead of the whole range before you paste. Click the cell where you want the upper-left cell of the copied data to appear. On the Home tab, click Paste.
Do one of the following:
- To move rows or columns, on the Home tab, in the Clipboard group, click Cut . Keyboard shortcut: Press CTRL+X.
- To copy rows or columns, on the Home tab, in the Clipboard group, click Copy . Keyboard shortcut: Press CTRL+C.
Sometimes, add-ins can be a problem in freezing Excel when copying pasting. To check whether the problems in add-ins, restart your application into safe mode and see if the issue is solved or not. Hold the CTRL key and then click on the application until ask for safe mode confirmation and then release the CTRL-key.
Excel Ninja10,000 is just filtering drop-down list limit and not filtering limit. You can use "Number Filters" or "Text Filters" to use logic to filter those columns with more than 10,000 unique values.
Click the Select All button. Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Use AutoSum to sum numbers
- To sum a column of numbers, select the cell immediately below the last number in the column.
- AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum.
- Once you create a formula, you can copy it to other cells instead of typing it over and over.
Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C. Click the first cell in the new worksheet, then press CTRL+V to paste the data into that worksheet.
Just follow these steps.
- Select the cells or ranges you wish to copy.
- Select the “Home†tab.
- Select “Copy†in the “Clipboard section.
- Select the cell you wish to paste your values to.
- Select the lower half of the large “Paste†button. From the extended menu that appears, select “Values“.
- Select “OK“.
Insert or delete a row
- Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
- Alternatively, right-click the row number, and then select Insert or Delete.
On the Home tab, in the Clipboard group, do one of the following:
- To move cells, click Cut . Keyboard shortcut You can also press Ctrl+X.
- To copy cells, click Copy . Keyboard shortcut You can also press Ctrl+C.
To include multiple cells, click on one, and without releasing the click, drag your mouse around adjacent cells to highlight them before copying. To paste to a cell, single-click on the cell where you'd like to paste in the information and press Ctrl + V (or right-click on the destination cell and select Paste).
Sync data from one spreadsheet to another
- To start, open up the spreadsheet or tab you want to copy to the new Sheet > copy the sheet's URL.
- Make a note of the cells you want to import.
- Open the new sheet where you want the data to appear.
- In the cell begin to type > =IMPORTRANGE (you'll see the code as you begin to type)
Excel shortcuts
| Shortcut key | Action | version |
|---|
| Ctrl + A | Select All | All |
| Ctrl + B | Bold | All |
| Ctrl + C | Copy | All |
| Ctrl + D | Fill Down | All |
Copying to Very Large Ranges
- Select cell A3.
- Press Ctrl+C to copy its contents to the Clipboard.
- Click once in the Name box, above column A. (Before you click, the Name box contains "A3," which is the cell you just copied.)
- Type C3:C55000 and press Enter. The range is selected.
- Press Ctrl+V.
Here the steps to select multiple contiguous rows using the SHIFT key:
- Select the row header of the first row in your selected range.
- Press down the SHIFT key on your keyboard (if you're on a Mac, then press down on the CMD key).
- While the SHIFT key is pressed, select the last row of the range that you want to select.
"Easily select all the way down without the mouse/scrolling"By default you can start this tool with the shortcut Control+Alt+L.
Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK. For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of cells.
- Press and hold the Shift key on the keyboard.
- Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row.
- Release the Shift key when you've selected all the rows.
Hit ctrl + shift + down arrow to highlight all of the rows below. Right click the row labels (where each row's number is shown) on the left side and select "delete" in order to delete all of these rows.
Select the cells, rows, or columns that you want to clear. Tip: To cancel a selection of cells, click any cell on the worksheet. , and then do one of the following: To clear all contents, formats, and comments that are contained in the selected cells, click Clear All.
To go to the first cell in a row just press Ctrl+G and A(row number here) so for the 5th row Ctrl+g A5 in the reference and ok. On a further note, the reference will bring you to a specific cell.
3 ways to rename a worksheet
- Double-click the sheet tab, and type the new name.
- Right-click the sheet tab, click Rename, and type the new name.
- Use the keyboard shortcut Alt+H > O > R, and type the new name.
