Move to the last used cell of the current worksheet, i.e. Move to the beginning of a worksheet (A1 cell). Return to the 1st cell of the current row in a worksheet. Press Ctrl + PgUp to switch to the previous sheet. Hide the ribbon to view more than 4 rows of data. Navigating and Viewing Data Shortcut Keys Insert the formula of the above cell into the currently selected cell or the Formula Bar.
Toggle between displaying cell values and formulas. Place the cursor within a cell and hit F4 to get the needed reference type Select all the cells below the selected cellĬycle through various combinations of formula reference types Select all the cells above the selected cell Select the column from the selected cell to the end of the table Insert the contents of the Clipboard into the selected cell(s).Ĭell Formatting Shortcut Keys Shortcut Keys Save the active workbook using a new name, displays the Save as dialog box.Ĭopy the contents of the selected cells to Clipboard.Ĭut the contents of the selected cells to Clipboard. Below mentioned keys need you to press them simultaneously. No doubt some shortcut keys are the basic ones, however it will be a plus point for the beginners. Save the list and all the functions will be just one click away. Whenever you need to perform any task, you can use these shortcut keys accordingly. Though you cannot remember all the keys however, if you keep them save with you, it will be more like a blessing. Today, you will get to know about the most used Excel hotkeys all the way through this post. It makes your life super easy when it comes to deal with large or even small datasheets containing multiple values to analyze. Everyone likes shortcuts and there is no objection on using these keyboard shortcuts while working with Excel.
0 kommentar(er)
