Fixe Range

  • Thread starter Thread starter Guest
  • Start date Start date
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

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting on a dynamic range - workaround 1
Help With MS Access 4
Replace a fixed number with a variable via popup 3
Can Vba workout if a selection is part of a group? 0
Stop Macro running when I save the workbook 1
Excel Msgbox runing beyond posted cell range. 1
Select a range not equal to: 4
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Back
Top