Computer Short Keys
Computer Short Keys for the preparation of NTS, PPSC, SPSC, BPSC, KPSC, FPSC, OTS and other academic entry test and jobs tests.
Ctrl + A | Select All
Ctrl + B | Bold
Ctrl + C | Copy
Ctrl + D | Fill
Ctrl + F | Find
Ctrl + G | Bold
Ctrl + H | Replace
Ctrl + I | Italic
Ctrl + K | Insert a hyperlink
Ctrl + N | New workbook
Ctrl + O | Open
Ctrl + P | Print
Ctrl + R | Nothing right
Ctrl + S | Save
Ctrl + U | Underlined
Ctrl + V | Paste
Ctrl + W | Close
Ctrl + X | Cup
Ctrl + Y | Repeat
Ctrl + Z | Cancel
F1 | Help
F2 | Edition
F3 | Paste the name
F4 | Repeat the last action
F4 | When entering a formula, switch between absolute / relative references
F5 | Go to
F6 | Next Pane
F7 | Spell Check
F8 | Extension of the mode
F9 | Recalculate all workbooks
F10 | Activate Menu bar
F11 | New graph
F12 | Save As
Ctrl +: | Insert the current time
Ctrl +; | Insert the current date
Ctrl + “ | Copy the value of the cell above
Ctrl + ‘ | Copy the formula from the cell above
Shift |Offset Adjustment for Additional Functions in the Excel Menu
Shift + F1 | What is it
Shift + F2 | Edit cell comment
Shift + F3 | Paste the function into the formula
Shift + F4 | Search Next
Shift + F5 | Find
Shift + F6 | Previous Panel
Shift + F8 | Add to the selection
Shift + F9 | Calculate the active worksheet
Shift + F10 | Popup menu display
Shift + F11 | New spreadsheet
Shift + F12 | Save
Ctrl + F3 | Set name
Ctrl + F4 | Close
Ctrl + F5 | XL, size of the restore window
Ctrl + F6 | Next Workbook Window
Shift + Ctrl + F6 | Previous Workbook Window
Ctrl + F7 | Move window
Ctrl + F8 | Resize Window
Ctrl + F9 | Minimize the workbook
Ctrl + F10 | Maximize or Restore Window
Ctrl + F11 | Inset 4.0 Macro sheet
Ctrl + F1 | Open File
Alt + F1 | Insert a graph
Alt + F2 | Save As
Alt + F4 | Output
Alt + F8 | Macro dialog
Alt + F11 | Visual Basic Editor
Ctrl + Shift + F3 | Create a name using the names of row and column labels
Ctrl + Shift + F6 | Previous Window
Ctrl + Shift + F12 | Printing
Alt + Shift + F1 | New spreadsheet
Alt + Shift + F2 | Save
Alt + = | Auto Sum
Ctrl + `| Toggle value / display of the formula
Ctrl + Shift + A | Insert the argument names in the formula
Alt + down arrow | automatic view list
Alt + ‘| Format Style Dialog
Ctrl + Shift + ~ | General Format
Ctrl + Shift +! | Comma format
Ctrl + Shift + @ | Time Format
Ctrl + Shift + # | Date Format
Ctrl + Shift + $ | Currency Format
Ctrl + Shift +% | Percentage Format
Ctrl + Shift + ^ | Exponential Format
Ctrl + Shift + & | Place the border of the outline around the selected cells
Ctrl + Shift + _ | Delete the border of the contour
Ctrl + Shift + * | Select the current region
Ctrl ++ | Insert
Ctrl + – | Delete
Ctrl + 1 | Format of the cell dialog
Ctrl + 2 | Bold
Ctrl + 3 | Italic
Ctrl + 4 | Underlined
Ctrl + 5 | Strike through
Ctrl + 6 | Show / Hide Objects
Ctrl + 7 | Show / Hide Standard Toolbar
Ctrl + 8 | Toggle Outline symbols
Ctrl + 9 | Hide lines
Ctrl + 0 | Hide columns
Ctrl + Shift + ( | Show lines
Ctrl + Shift +) | Show columns
Alt or F10 | Activate the menu
Ctrl + Tab | In the toolbar: Next toolbar
Shift + Ctrl + Tab | In the toolbar: Previous toolbar
Ctrl + Tab | In a workbook: activate the next workbook
Shift + Ctrl + Tab | In a Binder: Activate Previous Binder
Tab | Next tool
Shift + Tab | Previous tool
Enter | Make the order
Shift + Ctrl + F | Font drop-down list
Shift + Ctrl + P | Point Size Drop-down list