How to display row height or column width in cells?
In some cases, you may want to know the height of each row or the width of each column in your worksheet. Are you still use the Row Height or Column Width to check the row height or column width one cell by one cell? Today, I will introduce some tricks for you to deal with this task quickly.
Display each row height in cells with Define Name
Display each row height in cells with User Defined Function
Display each column width in cells with User Defined Function
Display each row height in cells with Define Name
In Excel, we can create a range name, and then apply its corresponding formula. Please do with following steps:
1. Activate your worksheet which you want to get the row height and column width.
2. Click Formulas > Define Name, see screenshot:
3. Then in the New Name dialog box, enter your define name into the Name text box, and then type this formula =get.cell(17,a1) into the Refers to box, see screenshot:
4. And then click OK button to close this dialog, now in a blank cell, please enter this formula =rowheight, see screenshot:
5. Then drag the fill handle down to the range cells which you want to get the row height, and each row height has been filled into your cells.
Display each row height in cells with User Defined Function
If you are interesting in code, you can also create a User Defined Function to get the row height of each row.
1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following macro in the Module Window.
VBA code: display each row height in cells
Function RowHeight(MR As Range) As Double
Application.Volatile
RowHeight = MR.RowHeight
End Function
3. Then save and close this code, return to your worksheet, and enter this formula =RowHeight(A1) into any blank cell of first row, then drag the fill handle down to the range cells which you want to display the row height of each row.
Display each column width in cells with User Defined Function
To get the column width of each column, you can also use a User Defined Function.
1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following macro in the Module Window.
VBA code: display each column width in cells
Function ColumnWidth(MR As Range) As Double
Application.Volatile
ColumnWidth = MR.ColumnWidth
End Function
3. Then save and close this code, return to your worksheet, and enter this formula =ColumnWidth(A1) into any blank cell of first column, then drag the fill handle right to the range cells which you want to display the column width of each column, and you will get the relative column width in the cell. See screenshots:
 |
 |
 |
Related article:
How to change the row height / column width alternated in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!