Can anybody tell me which function is to be used to highlight cell's containing formula or vice versa ???
Thnx in advance !!
CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)
21 November 2008Can anybody tell me which function is to be used to highlight cell's containing formula or vice versa ???
Thnx in advance !!
NIKHIL
(STUDENT)
(45 Points)
Replied 21 November 2008
Originally posted by :CA Prakash Somani | ||
" | Can anybody tell me which function is to be used to highlight cell's containing formula or vice versa ??? Thnx in advance !! |
" |
By using the Ctrl+column(the key which is Above tab)
CA Subin VR
(Practicing CA)
(450 Points)
Replied 21 November 2008
just go to the cell u want to trace the formula; and press F2, you can see the formula.
RAKESH
(Almost CA)
(2199 Points)
Replied 21 November 2008
press F2 or Ctrl+graveaccent the key above the tab button .............
Roy P Joseph
(Sr. Accountant)
(24 Points)
Replied 21 November 2008
Here is the way to locate the entire cell in a worksheet containing Formula,
Formula
=GET.CELL(48,INDIRECT("rc",FALSE))
Click Add, and then OK.
=Formula
CA Annie
(Chartered Accountant )
(747 Points)
Replied 21 November 2008
U can record a macro to shade all the cells with formulas.
CA CS CIMA Prakash Somani
(Landmark Group)
(23502 Points)
Replied 24 November 2008
Thnx NIKHIL and thnx to all of u too. F2 function just show the formula but i wants to highlight cells containing formula and thats wht answered by Nikhil and rakesh.
One more thing even after "{CTRL+` (Grave accent)} i am not able to use filter command!!! please help..
Further thnx to Roy P Joseph for giving addition knowleadge.
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)