How to fix the cell values (Absolute Reference). of whole tableby once.

@Chaturvedi, Santosh

If all of the cells in column B refer to a cell in column E, select the entire range with the relative references. Press Ctr-H (Find and Replace).

Type E in in the "Find what:" box and $E$ in the "Replace with:" box. Then Replace All. Done.

If not all references are to column E, repeat this process for each column that does get referenced in column B.

Good day,

Thank you for your question.

Unfortunately, Excel does not provide a built-in method to apply absolute references ($) to all formulas in a selected table or range with a single F4 keystroke. The F4 shortcut only works on the cell reference currently being edited in the formula bar or in-cell edit mode, so it cannot automatically convert every formula within a selected range to absolute references at once.

Based on the screenshot provided, if your intention is for all cells to reference the same fixed cell (for example, E1664), you can:

1. Edit the first formula and change it to:

      =$E$1664
   

2. Press Enter.
3. Copy or fill the formula across the required range.

All copied formulas will continue to reference the fixed cell $E$1664.

Please note that this approach is suitable only when every formula should refer to the same cell. If the table contains different cell references that all need to be converted to absolute references, Excel currently does not offer a one-click feature to perform this action across an entire selected range.

Submit feedback to Microsoft:

I appreciate you bringing up this suggestion. The ability to convert all references in a selected range to absolute references in a single action would be a useful enhancement and could save significant time when working with large tables.

As a forum user, I hope you understand that I don’t have the ability to modify or escalate product issues directly. However, I strongly recommend submitting your feedback through the Microsoft 365 Feedback Hub > Send Feedback > Describe your proposal in detail. This is the most effective way to ensure your voice reaches the product team and can be considered about how company-only contacts are handled in search results, with potential improvements being considered  for future improvements.        

Once you’ve submitted your feedback, feel free to share the link here. I’d be happy to upvote it to help increase its visibility. 

Additionally, as other users have raised similar concerns and may not be aware of where to share their feedback, I hope this response helps clarify the situation and suggests a potential next step. Highlighting this information can make it more visible to others in the community who may be facing the same issue, making it easier for them to find guidance and contribute their feedback as well.       

Thank you again for your time and for raising this important usability concern. If you have any further questions or need additional assistance, please don’t hesitate to reach out.       

Wishing you a smooth rest of your day.    

If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.