Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a way to copy only column width?

column copy
0
Posted

Is there a way to copy only column width?

0

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

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123