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.

Excel shortcut keys 2016