200+ Keyboard Shortcuts for Excel 2010

200+ Keyboard Shortcuts for Excel 2010

https://w ww.shortcutwor ld.com/en/win/Excel_2010.html

Delhi tto to Koll kaat a Flliig ht s

R Rss 2,, 4442

A wiki-style reference database for keyboard shortcuts

2003

2007

Excel 2010

Comments (172)

E dit

2011 Add

2013 FAQ 

2016

win login/ register ���

Main Menu Home

Excel 2010 Shortcuts

Login/ Register

Uploaded by bernd, updated on 12/26/2015 12/26/2015 by bernd Platform: Windows/ English

Platforms:

Table of Contents:

My Shortcuts

Linux Shortcuts

1. Navigate Inside Worksheets

Mac OS Shortcuts

2. Work with Data Selections 3. Insert and Edit Data

Windows Shortcuts Web Applications

4. Format Data 5. Formulas and Names

New Windows Shortcuts:

6. Manage Multipe Worksheets

FreeMeta Sway 2016

7. Manage Multiple Workbooks 8. Various Excel Features

Outlook 2016

9. Work with the Excel Ribbon

GTDNext.com

10. Data Forms 11. Pivot Tables

Site:

12. The Rest

PDF Print Hide all Show all

About Discuss Add Page Give Feedback 

1. Navigate Inside Work sheets sheets

1 f 10

Arrow Keys

Move one cell up, down, left, or right in a worksheet.

Page Page Down Down / Page Page Up

Move one screen down / one screen up in a worksheet.

30 07 2016 12 52

200+ Keyboard Shortcuts for Excel 2010

https://www.shortcutworld.com/en/win/Excel_2010.html Alt + Shift + Arrow Left

Ungroup selected PivotTable items. ▲  up

12. The Rest

Dialog Boxes

Arrow Keys

Move between options in the active drop-down list box or between some options in a group of options.

Ctrl + Ta b / Ctrl + Shift + Tab

Switch to the next/ previous tab in dialog box.

Space

In a dialog box: perform the action for the selected button, or select/clear a check box.

Tab / Shift + Tab

Move to the next / previous option.

a ... z

Move to an option in a drop-down list box starting with the letter

Alt + a . .. a lt + Z

Select an option, or select or clear a check box.

Alt + Arrow Down

Open the selected drop-down list box.

Enter

Perform the action assigned to the default command button in the dialog box.

Esc

Cancel the command and close the dialog box.

Auto Filter

Alt + Arrow Down

On the field with column head, display the AutoFilter list for the current column .

Arrow Down / Arrow Up

Select the next item / previous item in the AutoFilter list.

Alt + Arrow Up

Close the AutoFilter list for the current column.

Home / End

Select the first item / last item in the AutoFilter list.

Enter

Filter the list by using the selected i tem in the AutoFilter list.

Ctrl + Shift + L

Apply filter on selected column headings.

Work with Smart Art Graphics

Arrow Keys

Select elements.

Esc

Remove Focus from Selection.

F2

Edit Selection Text in if possible (in formula bar).

▲  up

Shortcuts published under Creative Common License where possible. Website: Copyright 2006-2016. Terms of Use

10 f 10

30 07 2016 12 52