Turning a Range into an Absolute Reference
Key points
- Enter the range
- See the form
- Copy it
Excel Range Size also shows the range as an absolute reference with dollar signs.
Steps
- Enter the range
- See the form
- Copy it
You can use it directly as the range in VLOOKUP and the like.
Use "Count Cells, Rows and Columns in an Excel Range" (free)
Tools that go well with this
- Excel Column Number and Letter Converter: Convert Excel column numbers and letters.
- Excel Serial Number and Date Converter: Convert Excel serial numbers and dates.
- Excel Table to Markdown, HTML, CSV and JSON: Convert a pasted table to Markdown, HTML, CSV or JSON.