How Can I select a rang and change into a $A$? Regards,
B Bob Phillips Jun 20, 2007 #2 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)
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)
G Gord Dibben Jun 20, 2007 #3 John Select the cell reference in the formula bar and hit F4 to cycle through the options. Gord Dibben MS Excel MVP
John Select the cell reference in the formula bar and hit F4 to cycle through the options. Gord Dibben MS Excel MVP
