Maintaining Names in References

[Gryphen957]

Good Morning Everyone,

I have a workbook with multiple sheets. One sheet, named "Exp", contains a table named "Expenses".
On a second sheet called "Income", I compile all the income and expenses.
I have entered formulas on the "Income" sheet like the following: SUM(Expenses[Payroll]), where "Expenses" is the table name, and "Payroll" is a column in the table.
My problem is that the formula automatically reverts to this: SUM(Exp!$K$2:$K$15)

Everything works fine, but the formulas are getting hard to read.

Is there anyway to keep the reference from reverting back to A1 style?

[jetted]

A quick solution would be to go in each formula and press F4, this will make your formula with absolute reference
hope it helps

[Gryphen957]

Aren't absolute references the ones with dollars signs like $A$1?
How would I use that with named references?

Also, I went to the formula, retyped it to include the named references, and pressed 'f4'. Nothing happened. Or at least nothing that I noticed. How is that supposed to work? If I hit 'f4' twice, does it toggle off?