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. Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list.Welcome to the Microsoft Office Excel tutorial. To open the legacy PivotTable and PivotChart Wizard (which contains other options such as Consolidate), press Alt > D > P (Alt then D then P). Open the PivotTable and PivotChart Wizard Press Alt + Shift + left arrow to ungroup selected pivot table items. Press Alt + Shift + right arrow to group selected pivot table items. Select a cell in a pivot table and press F11 to create a pivot chart on a new sheet based on the current pivot table. Select a cell in a pivot table and press Alt + F1 to create a pivot chart on the current worksheet based on the current pivot table. Select a cell in a pivot table and press Ctrl + A or press Ctrl + Shift + * (asterisk). Select an entire pivot table (not including report filters) Select a cell in a pivot table and press Alt > JT > W > T (this is a sequential shortcut so press Alt then JT then W and then T). Select an entire pivot table (including report filters) Select a cell in the pivot table and press Alt + F5. You can normally select a cell in the data set as long as there are no blank rows or columns and Excel will highlight the entire data set. In 2010, you'll need to press Alt > N > V > T. A dialog box will appear with options to create a pivot table. Select the data set and press Alt > N > V (this is a sequential shortcut so press Alt then N then V). 
Create a pivot table from the selected data The following are 10 useful Excel pivot table shortcuts: 1. Recommended article: 10 More Excel Pivot Table Shortcutsĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data so it's helpful to learn a few shortcuts to work quickly with them. Timesaving Excel Pivot Table Keyboard Shortcutsīy Avantix Learning Team | Updated March 23, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
0 kommentar(er)
