How to Copy and Paste in Excel and Keep Cell Size (7 Examples)

Sometimes we need to copy and paste in Excel and keep cell size. It saves a lot of time during work. Also makes the dataset more attractive. In this article, we are going to learn how to do that with some easy and quick examples with explanations.


Practice Workbook

Download the following workbook and exercise.


7 Examples to Copy and Paste in Excel and Keep Cell Size

1. Use Context Menu to Copy and Paste in Excel to Keep Cell Size

Context Menu is an important feature of Excel. It appears by the right-clicking of the mouse on a cell. Assume we have a dataset of a company. It contains information on employees’ Names, Duration of work & wage Amounts for Project 1 (B4:D7) The very same employees will work for Project 2 (B9:D12). So, we are going to copy the employees’ data from Project 1 and paste it to Project 2. We also keep the cell size the same.

Use Context Menu to Copy and Paste in Excel to Keep Cell Size

STEPS:

  • First, select rows 6 & 7.
  • Next, right-click on the mouse.
  • A context menu pops up. Select the option Copy from that.

Use Context Menu to Copy and Paste in Excel to Keep Cell Size

  • Now select row 11.
  • Again, right-click on the mouse.
  • Then from the context menu, select the Paste feature of the Paste Options.

  • After that, press the Esc key.
  • Finally, we will see the copy-paste data with the same cell size in both rows.

Read More: How to Copy a Cell in Excel Using Formula(7 Methods)


2. Copy and Paste Features to Keep Cell Size in Excel

Excel has simple copy and pastes features to keep the exact cell size. To demonstrate this method, we are using the same dataset of Method 1.

STEPS:

  • In the beginning, select rows 6 & 7.
  • Now press Ctrl + C keys. This will copy both rows. We can see the green border around them.

Copy and Paste Features to Keep Cell Size in Excel

  • Then, select row 11.

  • After that, press the Ctrl + V keys. This will paste the data we copied.
  • Finally, press the Esc key and we will see the result.

Read More: How to Copy and Paste Exact Formatting in Excel(Quick 6 Methods)


Similar Readings


3. Keep Cell Size Same in Multiple Spreadsheets

Suppose, we have the dataset of employees’ Names, Duration of work & wage Amounts for Project 1 (B4:D9). We are going to copy this spreadsheet information into another spreadsheet named ‘Sheet1’.

Keep Cell Size Same in Multiple Spreadsheets with Copy and Paste

STEPS:

  • Select the top left corner icon of the spreadsheet at first. This will select the entire spreadsheet.
  • Secondly, press the keyboard shortcut Ctrl + C to copy the data.

  • Thirdly, go to the required spreadsheet ‘Sheet1’.
  • Again, select the top left icon of that sheet.
  • After that, press Ctrl + V to paste the data.
  • Finally, we can see the required result and also keep the cell size.

Read More: How to Copy and Paste in Excel Without Changing the Format


4. Copy and Paste Excel Cell and Apply Format Painter to Keep Cell Size

Format Painter is used to copying one cell’s format to another. We can use this option to keep the cell size the same after the copy-paste. To apply this option, we are going to use the dataset of Method 1.

STEPS:

  • First, select the cell range B6:D7 which we want to copy.
  • After that, hit Ctrl + C keys together to copy the cells.

Copy and Paste Excel Cell and Apply Format Painter to Keep Cell Size

  • Then select Cell B11.
  • Now hit the Ctrl + V keys to paste the above cells’ information.

Copy and Paste Excel Cell and Apply Format Painter to Keep Cell Size

  • Again select rows 6 & 7.
  • Next, go to the Home tab and select the Format Painter option from the Clipboard section.

Copy and Paste Excel Cell and Apply Format Painter to Keep Cell Size

  • Here, we will see that the mouse cursor is converted into the Format Painter icon.
  • So, select row 11 at this moment.

  • After selecting, we can see that the size of rows 11 & 12 is the same as rows 6 & 7.

Read More: How to Copy Multiple Cells to Another Sheet in Excel (9 Methods)


Similar Readings


5. Excel ‘Paste Special’ Feature to Copy and Paste Exact Cell Size

Let’s assume that we have a dataset of the company’s employees’ names for two projects (Project 1 & Project 2). We see that the same employees are working. So we simply copy the cell range of Project 1 (B5:B8) and paste it to the cell range of Project 2. Now we will notice that the cell’s width size is not the same. To do that we are going to use the Paste Special feature.

Excel ‘Paste Special’ Feature to Copy and Paste Exact Cell Size

STEPS:

  • Firstly, select the cell range B4:B8.
  • Secondly, right-click on the mouse and select the Copy option from that pop-up menu.

Excel ‘Paste Special’ Feature to Copy and Paste Exact Cell Size

  • Thirdly, select Cell D4.
  • Again, right-click on it. A context menu pops up.
  • Now select the ‘Paste Special’ option from the Paste Special group.

  • This will open a Paste Special window.
  • Next, select the Column widths option from the Paste section.
  • After that, press OK.

  • Finally, we will see the width sizes are changed like its source.

Read More: How to Use Paste Special Command in Excel (5 Suitable Ways)


6. Use Home Tab to Copy and Paste in Excel and Keep Cell Size

We can find the Copy & Paste features in the Home tab of the Ribbon in Excel. Let’s see how to use them to keep the exact cell size. Here, we are going to use the same dataset of Method 1.

STEPS:

  • In the beginning, select rows 6 & 7.
  • Now, go to the Home tab.
  • Select the Copy drop-down from the Clipboard section.
  • Next, select the Copy option.

Use Home Tab to Copy and Paste in Excel and Keep Cell Size

  • Then again, select rows 11 & 12.
  • Likewise, in the previous steps, go to the Home tab.
  • After that, select the Paste option from the Clipboard group.

  • Finally, we will see the pasted result with the same cell size. Remember to press the Esc key from the keyboard.

Read More: How to Copy and Paste Multiple Cells in Excel (7 Quick Ways)


7. Keyboard Shortcut to Keep Cell Size Same

Excel has a keyboard shortcut to Copy a cell which is ‘Ctrl + C’. The shortcut to Paste a cell is ‘Ctrl + V’. But these will only copy-paste the cell value but not the cell size. To copy-paste in Excel and keep the cell size, we are going to use two shortcuts. Press Alt + H + C + C keys one by one to copy the required cell. Again, press Alt + H + V + P keys simultaneously to paste that cell value and keep the cell size.


Conclusion

By using these methods, we can easily copy and paste in Excel and keep cell size. There is a practice workbook added. Go ahead and give it a try. Feel free to ask anything or suggest any new methods.


Related Articles

Nuraida Kashmin

Nuraida Kashmin

Hi Everyone! I am Nuraida. Cordially welcome you to my profile. I am a Team Leader of Excel and VBA Content Developer in ExcelDemy. Here I will also post articles related to Microsoft Excel. With a strong educational background in Mechanical Engineering through experimental learning from Rajshahi University of Engineering & Technology. Skilled in Microsoft Word, Creative Writing, Microsoft Excel, Project Management, Support to Organize Different Events, Reporting, Monitoring & Documentation, Online Advocacy and Event Management Related to SAP and Youth Leaders.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo