Let’s say cell C1 is part of the formula that’s in A7, as shown below. This coloring will be true of the formula itself that you see within the cell and true of the border of the actual cells being referenced. Assuming there aren’t too many cells, each border color will be different. ![]() When you double-click or hit F2, you’ll see each cell in the formula surrounded by a colored border (as shown in the animation above and the graphic below). Get A Visual On Formula References (enter “Edit mode”) (mouse): double-click – on the formula cell Get A Visual On Formula References (enter “Edit mode”) (keyboard): F2 – on the formula cell It also quickly positions you to edit the formula (faster than using the formula bar). These methods give you a “visual” on your formulas, highlighting each cell that’s in the formula. ![]() Have you ever had a formula that references so many cells that you can’t keep it all straight? Well, there are two easy ways to make it much easier. ![]() How to use F2 and double-clicking to edit Excel formulas
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |