15 Short Cut Keys Of Excel That Help To Work Fast
Sat Dec 17, 2022
Table of Contents:
A. 15 Shortcut keys of Excel
15 Shortcut keys of Excel
This key combination is used to end a cell or row by moving the cursor at the end of it. To move the cursor up, press the Ctrl+Shift+Up arrow key combination and for moving down, use the Ctrl+Shift+Down arrow key combination.
Use this shortcut key combination when you want to switch between open windows in Excel without closing them first (such as between two different worksheets). You can also use this shortcut key combination when there is only one window open but if there are multiple windows open then the Alt+Tab will not work well since they are all vying for your attention!
4. Ctrl+F (Find)
This key is used to search for a word or phrase in your document, worksheet, or any other place where you have entered text. This key will open the Find dialog box which contains all the options related to finding things in your document. You can also use this key combination while searching within a cell (or range) of data.
Close the active sheet tab or close the dialog box without closing the file. This is useful when you have a lot of open windows and want to get rid of one without closing all others, just press Ctrl+W and it will disappear from view immediately!
6. Ctrl + Shift + FThis combination selects all cells in the active range and makes them editable. It’s a handy way to make changes across many cells at once without having to manually select each one individually. These shortcuts key can make it very easy to learn excel for beginners.
7. Alt + F3
This key combination is used to copy the current cell or range into another cell or range. For example, if you want to paste the value in A2 into cell B2, press Alt+F3 and then click on B2. The same process can be used for moving data between cells as well. You might also use this shortcut key when copying formulas from one place to another within a worksheet. but be careful not to confuse it with Ctrl+C which copies an entire column or row into the next empty cell below it!
This is one of the most important excel shortcuts key in Excel. This combination of keys will open up a new file in the current window, but if there's already an open document in that window, it'll just create another copy of it instead.
This shortcut key combination takes you back to where your cursor was located when you started typing into an empty column or row, or just before the first blank cell in a worksheet (if there are no empty cells). Pressing Alt+Home twice will take you back two steps, which means that if your cursor is located between two columns and rows, this shortcut will only move it up one row (or column) each time it is pressed once.
10. Ctrl + Shift + AThis is another handy shortcut key that will take you directly to AutoFormat options in Excel. When we use this key combination, it will automatically apply formatting options such as bold, italic, etc., based on what has been entered into the cell. Learn excel for beginners can be a tough task but with the use of shortcut keys, you can make it easier.
Use this shortcut key combination if you need to go directly to any other part of Excel without using the Ribbon menus or dialog boxes. This will take you directly to another sheet in the same workbook window or another tab inside that window depending on where your cursor is when pressing Alt+F2.
12. Ctrl + Alt + Down Arrow
This shortcut lets you move the active cell up one row or down one column. This is especially useful when working with large data sets, where it may be impossible to scroll through them all on your own. You can also use this shortcut to select the whole column or row if there are too many cells in it for you to see clearly at once.
13. Ctrl + T
This shortcut key combination opens up the “Table” menu which allows you to create tables within your worksheet or even add them from scratch. You can also use this shortcut key combination while in edit mode to select specific rows or columns within a table based on their index number (1-100).
This key combination opens the Format Cells dialog box so that you can apply formatting options such as bold and italics, change fonts and cell borders, adjust alignment, add borders or fill colors, apply cell styles and choose border styles for cells in tables. You can also use this key combination to open other dialog boxes such as Conditional Formatting Rules Editor and Data Outline pane (if available).
Press this key combination once, then select any cell within the current column or row (not just those directly below). Pressing this combination again will take you to back up one level from where you started, so if you were looking at A1:C3 but wanted to look at A2 instead, simply press Ctrl+F3 twice more until A2 comes into view on its own. These combinations are the best excel keyboard shortcuts to complete your tasks in less time.
Your life will be made so much easier by using these 15 Excel shortcut keys. By enrolling in the MS Excel full course in Hindi, you can learn more about Excel. You can obtain a Microsoft Excel certification after completing this course, which you can add to your resume.
Letstute (Universal Learning Aid Pvt. Ltd.) is an E-learning company based in Mumbai, India.