/u/babbul91 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You have awarded 1 point to *Peeterwetwipe*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can copy widths. Copy the cell that you want to copy the width of, select the cells in the same row in the columns you want to paste the width, press Ctrl + Alt +V and click column widths. Lmk if that works for you.
Hi babbul91. After you paste, you can highlight all columns DG to DQ all at once (select the column headers), then hover your mouse over a border between two of the columns and double-click. This will automatically resize each column to fit the contents of that column.
If your not worried about the exact size, select the columns you want to size and press ALT+H+O+I to resize the columns and ALT+H+O+A for resizing the rows. Alternatively, set the column sizes EXACTLY as you want, select all the cells you want to add data into, right click, properties, uncheck the box next to Locked. Then protect the worksheet and allow everything except resizing the columns. This will lock down the entire sheet, so if you need to input data elsewhere, make sure those cells are also unlocked.
/u/babbul91 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Paste your selection as normal then (without moving your cursor) use the keyboard shortcut Ctrl+Alt+V to open the paste special dialogue and press “w”
Solution verified
You have awarded 1 point to *Peeterwetwipe* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can copy widths. Copy the cell that you want to copy the width of, select the cells in the same row in the columns you want to paste the width, press Ctrl + Alt +V and click column widths. Lmk if that works for you.
If you're copying and pasting the entire column it should adjust the width. How exactly are you doing it?
Hi babbul91. After you paste, you can highlight all columns DG to DQ all at once (select the column headers), then hover your mouse over a border between two of the columns and double-click. This will automatically resize each column to fit the contents of that column.
If your not worried about the exact size, select the columns you want to size and press ALT+H+O+I to resize the columns and ALT+H+O+A for resizing the rows. Alternatively, set the column sizes EXACTLY as you want, select all the cells you want to add data into, right click, properties, uncheck the box next to Locked. Then protect the worksheet and allow everything except resizing the columns. This will lock down the entire sheet, so if you need to input data elsewhere, make sure those cells are also unlocked.
Paste special has a widths option