Ctrl With Excel......
Shortcut Keys Description
- Ctrl + A :- Select all contents of the worksheet.
- Ctrl + B :- Bold highlighted selection.
- Ctrl + C :- Copy select cell.
- Ctrl + D :- Auto copy & past in upper cell.
- Ctrl + F :- Open the "find" window.
- Ctrl + G :- Open the "Go to" window.
- Ctrl + H :- Open the "replace"window.
- Ctrl + I :- Italic highlighted selection.
- Ctrl + K :- Insert link.
- Ctrl + L :- Create table.
- Ctrl + N :- Open new workbook.
- Ctrl + O :- Open your save history.
- Ctrl + P :- Bring up the pint dialog box to begin the printing process.
- Ctrl + Q :- Quick analysis.
- Ctrl + R :- Auto copy & past in left cell.
- Ctrl + S :- Save the open worksheet.
- Ctrl + U :- Underline highlighted selection.
- Ctrl + V :- Paste copied cell.
- Ctrl + X :- Cut select cell.
- Ctrl + Y :- Redo last action.
- Ctrl + Z :- Undo last action.
- Ctrl + ; :- Enter the current date.
- Ctrl + Shift + ; :- Enter the current time.
- Ctrl + Shift + = :- Insert a new column or row.
- Ctrl + Shift + 1 :- Format number in comma format.
- Ctrl + Shift + 2 :- Format number in time format.
- Ctrl + Shift + 3 :- Format number in date format.
- Ctrl + Shift + 4 :- Format number in currency format.
- Ctrl + Shift + 5 :- Format number in percentage format.
- Ctrl + Shift + 6 :- Format number in scientific format.
- Ctrl + F3 :- Open excel name manager.
- Ctrl + F6 :- Switch between workbooks or windows.
- Ctrl + F9 :- Minimize current window.
- Ctrl + F10 :- Maximize currently selected window.
- Ctrl + Page up :- Move between work sheets in the same document.
- Ctrl + Page down :- Move between work sheets in the same document.
- Ctrl + Tab :- Move between two or more open excel file.
- Ctrl + Space :- Select entire column.
- Ctrl + Home :- Move to cell A1.
- Ctrl + Arrow Key :- Move to next section of text.
- Ctrl + - :- Delete the selected column or row.
- Ctrl + + :- Add the selected column or row.
- Ctrl + ~ :- Switch between showing Excel formulas or their values in cells.
No comments:
Post a Comment