CTRL+ALT+V Displays Paste Special dialog box. Available only after cutting or copying an object, text, or cell contents.ĬTRL+L Displays Create Table dialog box. CTRL+SHIFT+U Switches between expanding and collapsing of the formula bar.ĬTRL+K Displays Insert Hyperlink dialog box for new hyperlinks or Edit Hyperlink dialog box for selected existing hyperlinks.ĬTRL+V Inserts contents of the Clipboard at the insertion point and replaces any selection.
CTRL+T Displays Create Table dialog box.ĬTRL+H Displays Find and Replace dialog box, with Replace tab selected.ĬTRL+I Applies or removes italic formatting. CTRL+P Displays Print tab in Microsoft Office Backstage view.ĬTRL+D Uses Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.ĬTRL+SHIFT+P Opens Format Cells dialog box with the Font tab selected.ĬTRL+F Displays Find and Replace dialog box, with the Find tab selected.ĬTRL+R Uses Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.ĬTRL+SHIFT+F Opens Format Cells dialog box with the Font tab selected.ĬTRL+S Saves the active file with its current file name, location, and file format.ĬTRL+G Displays Go To dialog box.
CTRL+A Selects entire worksheet.ĬTRL+` Alternates between displaying cell values and displaying formulas.ĬTRL+SHIFT+A Inserts argument names and parentheses when insertion point is to the right of function names in formulas.ĬTRL+SHIFT+" Copies value from cell above an active cell into the cell or the Formula Bar.ĬTRL+B Applies or removes bold formatting.Įxcel 2010 Keyboard Shortcuts - Ctrl combination shortcut keysĬTRL+C Copies selected cells. In PivotTables, it selects entire PivotTable reports.ĬTRL+SHIFT+: Enters the current time. CTRL+2 Applies or removes bold formatting.ĬTRL+SHIFT+$ Applies Currency format with two decimal places (negative numbers in parentheses).ĬTRL+3 Applies or removes italic formatting.ĬTRL+SHIFT+% Applies Percentage format with no decimal places.ĬTRL+SHIFT+^ Applies Scientific number format with two decimal places.ĬTRL+SHIFT+# Applies Date format with day, month, and year.ĬTRL+6 Alternates between hiding and displaying Applies Time format with the hour and minute, and AM or PM.ĬTRL+8 Displays or hides the outline symbols.ĬTRL+SHIFT+! Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values.ĬTRL+SHIFT+* Selects current region around active cells. “Most useful” is certainly in the eye of the beholder.Excel 2010 Keyboard Shortcuts Ctrl combination shortcut keysĬTRL+PgUp Switches between worksheet tabs, from left-to-right.ĬTRL+SHIFT+Plus (+) Displays Insert dialog box to insert blank cells.ĬTRL+PgDn Switches between worksheet tabs, from right-to-left.ĬTRL+Minus (-) Displays Delete dialog box to delete selected cells.ĬTRL+SHIFT+( Unhides hidden rows within the selection.ĬTRL+SHIFT+& Applies outline border to selected cells.ĬTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.ĬTRL+SHIFT_ Removes outline border from selected cells.ĬTRL+SHIFT+~ Applies General number format.
The shortcuts Actionįill selected cells with an entry you typed in one cellįill data down or to the right through selected cellsĬtrl] and (semicolon) or Ctrl and : (colon)
#EXCEL KEYBOARD SHORTCUTS 2010 PDF#
Note: This article is also available as a PDF download. Here are 10 timesavers that put the short in shortcut. But on a practical level, mastering 10 genuinely useful shortcuts will get you a lot farther than a vague knowledge of 50 shortcuts you seldom use and can’t remember. It’s great to know the resources are out there.
#EXCEL KEYBOARD SHORTCUTS 2010 DOWNLOAD#
You can tap the Help files, hunt the info down via Google, or download a comprehensive list, like this Excel cheat sheet. Why complicate your spreadsheet life with a bunch of tricks you'll never use? These 10 shortcuts will expedite the Excel tasks you perform every day.Īs we’ve observed before, there’s no shortage of information on Microsoft Office keyboard shortcuts. The 10 most useful Excel keyboard shortcuts
0 kommentar(er)
