CTRL+Shift+F3 Create name by using names of row and column labels CTRL+Shift+F6 Previous Window CTRL+Shift+F12 Print Alt + = Create a formula to sum all of the above cells Alt + Enter While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell. CTRL + Shift + Format number in time format. CTRL + Shift + ^ Format number in scientific format. CTRL + Shift + % Format number in percentage format. CTRL + Shift + # Format number in date format. CTRL + Shift + $ Format number in currency format. CTRL + Shift + ! Format number in comma format. CTRL + Shift + = Insert a new column or row. CTRL + Arrow key Move to next section of text. CTRL + Tab Move between Two or more open Excel files. CTRL + Page down Move between Excel work sheets in the same Excel document. F1 Help F2 Edit F3 Paste Name F4 Repeat last action F4 While typing a formula, switch between absolute/relative refs F5 Goto F6 Next Pane F7 Spell check F8 Extend mode F9 Recalculate all workbooks F10 Activate Menubar F11 New Chart F12 Save As CTRL + Page up Move between Excel work sheets in the same Excel document. CTRL + - Delete the slected column or row. CTRL++ Displays the Insert dialog box to insert blank cells. CTRL+" Copies the value from the cell above the active cell into the cell or the Formula Bar. CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar. CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet. CTRL+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). CTRL+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Applies the Time format with the hour and minute, and AM or PM. CTRL+# Applies the Date format with the day, month, and year.
![shortcut keys for symbols in excel 2010 shortcut keys for symbols in excel 2010](https://cdn.slidesharecdn.com/ss_thumbnails/aguideshortcutkeysalphabeticallisting-13441672482-phpapp02-120805064945-phpapp02-thumbnail-4.jpg)
CTRL+^ Applies the Exponential number format with two decimal places. CTRL+% Applies the Percentage format with no decimal places. CTRL+$ Applies the Currency format with two decimal places (negative numbers in parentheses). CTRL+~ Applies the General number format. CTRL+_ Removes the outline border from the selected cells. CTRL+& Applies the outline border to the selected cells. CTRL+) Unhides any hidden columns within the selection. CTRL+( Unhides any hidden rows within the selection. CTRL+8 Displays or hides the outline symbols. CTRL+7 Displays or hides the Standard toolbar. CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects. CTRL+3 Applies or removes italic formatting. CTRL+2 Applies or removes bold formatting. CTRL+1 Displays the Format Cells dialog box.
![shortcut keys for symbols in excel 2010 shortcut keys for symbols in excel 2010](https://img.webnots.com/2013/04/Zodiac-Symbols.png)
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry you typed. CTRL+Y Repeats the last command or action, if possible.
![shortcut keys for symbols in excel 2010 shortcut keys for symbols in excel 2010](https://www.chelseadatamanagement.com/wp-content/uploads/2019/04/arrow1.png)
CTRL+W Closes the selected workbook window. Available only after you cut or copied an object, text, or cell contents. CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. CTRL+S Saves the active file with its current file name, location, and file format. CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. CTRL+O Displays the Open dialog box to open or find a file. CTRL+L Displays the Create List dialog box. CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. CTRL+I Applies or removes italic formatting. CTRL+H Displays the Find and Replace dialog box. CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
![shortcut keys for symbols in excel 2010 shortcut keys for symbols in excel 2010](https://excelchamps.com/wp-content/uploads/2019/02/search-for-the-checkmark-from-the-searchbar-and-click-on-it-to-insert-it.png)
CTRL+B Applies or removes bold formatting.