| 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?
=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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total width of selected columns? | Excel Discussion (Misc queries) | |||
| Individual column width to represent stacked total | Excel Discussion (Misc queries) | |||
| 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
