Home |
Search |
Today's Posts |
#1
|
|||
|
|||
wanting to know width of several columns for copying
it is sometime required to copy width of several colums to the right. Is
there any way to do it in one step? Thanks |
#2
|
|||
|
|||
Sunantoro Wrote: it is sometime required to copy width of several colums to the right. Is there any way to do it in one step? Thanks Hi Sunantoro Try using the Format Painter (looks like a paint brush), hifghlight the columns that you want to copy the widths from, click on the Format Painter and then highlight the columns you want to copy the width to -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=398497 |
#3
|
|||
|
|||
If you're using xl2k or higher, you can copy column widths by selecting the
columns, then selecting the "to" range and edit|paste special and click on column widths. If you're using xl97, you can copy all the columns' formatting (including columnwidths) by copying the column, then selecting selecting the "to" range and edit|paste special|formats Sunantoro wrote: it is sometime required to copy width of several colums to the right. Is there any way to do it in one step? Thanks -- Dave Peterson |
#4
|
|||
|
|||
Thanks Dave, it works!
SUNAN "Dave Peterson" wrote: If you're using xl2k or higher, you can copy column widths by selecting the columns, then selecting the "to" range and edit|paste special and click on column widths. If you're using xl97, you can copy all the columns' formatting (including columnwidths) by copying the column, then selecting selecting the "to" range and edit|paste special|formats Sunantoro wrote: it is sometime required to copy width of several colums to the right. Is there any way to do it in one step? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i find total width of the columns in a printing area ? | Excel Discussion (Misc queries) | |||
columns change width | Excel Discussion (Misc queries) | |||
Different width of columns (series) in clustered charts | Charts and Charting in Excel | |||
How can i vary the width of columns in a histogram? | Excel Worksheet Functions | |||
Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel |