SOLVED

Move cursor within Edit Formatting Rule

%3CLINGO-SUB%20id%3D%22lingo-sub-1565442%22%20slang%3D%22en-US%22%3EMove%20cursor%20within%20Edit%20Formatting%20Rule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565442%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20apologies%20if%20my%20attempt%20to%20search%20for%20an%20answer%20was%20using%20the%20wrong%20key%20words%2C%20as%20it%20seems%20an%20obvious%20question%20to%20have%20been%20answered%20before.%26nbsp%3B%20I%20am%20trying%20to%20edit%20a%20Conditional%20Format%20which%20uses%20a%20formula%20(Edit%20Formatting%20Rule%20-%20Use%20a%20formula%20to%20determine%20which%20cells%20to%20format%20%26gt%3B%20Edit%20the%20Rule%20Description%20%26gt%3B%20Format%20values%20where%20this%20formula%20is%20true).%3C%2FP%3E%3CP%3EI%20can%20use%20my%20mouse%20to%20insert%20the%20cursor%20at%20a%20point%20in%20the%20formula%2C%20but%20how%20do%20I%20move%20the%20cursor%20WITHOUT%20IT%20INSERTING%20THE%20CELL%20REFERENCE%3F%3C%2FP%3E%3CP%3EI%20know%20it%20must%20be%20possible%2C%20as%20I%20have%20inadvertently%20achieved%20it%2C%20I%20think%20by%20perhaps%20highlighting%20and%20deleting%20a%20word%20before%20moving%20the%20cursor.%26nbsp%3B%20What%20I%20(anyone%3F)%20needs%20to%20do%2C%20is%20switch%20between%20moving%20the%20cursor%2C%20and%20choosing%20to%20insert%20a%20cell%20reference.%26nbsp%3B%20If%20I%20can't%20switch%20between%20the%20two%20modes%2C%20I%20would%20much%20rather%20move%20my%20cursor%20in%20preference%2C%20and%20I%20will%20manually%20insert%20the%20cell%20references.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1565442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565460%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20cursor%20within%20Edit%20Formatting%20Rule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749191%22%20target%3D%22_blank%22%3E%40ChrizK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20edit%20the%20formula%20and%20use%20arrow%20keys%20please%20press%20F2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1567350%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20cursor%20within%20Edit%20Formatting%20Rule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567350%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3ESuch%20a%20simple%20answer!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E....Why%20don't%20MS%20include%20it%20in%20the%20Edit%20box%20description%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20remind%20anyone%20who%20has%20a%20'condensed%20keyboard%20layout'%20(as%20most%20laptops%20do%20these%20days)%2C%20you%20may%20need%20to%20press%20Fn%2BF2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1567641%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20cursor%20within%20Edit%20Formatting%20Rule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749191%22%20target%3D%22_blank%22%3E%40ChrizK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20box%20was%20developed%20ages%20ago%2C%20perhaps%20to%20touch%20it%20means%20a%20lot%20of%20work%20and%20that%20is%20not%20a%20first%20priority.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi, I apologies if my attempt to search for an answer was using the wrong key words, as it seems an obvious question to have been answered before.  I am trying to edit a Conditional Format which uses a formula (Edit Formatting Rule - Use a formula to determine which cells to format > Edit the Rule Description > Format values where this formula is true).

I can use my mouse to insert the cursor at a point in the formula, but how do I move the cursor WITHOUT IT INSERTING THE CELL REFERENCE?

I know it must be possible, as I have inadvertently achieved it, I think by perhaps highlighting and deleting a word before moving the cursor.  What I (anyone?) needs to do, is switch between moving the cursor, and choosing to insert a cell reference.  If I can't switch between the two modes, I would much rather move my cursor in preference, and I will manually insert the cell references.

3 Replies
Highlighted
Best Response confirmed by ChrizK (Occasional Contributor)
Solution

@ChrizK 

If edit the formula and use arrow keys please press F2

Highlighted

Thank you so much @Sergei Baklan ,

Such a simple answer!

 

....Why don't MS include it in the Edit box description

 

To remind anyone who has a 'condensed keyboard layout' (as most laptops do these days), you may need to press Fn+F2

Highlighted

@ChrizK 

This box was developed ages ago, perhaps to touch it means a lot of work and that is not a first priority.