Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |