How to keep headers in excel 2016 when scrolling

Excel closes the dialog box and selects the cells.

To select a single range, type the range you want to select, for example, type 'C5:F9' to select all the cells between C5 and F9 and press ENTER.

The 'Go To' dialog box opens with the cursor in the 'Reference' box. To select cells using the 'Go To' command: Tip: Excel indicates it is ready to add further cells to the selection by showing the word 'ADD' on the Excel Status bar.

Repeat the previous step until you have selected all the required cells in the worksheet.

If you wish to select more cells, press SHIFT + F8 and select the next range of cells.

Hold down SHIFT and press DOWN ARROW and RIGHT ARROW to select the cells in the second range.

Go to the top left cell in the second range.

Hold down SHIFT and press DOWN ARROW and RIGHT ARROW to select the cells in the first range.

To select nonadjacent cells using the keyboard: You can select nonadjacent cells in a worksheet. Select nonadjacent ranges using the keyboard

To select all used cells in the worksheet, press CONTROL + HOME to go to the first cell in the worksheet and then press CONTROL + SHIFT + END.

To select an entire row, press SHIFT + SPACEBAR.

To select an entire column, press CONTROL + SPACEBAR.

If you press CONTROL + SHIFT + RIGHT ARROW again, you will select the entire row. This will select cells to the last used cell in the row.

To select a row, move to the first cell in the row and press CONTROL + SHIFT + RIGHT ARROW.

If you press CONTROL + SHIFT + DOWN ARROW again, you will select the entire column. This will select cells to the last used cell in the column.

To select a column, move to the first cell in the column and press CONTROL + SHIFT + DOWN ARROW.

To select the entire worksheet, press CONTROL + A twice.

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. Welcome to the Microsoft Office ExcelВ tutorial.

How to keep headers in excel 2016 when scrolling