Or, if editing is turned off for the cell, move the insertion point into the formula bar. They will save you time.Įdit the active cell and put the insertion point at the end of its contents. Highlight the ones you feel most useful to you and learn them. Please refer to the other lists that I have posted before for General Shortcuts, Navigating, Formatting, Referencing and Selecting. The F4 key is so much quicker to insert absolute referencing in your formulae than typing the dollar sign. When you have set Excel to calculate manually it’s easy to use the F9 key to ask for calculation of all worksheets in all open workbooks, whereas Shift+F9 only calculates the one active sheet you are in.
So using F3 lists all the names in the workbook and you can choose the one you need. When I use named ranges in formulas it is great to be able to select from a list rather than type the name as you might mistype it or refer to a name that does not exist.
I have highlighted for you some that I find very useful to know. This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar.
0 kommentar(er)
