If you want to identify formula cells in a permanent way, you'll need to do so manually, or you can use VBA. Using VBA Using the Special option works, but it's temporary - it's a quick way to get a quick look. Click OK and Excel selects cells that contain formulas.By default, this option selects all formula cells in the current sheet, but you can be more selective by excluding specific suboptions: Number, Text, Logical, and Errors. Doing so actually selects the cells, so it's temporary. Using Pressing is the easiest way to identify formula cells. Fortunately, there are two quick ways to find formula cells: and VBA. You might be working in a legacy workbook that you didn't design or perhaps the sheet contains a lot of data. That's a nice thought, but it's not terribly practical. If you practice good spreadsheet design, formulas shouldn't be hard to find.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |