Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.Now, does anyone expect you to memorize all these keyboard combos? Of course not! Everyone’s needs are different, so some will be more useful to you than others. And even if you pick up a few new tricks, it’s worth it. We’ve also tried to keep the list clean and simple, so go ahead and print it that helps!Also, even though our list of shortcuts here is pretty long, it’s by no means a complete list of every keyboard combo available in Excel. We’ve tried to keep it to the more generally useful shortcuts.
And, you’ll be happy to know that almost all of these shortcuts have been around for a long time, so they should be helpful no matter what version of Excel you’re using. General Program ShortcutsFirst, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions. Ctrl+N: Create a new workbook. Ctrl+O: Open an existing workbook. Ctrl+S: Save a workbook. F12: Open the Save As dialog box.
Shortcut Keys In Excel Youtube
Ctrl+W: Close a workbook. Ctrl+F4: Close Excel.
F4: Repeat the last command or action.
Generally, you can improve your speed by keeping your hands on your keyboard. But, what do you do if there is no built-in keyboard shortcut to execute your favorite command?
Well, one approach is to customize the QAT. This post discusses the Quick Access Toolbar and the related keyboard shortcuts it creates. QAT ShortcutsMicrosoft introduced the Quick Access Toolbar (QAT) in Excel 2007 with the rollout of the ribbon. It is a tiny little toolbar that includes a few commands by default, such as save, undo, and redo.You can see it in the following screenshot just above the ribbon:The nice thing about the QAT is that Excel automatically creates a simple keyboard shortcut to access its command icons.
If you tap the Alt key, you’ll notice that the QAT icons each get a sequential number, 1, 2, 3, and so on, as shown below.The QAT commands are easily accessed by tapping the corresponding Alt+Number combination. This is quite handy, especially since we can customize the QAT to include additional commands. QAT CustomizationMicrosoft allows us to customize the QAT, including positioning it above or below the ribbon and adding/removing commands.
On the right side of the QAT you’ll see a little dropdown arrow, and when you click it, you’ll have access to the various customization options, as shown below.Some of the basic commands are provided in the dropdown menu, and you can toggle them on or off. In addition, you can select More Commands to open up the Excel Options dialog to select from a huge number of Excel commands. Remember how the QAT automatically creates an Alt shortcut for its icons? Well, when you add a command to the QAT you’ll be able to access it with a simple Alt shortcut. So, any frequently used commands become a simple shortcut away.Let’s walk through an example. Back in Excel 2003 and earlier, I could quickly access the document properties dialog box by hitting Alt+F, I. I loved this dialog because it showed the full path of the file and I was able to quickly confirm that I was working on the correct document.
Shortcut Keys In Excel Pdf
I lost that dialog beginning with Excel 2007 and the new document properties didn’t seem to show the full file path. The good news is that it is easy to customize the QAT to regain that dialog. We’ll use this customization as an example, but keep in mind, there are hundreds of commands available to add, so, you can easily customize the QAT to include just your favorites and frequently used commands.We click the little QAT dropdown and select More Commands to open the Excel Options dialog. Then, we select All Commands from the Choose commands from dropdown, select Advanced Document Properties from the command list, and click the Add button, as shown below.Now, the Advanced Document Properties icon appears in the QAT, and I can easily access it with the corresponding Alt+4 shortcut, as shown below.In addition to adding built-in commands, you can add macros to the QAT.
Simply select Macros from the Excel Options dialog, and then pick your macro. Now, you can launch the macro with the corresponding Alt+Number shortcut. I have a macro that sets up my standard worksheet header and I access it with the QAT keyboard shortcut several times a day.
This saves quite a bit of time which makes me happy!If you have other observations about the QAT or related tips or tricks you’d like to share, please post a comment below! Additional Comments. Beginning with Excel 2010, we can also customize the ribbon by adding new tabs and icons.
Full List Of Excel Shortcuts
Investigate it here: Excel Options Customize Ribbon. In addition to adding ribbon icons to the QAT, you can add commands that don’t appear in the ribbon. There are many Excel commands that do not appear in the ribbon, and customizing the QAT is a great way to gain access to them.
Microsoft Excel is a very powerful application for spreadsheet processing and a pretty old one,. Each new version of Excel came with more and more new shortcuts and seeing the full list (over 200!) you may feel a bit intimidated.
20 or 30 keyboard shortcuts will absolutely suffice for everyday work; while others are purposed for highly specific tasks such as writing VBA macros, outlining data, managing PivotTables, recalculating big workbooks, etc.I've put together a list of the most frequent shortcuts below and you can download it as a printable image (, ) or a for your convenience.If you want to re-arrange the shortcuts to your liking or extend the list, then Must-have Excel shortcuts no workbook can do withoutI know, I know, these are basic shortcuts and most of you are comfortable with them. Still, let me write them down again for beginners.Note for newbies: The plus sign '+' means the keys should be pressed simultaneously. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards. Ctrl + NCreate a new workbook.Ctrl + OOpen an existing workbook.Ctrl + SSave the active workbook.F12Save the active workbook under a new name, displays the Save as dialog box.Ctrl + WClose the active workbook.Ctrl + CCopy the contents of the selected cells to Clipboard.Ctrl + XCut the contents of the selected cells to Clipboard.Ctrl + VInsert the contents of the Clipboard into the selected cell(s).Ctrl + ZUndo your last action. Panic button:)Ctrl + POpen the 'Print' dialog.Formatting data Ctrl + 1Open the 'Format Cells' dialog.Ctrl + T'Convert selected cells to a table. You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table.Find more about and their features.Working with formulas TabAutocomplete the function name. Example: Enter = and start typing vl, press Tab and you will get = vlookup(F4Cycle through various combinations of formula reference types.
Place the cursor within a cell and hit F4 to get the needed reference type: absolute, relative or mixed (relative column and absolute row, absolute column and relative row).Ctrl + `Toggle between displaying cell values and formulas.Ctrl + 'Insert the formula of the above cell into the currently selected cell or the Formula Bar.Navigating and viewing data Ctrl + F1Show / hide the Excel Ribbon. Hide the ribbon to view more than 4 rows of data.Ctrl + TabSwitch to the next open Excel workbook.Ctrl + PgDownSwitch to the next worksheet. Press Ctrl + PgUp to switch to the previous sheet.Ctrl + GOpen the 'Go to' dialog. Pressing F5 displays the same dialog.Ctrl + FDisplay the 'Find' dialog box.HomeReturn to the 1st cell of the current row in a worksheet.Ctrl + HomeMove to the beginning of a worksheet (A1 cell).Ctrl + EndMove to the last used cell of the current worksheet, i.e. The lowest row of the rightmost column.Entering data F2Edit the current cell.Alt + EnterIn cell editing mode, enter a new line (carriage return) into a cell.Ctrl +;Enter the current date. Press Ctrl + Shift +; to enter the current time.Ctrl + EnterFill the selected cells with the contents of the current cell.Example: select several cells. Press and hold down Ctrl, click on any cell within selection and press F2 to edit it.
Tomtom mydrive connect app. Then hit Ctrl + Enter and the contents of the edited cell will be copied into all selected cells.Ctrl + DCopy the contents and format of the first cell in the selected range into the cells below. If more than one column is selected, the contents of the topmost cell in each column will be copied downwards.Ctrl + Shift + VOpen the 'Paste Special' dialog when clipboard is not empty.Ctrl + YRepeat (Redo) the last action, if possible.Selecting data Ctrl + ASelect the entire worksheet. If the cursor is currently placed within a table, press once to select the table, press one more time to select the whole worksheet.Ctrl + Home then Ctrl + Shift + EndSelect the entire range of your actual used data on the current worksheet.Ctrl + SpaceSelect the entire column.Shift + SpaceSelect the entire row.If you find the post useful, please click the Like buttons and share with friends, or just drop me a comment:) See also. Some shortcuts that I use everyday but not listed in the first post:Ctrl + Shift + L (to apply/ remove filter)Ctrl + B / I / U (don’t need to explain do I?)F7 (spell check)Ctrl + roll the mouse wheel (zoom in and out)Hold down Ctrl, click hold a worksheet tab, drag across to the right hand side, release the mouse then release the Ctrl key (this duplicates the current worksheet instantly on a new tab, surprisingly useful in some situations)Also, customized the quick access toolbar to my exact requirement, place it below the ribbon, and hide the ribbon (Ctrl + F1) – this is my Excel layout.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |