![]() Ctrl + Shift + ): Unhide any hidden columns within the selection.Ctrl + Shift + (: Unhide any hidden rows within the selection.Ctrl + Alt + V: Open the Paste Special dialog box.Ctrl + V or Shift + Insert: Paste contents of selected data, or selected cell range.Ctrl + C or Ctrl + Insert: Copy contents of selected data, or selected cell range.Ctrl + X: Cut contents of selected data, or selected cell range.Alt + Enter: Insert a new line within a cell (when editing a cell).Press F2 to get into the editing mode of a cell without double-clicking with a cursor is just one of the many tips to make your work easier. Shortcut keys used to edit a cell in excel is especially useful when you are using a laptop that doesn’t come with a mouse. Alt + Down Arrow > C: Clear filter in columnĮdit Cell in Excel using Keyboard Shortcuts.Alt + Down Arrow > F > N > Enter: Display non-blank cells.Alt + Down Arrow > F > E > Enter: Display blank cells.Alt + Down Arrow > F > F: Open custom filter dailog box.E: Search by text, after filter menu is displayed.T: Sort by color, after filter menu is displayed.O: Sort by descending order, after filter menu is displayed.S: Sort by ascending order, after filter menu is displayed.Enter: Apply selected filtering command.Spacebar: Check or Uncheck items in filter.Up/Down Arrow: Selecting menu items in filter.Alt + Down Arrow: Display filter menu for a column.Ctrl + Shift + L: Apply or clear filter of a range of data (Toggle filter function On/Off).Start by creating a filter for a range of data, here are some filter shortcut keys to boost your productivity. By displaying only the rows that meet certain conditions, using the stored data, you can quickly find the information you want. The key function of Excel is the ability to filter and sort data with a simple click of the mouse, or by filter shortcut keys. Recommendations: Best Online Learning Platform To Learn A New Skill Ctrl + A: Select all cells in the worksheet.Ctrl + Shift + Space: Select the entire worksheet.Shift + Left/Right Arrow: Extend the cell selection to the left or right.Keyboard shortcuts are applicable to Google Sheet as well. These shortcut keys can save you plenty of time, especially if you are working on a huge worksheet with lots of data. Selecting cell contents in Excel is one of the most used commands. Ctrl + Page Up/Down: Move to the previous or next worksheet Selecting Cells.Alt + Page Up/Down: Move one screen to the right or left in a worksheet.Page Up/Down: Move one screen up or down in a worksheet.Ctrl + Home: Move to the beginning of a worksheet.Home: Go to the leftmost cell in the current row, or go to the beginning of the cell if editing a cell.Ctrl + End: Go to the most bottom right used cell.Ctrl + Up/Down Arrow: Move to the cell most top or bottom in the column.Up/Down Arrow: Move one cell up or down.Ctrl + Left/Right Arrow: Move to the cell most left or right in the row.Left/Right Arrow: Move one cell to the left or right.Using keyboard shortcuts to get around the worksheet and moving between cells can be a great time-saver when working on Excel. Recommendations: Complete beginner’s Guide to set up your home office. It will repeat that action in the new cell. if the previous action, you’ve typed in a cell is “Go!” or if you change the font color. F4: Repeat the last command or action.Ctrl + Alt + V: Display paste special dialogue box.Ctrl + V: Paste previously copied information.Ctrl + A: Select all selections Advertisements.Shift + Arrow keys: Select highlighted selections.Ctrl + F9: Minimize the workbook window.These 27 basic shortcut keys in Excel, can potentially improve your productivity by 300%. Some are general Microsoft Office keyboard shortcuts, while others are specifically for MS Excel. As a fellow Excel enthusiast, I think these Excel courses will definitely benefit you, so give it a try and check it out!īeginner and advanced Excel users may or may not have known some of these keyboard combinations for Excel. We just did an in-depth review of the Top 5 Best Excel Courses that can help you to improve your Excel Skills. But learning just a few from this list can turn you from an Excel beginner, into an advanced Excel user! Just by learning the basic shortcut keys in Excel can improve your productivity by 300% or more.Įven though our list of Excel shortcuts is massive, it’s not a complete list. No one can memorize all these keyboard combos, but some shortcut keys are more useful than others. MS Excel shortcut keys differentiate the beginners from the pros, but with hundreds of shortcuts in Excel, do you need to learn them all? Now, even when you are familiar with Microsoft Excel, you might be pleasantly surprised that there is a wide range of keyboard shortcuts that can boost your productivity and make your life much easier.
0 Comments
Leave a Reply. |