F2 key

T

The_Hog

Hi, I use the F2 key a lot. Pressing it gives you a very good coloured
overview of what a calculation is doing. Now I often have data in one sheet
and open another sheet for processing the data. Pressing F2 in the
processing sheet DOES NOT give you colour indications for fields your'e using
in the other sheet (data sheet). Is there a way to have F2 give you this
information in another sheet?
 
C

Chip Pearson

As far as I know, the color coding (a very nice feature indeed) works only
for ranges on the same sheet as the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel cells changing to "#VALUE!" whenever another file is opened 8
Dealing with the error: unable to filter on excel hc home school 0
F2 key nonfunctioning 3
Time Sheet - Calculating Time Differences for Totals 3
Bugs in Office 2019 0
Macro 3
Inserting worksheet makes formulae stop working 5
Coloured Cells 8

Top