ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Fixe Range (https://www.excelbanter.com/excel-worksheet-functions/147249-fixe-range.html)

John

Fixe Range
 
How Can I select a rang and change into a $A$?

Regards,

Bob Phillips

Fixe Range
 
after selecting hit F4, it will toggle through the alternatives.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"John" wrote in message
...
How Can I select a rang and change into a $A$?

Regards,




Gord Dibben

Fixe Range
 
John

Select the cell reference in the formula bar and hit F4 to cycle through the
options.


Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 07:50:01 -0700, John wrote:

How Can I select a rang and change into a $A$?

Regards,




All times are GMT +1. The time now is 01:59 AM.

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