Is there a way to copy only column width?
The first step is to have a cell selected in the column that has the width you want to transfer. Copy that cell (Ctrl+C or click Edit on the menu bar and select Copy). Now select a cell in the column that needs the new width. Here you are looking to use Paste Special by clicking on Edit on the menu bar and select Paste Special. The Paste Special dialog box will appear on your screen, in the Paste section select Column Width and click OK. The width of the new column is altered without transferring any of the data or other formatting from the copied cell.
Related Questions
- When using the Copy All Reactants or Copy All Products option and pasting data into another application how can I align the columns of data with the column headings?
- How can I copy the contents of a single row or column in a table to a different location in the same table?
- How may I receive a copy of Mr. Graham’s recent My Answer column or submit a question to My Answer?