LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Referencing help

Im trying to determine a way that I can see all of the cells that reference
another cell. Similar to F2, in that it shows all of the cell which are
components to a cell's function, however, in "reverse" of sorts.... For
instance, cell B2, C2 and C3 all reference cell A1 in their functions. I
want to click on A1 and see then be pointed to the refering 3 cells.

Essentially, im want to change some values for some components of a sheet,
however, Im concerned that I dont know all of the other cells which rely on
those values and want to be able to locate and double check them all.

Help me. Please.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing Help Teedie Excel Discussion (Misc queries) 3 July 3rd 08 08:41 AM
referencing a different tab by referencing a list in the current s Kevin Excel Worksheet Functions 3 July 6th 07 07:57 PM
referencing Richard[_2_] Excel Worksheet Functions 2 March 30th 07 01:50 AM
Help with referencing please Matt New Users to Excel 18 September 11th 06 10:15 AM
Referencing Delaina Excel Discussion (Misc queries) 4 June 23rd 05 11:06 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"