shortcut keys of excel
Answers
Answered by
5
Ctrl+TabMove between Two or more open Excel files.Alt+=Create a formula to sum all of the above cells.Ctrl+'Insert the value of the above cell into the cell currently selected.Ctrl+Shift+1Format number in comma format
Answered by
12
Keyboard Shortcuts for MS-Excel 2007
Ctrl Combination Shortcut Keys
Ctrl+Shift+( Unhides any hidden rows within the selection
Ctrl+Shift+) Unhides any hidden columns within the selection
Ctrl+Shift+$ Applies the currency format with two decimal places
Ctrl+Shift+@ Applies the Time format with the hour and minute and AM or PM
Ctrl+Shift+ Copies the value from the cell above the active cell into the cell or the Formula bar
Ctrl+; Enters the current date
Ctrl+9 Hides the selected rows
Ctrl+N Creates a new blank workbook
Ctrl+P Displays the Print dialog box
Ctrl+X Cuts the selected cells
Ctrl+U Applies or removes underlining
Ctrl+S Saves the active file with its current file name,location and file format
Ctrl+Z Uses the Undo command to reverse the last command
Function Keys
F1 Displays the Microsoft Office Excel Help task pane
F2 Edits the active cell and positions the insertion at the cell contents
F6 Switches between the worksheet,ribbon,task pane and zoom controls
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range
F11 Creates a chart of the data in the current range
F12 Displays the Save As dialog box
Hope this shortcut keys helps you in MS-Excel 2007
-Ekansh Nimbalkar
Ctrl Combination Shortcut Keys
Ctrl+Shift+( Unhides any hidden rows within the selection
Ctrl+Shift+) Unhides any hidden columns within the selection
Ctrl+Shift+$ Applies the currency format with two decimal places
Ctrl+Shift+@ Applies the Time format with the hour and minute and AM or PM
Ctrl+Shift+ Copies the value from the cell above the active cell into the cell or the Formula bar
Ctrl+; Enters the current date
Ctrl+9 Hides the selected rows
Ctrl+N Creates a new blank workbook
Ctrl+P Displays the Print dialog box
Ctrl+X Cuts the selected cells
Ctrl+U Applies or removes underlining
Ctrl+S Saves the active file with its current file name,location and file format
Ctrl+Z Uses the Undo command to reverse the last command
Function Keys
F1 Displays the Microsoft Office Excel Help task pane
F2 Edits the active cell and positions the insertion at the cell contents
F6 Switches between the worksheet,ribbon,task pane and zoom controls
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range
F11 Creates a chart of the data in the current range
F12 Displays the Save As dialog box
Hope this shortcut keys helps you in MS-Excel 2007
-Ekansh Nimbalkar
Similar questions