| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Precedent Cell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Precedent Cell
Ctrl+[ will select all direct precendent cells, Shift+Ctrl+[ will select all
precedents. Color fill as desired. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "vishu" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Precedent lines | Excel Worksheet Functions | |||
| Double clicking formula cell doesn't highlight precedent cells | Setting up and Configuration of Excel | |||
| tracing precedent by double clicking cell | Excel Discussion (Misc queries) | |||
| precedent | Excel Discussion (Misc queries) | |||
| How do I "CTRL [" (jump to a precedent cell) from a European keybo | Excel Discussion (Misc queries) | |||
Linear Mode
