Excel Shortcut keys for Selecting Rows, columns, cellsīy holding down the shift key while moving will add the cells to the selection, but if you wish to select the whole row or the entire column, you don’t have to move each cell just press Excel Shortcut Keys for Easy NavigationĬtrl+Right arrow -> takes you the rightmost column in the existing rowĬtrl+Left arrow -> takes you the left-most column in the existing rowĬtrl+Up arrow -> moves the cursor to the topmost row in the existing columnĬtrl+Down arrow -> moves the cursor to the bottom-most row in the existing columnĬtrl+Page Down -> Changes the active sheet next to the rightĬtrl+Page UP -> Changes the active sheet next to the left Excel Shortcut keys to Add or remove rows and columnsĬtrl+Shift+= ( Ctrl++) -> will open a dialogue to insert a new row or a column or to shift the cells right or downĬtrl + – –> will open a dialogue to delete a row or a column or to shift the cells left or up Excel Shortcut keys to Apply FiltersĬtrl+Shift+L or Alt+D+F+F – Toggles the header to apply the filter or to remove the filter.įilter applied to the data can be used to sort the data in ascending or descending or to filter out the data based on the color, text or selected values. To taste the power of excel flavored with shortcuts, start using the shortcuts which are basic and most commonly used. N avigating within the worksheet or among the worksheets.Working on excel have a lot of small but repetitive steps for which you can use the shortcuts, like In the end, we have shared the list which is the collection of a few most common excel shortcut keys used, it’s good if you use them all but most of the time we don’t use them all. Working on this powerful application you need to learn its functionalities and get used to it then you will love working on excel. From small data entry to big complex projects anything can be accomplished through today’s powerful excel application of Microsoft. Today we cannot imagine any company without excel in their daily work. During the last 34 years since the initial release of excel, it has improved a lot.
0 kommentar(er)
