hit F2, want the color coded formula to appear in formula bar not
 

At my previous job when I hit F2 a color coded formula appeared in my formula
bar. Each cell reference is a different colr in the formula and the actual
cells in the worksheet are outlined in its corresponing color. Now at my new
job, the color coded formula appears in the cell. I don't like this
especially because the long formulas usually cover up the what's in adjacent
cells. Is there a a way to switch it back to formula bar display only?

hit F2, want the color coded formula to appear in formula bar not
 

ToolsOptionsEdit tab, uncheck Edit directly in cell

--
Kind regards,

Niek Otten

"Tiff L" <Tiff wrote in message ...
At my previous job when I hit F2 a color coded formula appeared in my formula
bar. Each cell reference is a different colr in the formula and the actual
cells in the worksheet are outlined in its corresponing color. Now at my new
job, the color coded formula appears in the cell. I don't like this
especially because the long formulas usually cover up the what's in adjacent
cells. Is there a a way to switch it back to formula bar display only?