Manually everything can be done in Excel, but the thing is nobody has as much time to spend on executing such tiring functions. Adjusting the column width in Excel is not a big thing, however, when you don’t know the exact procedure you must be in trouble.
Here you will get to know about hacks that let you understand how to copy column width in Excel effortlessly. Whenever you copy a cell and paste it somewhere else, you notice that the content along with the formatting is pasted. Here we need to copy the width of a cell and that’s what we’ll figure out.
How to Copy Column Width in Excel with Context Menu?
With the help of context menu options, you can copy and paste the column width easily. For this, we have some easy steps for you to follow:
- Choose the dataset you need to copy.
- To copy the dataset, press CTRL + C or else right-click and choose Copy option.
- Right-click on the targeted cell in which you need to paste data.
- Place the cursor on the icon on the right side of the Paste Special option. You will find some additional options as well.
- Choose the Keep Source Column Width(s) option.
All set!
By following the above steps, you can easily copy and paste the data along with the column widths.
How to Copy Column Width in Excel with Paste Special?
In our next example, we have a dataset containing the sales values of different stores. Let’s consider you need to copy and paste the data into another sheet.
In that case, you can copy and paste the values as well as the formatting. However, it will not copy the column width. When you have a small dataset, you can do it easily however, adjusting the column width manually with a large dataset would be a time-consuming thing.
For this, you can follow the steps given below to copy and paste the column width with the help of Paste Special:
- Choose the cells you need to copy.
- To copy the selected cells, press CTRL + C or else right-click on the selected cells.
- Click on Copy option.
- Choose the targeted cell in which you need to paste the copied cells.
- Right-click and choose the paste option or else you can press CTRL + V.
- Right-click once again and choose Paste Special.
- Choose the Column widths option from the Paste Special dialog box.
- Press OK.
By following the above steps, you can copy and paste the data along with the column width.
How to Copy Column Width in Excel with Shortcut?
You can follow the below-given keyboard shortcuts to copy and paste the column width in Excel:
ALT + E + S + W + ENTER
Below are some simple steps to follow:
- Copy the cells from which you need to copy and paste the column width.
- Choose the targeted cell.
- Press ALT + E + S + W + ENTER keys all one after the other.
- With the above shortcut key combination, the Paste Special dialog box will open up. Choose the Column Widths option from the dialog box and then paste it.
Summary
Today, you have learned how to copy column width in Excel by using more than one hack. Each method is effectively functional that’s why you can choose any of the above methods without hesitation. Keep practicing the Excel hacks and you will learn to succeed.
