ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Total width of selected columns? (https://www.excelbanter.com/excel-discussion-misc-queries/220032-total-width-selected-columns.html)

Sarah

Total width of selected columns?
 
Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column C?
In pixels or inches.

Would this also apply to rows?

Thank you.

HAS

Total width of selected columns?
 
=CELL("width";D1)+CELL("width";E1)+CELL("width";F1 )

hosam

"sarah" wrote:

Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column C?
In pixels or inches.

Would this also apply to rows?

Thank you.


John[_22_]

Total width of selected columns?
 
Hi
You may need to change the semi-colon to commas if you're in North America
e.g. =CELL("width",D1)+CELL("width",E1)+CELL("width",F1 )
HTH
John

"HAS" wrote in message
...
=CELL("width";D1)+CELL("width";E1)+CELL("width";F1 )

hosam

"sarah" wrote:

Hello, how might I calculate the total width of selected columns?

For example the width of column A + width of column B + width of column
C?
In pixels or inches.

Would this also apply to rows?

Thank you.




All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com