| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display col width in a cell
Hi Paul
Many thks, works perfect. My suggest doesn't give the decimals. it rounds up. Rgds KZ Kieranz wrote: Hi All I got it, from UG. In each cell in the first row put =CELL("width",A1) and copy across. Thks. Rgds KZ Kieranz wrote: Hi All I would like to set a formula in each of the relevant cells in Row 1 to display the column width (30 of them of different widths). Any ideas would help. Rgds KZ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| How can I control the full screen display width ? | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| How can I restrict cell data display to column width? | Excel Discussion (Misc queries) | |||
| Shortcut key to display change the display from displaying cell values to cell formulae | Excel Programming | |||
![Kieranz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
