Excel Tip of the Day
Distinguish formula results from constant values (Excel 97/2000/2001/2002)
When working with a large spreadsheet, it's often useful to know which cells are formulas as opposed to values. Fortunately, you can avoid having to select cells to determine whether they contain formulas. All you need to do is give the formula cells unique formatting, such as a blue font color. It's easy to apply such formatting after you've set up your worksheet. First, choose Edit | Go To from the menu bar and click the Special button. Then, select the Formulas option button and click OK. Excel will highlight every formula in the active sheet. Now, simply select a unique color from the Font Color palette on the Formatting toolbar. Assuming you've otherwise used Excel's default colors, your worksheet will now show static values using black text and formula results with the color you previously selected.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.