Wednesday, 28 January 2015

Formula Editing

When you are editing formulas if you click past the end of the formula it will select everything.











If you click in the formula, that is where the cursor will land.












Once you have clicked in the formula then you can’t click at the end to select all, you have to click somewhere outside that formula field and then go back and click past the end to select all.

You can click and hold down the left mouse button to select some or all of you formula.

You will notice that the keyboard shortcut ‘Ctrl’ + ‘A’ (select all) doesn’t work in the formula field. If the formula is really long, you can select in the formula field, hit the ‘Home’ button on your keyboard, then the ‘Shift’ + ‘End’ buttons together on the keyboard and you will select the entire formula.

Lastly if you want to get to the end of the formula quickly, you can pick in the formula field and the hit the ‘End’ button on your keyboard, this will move your cursor to the end of the formula.

No comments:

Post a Comment