To select a data range, move the focus inside the range and press CONTROL + A.To select cells, go to the top left cell and with SHIFT held down press the DOWN ARROW and RIGHT ARROW to extend the selection down and right.Here are just some of the ways you can select a range of cells using the keyboard: Tip: If you find the Excel Quick Analysis option taking focus away from the worksheet when you begin selecting cells then go to Excel's Options (ALT + F, T) and in the 'General' category deselect the 'Show Quick Analysis options on selection' check box. Some ways only use the keyboard, some only use the mouse and some use a combination of both. To go to a cell using the 'Go To' dialog box, press F5 to open the 'Go To' dialog box, type the cell co-ordinates in the Reference box and press ENTER.Įxcel offers many different ways to select cells.To move to the previous worksheet, press CONTROL + PAGE UP.To move to the next worksheet, press CONTROL + PAGE DOWN.To scroll to the left, press ALT + PAGE UP.To scroll to the right, press ALT + PAGE DOWN.To move to the last cell, press CONTROL + END.To move to the first cell, press CONTROL + HOME.To move to the first cell in the row, press HOME.

To move to the edge of a data region, press CONTROL + Arrow Keys.

To move to the next cell to the left, press SHIFT + TAB.

To move to the next cell to the right, press TAB.

To move to the next cell, press the Arrow Keys.

Here are just some of the more popular key presses available to you: Section 2: Learn the essentials Move around a workbook using the keyboardĮxcel has many different hot keys to help you move around a workbook. As you progress through the chapters you will also discover useful SuperNova and ScreenReader hot keys and some tips and tricks to help you be even more productive. In this tutorial you will learn about the ways you can use the keyboard to accomplish many common tasks in Excel including opening and saving workbooks, formatting text and cells and working with lists and tables. Selecting all the rows in the Excel sheetWelcome to the Microsoft Office Excel tutorial.

Click on the row that you want to select all rows below it. Selecting all Rows Above in the Excel documentģ. Press CTRL + Shift + down key (arrow) on your keyboard. Click on the row that you want to select all rows below it.ģ. Open an existing or new Excel document.Ģ. Selecting Rows Excel Selecting all Rows below in Google Sheetsġ. Press CTRL + Shift + Up key (arrow) on your keyboard. Selecting all Rows Above in Google SheetsĤ. Alternatively, click on the cell next to the A column and row 1. From the Google Apps, click on the Sheets icon.Ĥ. Visit the Google account and log in using your email detail (That is, ). Press CTRL + Shift + down key (arrow) on your keyboard.ġ. Locate the row that you want to select all rows below it.Ĥ. Choose the existing sheet that you’re working on.ģ. From the Google Apps, click on the Sheets iconĢ. If you want to select all the rows below a given row in Google Sheets, you need to follow these steps:ġ. Selecting all Rows below in Google Sheets Let us discuss how one can select Rows in columns. Selecting all the rows in the Excel sheet.Selecting all Rows Above in the Excel document.Selecting all Rows Above in Google Sheets.Selecting all Rows below in Google Sheets.

Excel select all rows below