All Excel Shortcuts Pdf
These are categorized by Excel shortcuts with function keys, Excel shortcuts with Control key and Miscellaneous. All these keys work with Excel 2013, Excel 2010, Excel 2007 and prior versions. Download MS Excel Shortcut PDF File. Dangdut koplo new palapa. Excel shortcuts clearly illustrated. Work faster and more efficiently. Download the shortcuts in PDF to keep for reference.
MS Excel Shortcuts Using shortcuts saves a lot of time and it shows your proficiency in application usage. Here we have listed a complete list of Microsoft Excel keyboard shortcuts and their descriptions.
These are categorized by Excel shortcuts with function keys, Excel shortcuts with Control key and Miscellaneous. All these keys work with Excel 2013, Excel 2010, Excel 2007 and prior versions. Download MS Excel Shortcut PDF File You can also download the complete Excel Shortcut Keys PDF for offline usage. This PDF file contains Excel Shortcuts listed below group by shortcuts keys with Funciton Key, Conrol Key, Shift Key and miscellaneous. Shortcuts with Function Key Function Keys Description F1 Open ' Microsoft Office Excel Help'. F2 Edit an Excel cell.
All Excel Shortcuts Pdf File
F3 Displays the ' Paste Name' dialog box. F4 Repeats the last action. F5 Opens ' Go To' dialog box.
F6 Switches between worksheet and menu / Ribbon. F7 Spelling Check. F8 Switches Extend mode on / off. F9 Calculates all worksheets in all open workbooks.
F10 Highlights shortcut keys of Menu and Ribbon items. F11 Creates chart of selected cells. F12 Opens ' Save As' dialog box. Shortcuts with Control Key Control Keys Description CTRL + 1 Opens ' Format Cells' dialog box. CTRL + 2 Makes selected cell text bold. CTRL + 3 Makes selected cell text italic.
CTRL + 4 Makes selected cell text underline. CTRL + 5 Makes selected cell text strikethrough.
CTRL + 6 Displays / hides objects. CTRL + 8 Displays / hides outline symbols.
CTRL + 9 Hides selected rows. CTRL + 0 Hides selected columns.
CTRL + A CTRL + A once will select current data range, second time it will select whole sheet and third time it will select whole worksheet. CTRL + B Makes selected cell text bold.
CTRL + C Copy data. CTRL + D Fill Down command to paste topmost cell to all selected cells below it. CTRL + F Opens 'Find and Replace' dialog box with ' Find' tab. CTRL + G Opens ' Go To' dialog box. CTRL + H Opens ' Find and Replace' dialog box with ' Replace' tab. CTRL + I Makes selected cell text italic. CTRL + K Opens insert 'Insert Hyperlink' dialog box.
CTRL + N Opens new workbook. CTRL + O Opens ' Open' dialog box. CTRL + P Opens ' Print'dialog box.
CTRL + R ' Fill Right' command to paste leftmost cell to all selected cells in the right side. CTRL + S Opens ' Save As' dialog box. CTRL + T Opens ' Create Table' dialog box. CTRL + U Makes selected cell text underline.
CTRL + V Paste data. CTRL + W Close current sheet.
CTRL + X Cut data. CTRL + Y Redo last action. CTRL + Z Undo last action. CTRL +: Insert current system time. CTRL +; Insert current system date.
Microsoft Excel Shortcuts Pdf
CTRL + ' Copy value of cell above it. CTRL + ' Copy formula of cell above it. Shortcuts with Shift Key Keys Description Shift + F1 What’s this?