Using this option user can save the file at the required folder locationĬtrl + F4: This is used to close the current active excel workbook 2. To do “File” operations:Ĭtrl + O: To open required excel workbookĬtrl + S: To save current active excel workbookį12: This shortcut key is used for directly access the “Save As” option. If you are looking for an way to improve your Excel skills sets, Check out some of the Best Excel Courses Online for less than $20 1. These 70 tips range from general to data operation. These should help you become much more efficient and leave more time to analyze and visualize your data. So, here is a collection of some of the most useful Excel Keyboard shortcuts. Formulas now become shortcuts to help you navigate large spreadsheets, allowing you to jump between and detail sections and totals.One thing that I love to do more than anything is save time.
If you’re thinking of deleting or changing a cell but don’t know what it will affect, Ctrl+] will tell you if it is used in any formulas.If you want to quickly check to make sure your formula is pointing to the right cell, Ctrl+ to get back where you started.
Some of you are asking why anyone would want to do that.
I’ve written before about the ability to trace precedents and dependents, But I recently learned two keyboard shortcuts that take you to your current cell’s precedents or dependents.Ĭtrl+ will move your cursor to the dependent(s) of the current cell, that is, the cell or cells with a formula that uses the current cell. Conversely, the cell containing the formula is a dependent because it needs the cell containing the data to complete its function. In Excel, the other cells that are referred to in a formula are called precedents.
0 kommentar(er)
