ExcelBanter - Is there an absolute reference shortcut?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there an absolute reference shortcut? (https://www.excelbanter.com/excel-discussion-misc-queries/148156-there-absolute-reference-shortcut.html)

mattgoof2005

Is there an absolute reference shortcut?

Is there a key I can hold down so that when clicking on cells for a formula,
it makes it an absolute reference? I'm using mixed references, so I don't
want to switch the default.

Jim Thomlinson

Is there an absolute reference shortcut?

Try the F4 key to toggle referencing...
--
HTH...

Jim Thomlinson

"mattgoof2005" wrote:

Is there a key I can hold down so that when clicking on cells for a formula,
it makes it an absolute reference? I'm using mixed references, so I don't
want to switch the default.

mattgoof2005

Is there an absolute reference shortcut?

Thanks

"Jim Thomlinson" wrote:

Try the F4 key to toggle referencing...
--
HTH...

Jim Thomlinson

"mattgoof2005" wrote:

Is there a key I can hold down so that when clicking on cells for a formula,
it makes it an absolute reference? I'm using mixed references, so I don't
want to switch the default.

All times are GMT +1. The time now is 03:18 PM.