Keep filter on columns, but show all rows Show/hide the top bar when you have a groupĬollapse the ribbon (press again to expand) (its easy to remember when working with some “tuf” formulas!)ĭisplay the formula palette after you type a valid function name in a formulaĪlternate between displaying cell values and displaying cell formulasĮxcel short keys related to Data formattingįormat Painter – Paste formats from selection Shortcut keys related to FORMULAS in MS Excelĭisplay range names (can be used when typing formulas)Įvaluate formulas. Toggle between workbooks in a given session of excel. Go to top left (will go to top left of freezed pane if set) Launch GO TO Dialog (from here you can select special or jump to a cell or range) Shortcut keys related to Navigation in Excel sheet Selects all the way to a1 from cursor position Select all cells with formulas that refer directly or indirectly to the active cell Select all cells that are directly or indirectly referred to by formulas in the selection Select range from start cell to end in direction of arrow Shortcut Keys related to Selection of content Please also read my another blog on Shortcut keys in SAP.
I also request you to open an excel sheet with some dummy data and use these shortcut keys. I am 100% sure that after reading these shortcut keys your work efficiency will improved to a significant extent. Do not worry I will not talk about Cut, Copy, Paste. Here is another mind blowing blog with some reliable information on Shortcut keys in MS excel.
Shortcut keys in MS excel to improve your efficiency at work
0 kommentar(er)
