Hi to all
How can I find the sum of several rows heights in excel in centimeters?
Example:
If I have a range B14:Q29 with different rows heights. How many centimeters is the total of these 16 rows?
Khalil
Hi to all
How can I find the sum of several rows heights in excel in centimeters?
Example:
If I have a range B14:Q29 with different rows heights. How many centimeters is the total of these 16 rows?
Khalil
Last edited by Khalil Handal; 01-12-2024 at 06:02 AM. Reason: to make it more clear
Row height is measured in pixels. You cannot measure this in centimetres because every printer will render the data slightly differently depending on the paper being printed to and the printer driver settings.
There is no way that I know of to find out automatically the number of pixels in height a group of rows is. It might be possible with VBA.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You can show a ruler in page layout view, which might help.
Select the View tab of the ribbon and in the Workbook Views group choose Page Layout. Then in the Show group, tick the box next to Ruler
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks