ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   absolute reference (https://www.excelbanter.com/excel-discussion-misc-queries/15073-absolute-reference.html)

Dano

absolute reference
 
When I am typing a formula, is there a fast way to designate an absolute
reference? I keep having to go back and put in the "$" sign, which takes a
lot of time. Thanks.

Don Guillett

If you go back to put in the $ try highlighting the range to change and
touching the f4 key.

--
Don Guillett
SalesAid Software

"Dano" wrote in message
...
When I am typing a formula, is there a fast way to designate an absolute
reference? I keep having to go back and put in the "$" sign, which takes a
lot of time. Thanks.





All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com