CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ A to Z shortcut keys listed to keep you ahead of the competitions.
DOWNLOAD for printing – Excel – CTRL_A_Z_Shortcuts Pinup Reference
CTRL Shortcut | Action |
CTRL+A | Select the entire worksheet |
CTRL+B | Apply or remove Bold formatting to font |
CTRL+C | Copy |
CTRL+D | Copy the contents and format of the topmost cell of a selected range into the cells below |
CTRL+E | Flash Fill |
CTRL+F | Find |
CTRL+G | Go To |
CTRL+H | Find and Replace |
CTRL+I | Apply or remove Italics formatting to font |
CTRL+J | Not assigned. Still available. |
CTRL+K | Open the Insert hyperlink dialog |
CTRL+L | Display the Create Table dialog (Alternative is CTRL+T) |
CTRL+M | Not assigned. Still available. |
CTRL+N | Create a new Workbook |
CTRL+O | Display File Open dialog box |
CTRL+P | Invokes Print |
CTRL+Q | Display the Quick Analysis options for selected cells that contain data |
CTRL+R | Copy the contents and format of the leftmost cell of a selected range into the cells to the right |
CTRL+S | Save the workbook |
CTRL+T | Display the Create Table dialog (Alternative is CTRL+L) |
CTRL+U | Apply or remove Underline formatting to font |
CTRL+V | Paste |
CTRL+W | Redo the last action |
CTRL+X | Cut |
CTRL+Y | Repeat the last command or action |
CTRL+Z | Undo the last action |
Thanks for sharing excellent informations. Your web-site is very cool. I am impressed by the details that you have on this blog. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the info I already searched all over the place and simply couldn't come across. What a great website.