| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total width of selected columns?
Columns("A:C").Width returns the value in points
-- __________________________________ HTH Bob "sarah" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total width of selected columns?
Also, from your sheet you can enter the following formula
=Cell("width",A1)+Cell("width",b1)+Cell("width",c1 ) "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Individual column width to represent stacked total | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| Pivot Table - Grand Total for selected columns only | Excel Discussion (Misc queries) | |||
| Total width of several columns. | Excel Worksheet Functions | |||
| how can i find total width of the columns in a printing area ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
