Precedent Cell

V

vishu

Hi,
I have SUM formula in one of the cell.
For Example I have a formula in cell# A1. And the formula is
A52+A54+A84+A95+A96+B101+B105+C96+D201 etc.,

by holding the F2 button in cell#A1 I can see all precedents of this cell. I
wanted to fill the colours in these cells by holidng F2 Button. but its not
allowing me to fill the colours in these cells.
Is there any other way i can fill the colour by holding F2 buttons or any
other shortcuts in Excel 2007
 
L

Luke M

Ctrl+[ will select all direct precendent cells, Shift+Ctrl+[ will select all
precedents. Color fill as desired.
 

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

How To Have A Cell Be Blank If... 2
How to reference to a column of data? 4
tracing precedent by double clicking cell 3
CALCULATION OF A CELL THAT CONTAINS A FORMULA 5
Excel Named Ranges and Conditional Format 3
incremental averaging of data 1
Double clicking formula cell doesn't highlight precedent cells 0
sum number of columns based on variable value 4

Top