Study Material for Online Education
[Subject : Computer Science]
| MS excel(commonly used shortcut keys) | |
|---|---|
| shortcut keys | used for |
| Ctrl+A | select the entire worksheet. |
| Ctrl+B | bold text of selected cell/cells. |
| Ctrl+C | copy the contents of the selected cells to clipboard. |
| Ctrl+D | copy the contents and format of the first cell in the selected range into the cells below. |
| Ctrl+F | display the find dialog box. |
| Ctrl+F1 | show hide the excel ribben. |
| Ctrl+G | open the go to dialog bix.pressing F5 displays the same dialog. |
| Ctrl+N | create a new workbook. |
| Ctrl+O | open an existing workbook. |
| Ctrl+P | Open the print dialog box. |
| Ctrl+S | save the active worksheet. |
| Ctrl+T | convert selected cell to a table. |
| Ctrl+V | paste the content of the clipboard into the selected cell(s). |
| Ctrl+W | close the active workbook |
| Ctrl+X | cut the contents of the selected cells to clipboard. |
| Ctrl+1 | open the format cells dialog. |
| Ctrl+' | toggle between displaying cell values and formulas. |
| Ctrl+; | enter the current date. |
| Ctrl+shift+; | enter the currrent time. |
| F2 | edit the current cell. |
| home | return to the first cell of the current row in a worksheet. |
| tab | autocomplete the function name. |
| Ctrl+end | move to last used cell of the current worksheet. |
| Ctrl+home | move to the beginnning of a worksheett. |
| Ctrl+pgdown | switch to the next worksheet. |
| Ctrl+pgup | switch to the previous worksheet. |
| Alt+enter | in cell editing mode,enter a new line into a cell. |
| Ctrl+space | select the entire column. |
| shift+space | select the entire row |