Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy multiple column widths from a worksheet in one work.
how do I copy multiple column widths from a worksheet in one workbook to one
in another workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy multiple column widths from a worksheet in one work.
Hi Lockport
Ctrl A to select all cells or select a few columns Ctrl c to copy Go to the other workbook Edit Paste Special in the menu bar Choose columnwidth -- Regards Ron de Bruin http://www.rondebruin.nl "Lockport" wrote in message ... how do I copy multiple column widths from a worksheet in one workbook to one in another workbook? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy multiple column widths from a worksheet in one work.
Say the formats you want are in column ABC. Highlight ABC in the workbook. Hit copy. Go to the oher work book highlight ABC hit paste special. Then click format. -- Gbonda ------------------------------------------------------------------------ Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758 View this thread: http://www.excelforum.com/showthread...hreadid=567620 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet with row & column references | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How do I edit a worksheet and copy to multiple files? | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) |