+ Reply to Thread
Results 1 to 3 of 3

Way to know if one cell is used in formulas across sheet?

  1. #1
    Registered User
    Join Date
    09-02-2019
    Location
    UK
    MS-Off Ver
    2018
    Posts
    2

    Way to know if one cell is used in formulas across sheet?

    Hello everyone,

    I have had one big question regarding Excel for years, and I just signed up here to finally get to ask knowledgeable people about it.

    When you write a formula in a cell, Excel displays the other cells used to write the formula by means of different colors.
    But is it possible to do the opposite? When selecting one cell (say A1), is there a way for Excel to display all the other cells across the sheet that contain formulas written with A1?


    That way if you're about to delete a cell somewhere in your spreadsheet, you can check first that doing it won't affect other cells somewhere else.

    Thank you in advance for your help, have a nice one.

    Pierre
    Last edited by Pierre44; 09-02-2019 at 06:30 PM.

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Way to know if one cell is used in formulas across sheet?

    Select the cell (A1 for your example), then click the "Trace Dependents" button ("Formulas" tab, "Formula Auditing" group on the Ribbon).
    Last edited by Rick Rothstein; 09-02-2019 at 06:35 PM.

  3. #3
    Registered User
    Join Date
    09-02-2019
    Location
    UK
    MS-Off Ver
    2018
    Posts
    2

    Re: Way to know if one cell is used in formulas across sheet?

    You sir are wonderful.
    Thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A loop to activate the formulas (double click) in each and every cell on the sheet
    By BenRonen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2019, 08:38 AM
  2. Replies: 1
    Last Post: 02-09-2014, 05:49 PM
  3. Replies: 4
    Last Post: 06-11-2013, 09:50 AM
  4. Need formula to count cell containing formulas in the other sheet
    By mayurpatil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2012, 04:30 AM
  5. [SOLVED] Copy formulas from one spreadsheet to another keeping the original sheet cell reference
    By Sheepdog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2012, 02:41 PM
  6. Change file path in formulas for every cell in a sheet
    By jackthefork in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2009, 12:22 PM
  7. Cell value as Sheet name reference in formulas
    By bobboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2007, 12:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1