Excel, a main product of Microsoft Office is a tool that is very common and used around offices. Despite having a lot of competitors, none can deny that Excel is a tool that will stay for a long time, especially when it is perfectly built for one of the most popular Operating System at the market – Windows.
To give you a few shortcut keys using the main keyboard, please see the list available below.
EXCEL MAIN KEYBOARD SHORTCUT KEYS | ||||||
Windows | Mac | Effect | ||||
CTRL | + | N | ⌘ | + | N | Create new workbook |
CTRL | + | O | ⌘ | + | O | Open workbook |
CTRL | + | S | ⌘ | + | S | Save workbook |
CTRL | + | P | ⌘ | + | P | Print file |
CTRL | + | Z | ⌘ | + | Z | Undo last action |
CTRL | + | Y | ⌘ | + | Y | Redo last action |
CTRL | + | C | ⌘ | + | C | Copy selected cells |
CTRL | + | X | ⌘ | + | X | Cut selected cells |
CTRL | + | V | ⌘ | + | V | Paste content from clipboard |
CTRL | + | F | ⌘ | + | F | Display find and replace |
CTRL | + | H | ⌘ | + | H | Find with replace selected |
CTRL | + | T | ⌃ | + | T | Insert table |
CTRL | + | A | ⌘ | + | A | Select table |
CTRL | + | G | ⌘ | + | G | Go to dialog box |
CTRL | + | E | ⌘ | + | E | Flash fill |
CTRL | + | D | ⌘ | + | D | Fill down from cell above |
CTRL | + | K | ⌘ | + | K | Add hyperlink |
CTRL | + | B | ⌘ | + | B | Apply or remove bold formatting |
CTRL | + | I | ⌘ | + | I | Apply or remove italic formatting |
CTRL | + | U | ⌘ | + | U | Apply or remove underscoring |
CTRL | + | . | ⌃ | + | . | Move active cell clockwise in selection |
CTRL | + | ; | ⌃ | + | ; | Insert current date |
CTRL | + | ` | ⌃ | + | ` | Copy formula from cell above |
I hope you could remember and use most of this and if there are any that needs improvement and better explanation, please do not hesitate to drop a comment so we could check and update it as needed.
Discussion about this post