Skip to playerSkip to main content
Learn how to retain the original column with when copy pasting in Excel.

At the end of the video, you should be able to answer the following questions.
- Can you correct column widths when pasting copied data in Excel?
- How do I duplicate column width in Excel?
- How do you duplicate column widths?
- How do you retain column and row width when copying and pasting from Excel?
- How do you retain the original column widths when copy pasting?
- How do you fix the data you're pasting isn't the same size?
- How do you fix the data you're pasting isn't the same size?
- How to paste copied cells so formulas formatting and source cell widths are pasted?
- How do I paste and keep original formatting?
- Can I have different cell widths in the same column in Excel?


Here are the steps outlined in the video.

Copy Column Width
1) Place cursor to cell A1
2) Home ~ Clipboard ~ Paste
3) Paste Special
4) Column widths
5) OK
6) Ctrl + V


Can you correct column widths when pasting copied data in Excel?,
How do I duplicate column width in Excel?,
How do you duplicate column widths?,
How do you retain column and row width when copying and pasting from Excel?,
How do you retain the original column widths when copy pasting?,
How do you fix the data you're pasting isn't the same size?,
How do you fix the data you're pasting isn't the same size?,
How to paste copied cells so formulas formatting and source cell widths are pasted?,
How do I paste and keep original formatting?,
Can I have different cell widths in the same column in Excel?,
Copy Column Widths in Paste Special,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning
Transcript
00:00if you have to copy the whole table which is already formatted in terms of width you ctrl c
00:05copy in a clipboard move to the next sheet and if you hit paste you can see that the width is not
00:09copied so all you have to do over here will be to do this kind of things let me show you another way
00:14which is more efficient in terms of copying and pasting go back to your original sheet here and
00:19select the whole data sheet ctrl c to copy in a clipboard go to your new sheet and before you
00:24paste you go home clipboard paste and then you go special paste and you're going to say column width
00:29and click ok and that copies all your column width and then ctrl v to paste it and you're done
Comments

Recommended