How to Keep Gridlines When Copy and Paste in Excel (2 Ways)

Instead of writing the same thing again and again, we often use Copy and Paste command. It saves both time and hustle. In Microsoft Excel, we can copy the desired cells and paste it on the required location keeping the exact format. In this article, I am going to explain two very simple and efficient ways to Keep Gridlines in Excel when Copy and Paste.

For more explanation, I am going to use a dataset of personal information of a company decorated in the Employee ID, Name, Department, State, and Phone columns.

 How to Keep Gridlines in Excel When Copy and Paste


Download Practice Workbook


2 Simple Ways to Keep Gridlines When Copy and Paste in Excel

1.  Applying Normal Paste Method to Keep Gridlines

We can keep the gridlines in Excel when Copy and Paste just applying the normal Copy & Paste command.

Steps:

  • Select the cells that you want to paste keeping the gridlines. Here, I have selected cells C4:E14.
  • Then, go to the Home tab.
  • From the ribbon, click on Copy.

Alternatively, you can press CTRL + C to copy the cells.

  • Followingly, choose the cell where you want to Paste the cells.
  • Press CTRL + V to paste the selected cells with gridlines.

 How to Keep Gridlines in Excel When Copy and Paste

Thus, we can have the copied cells keeping gridlines.


2.  Using Excel Paste Special Method to Keep Gridlines

Paste Special has many different ways to paste the copied cells. In terms of keeping the gridlines issue, we can follow the following four ways. They are described in details in the following section.


2.1. Keep Source Formatting (K) Option

Using Keep Source Formatting (K) option is a way to keep gridlines while pasting the copied cells.

Steps:

  • Firstly, select the cells that you want to paste. Here, I have selected cells B4:D14.
  • Next, press on CTRL + C to copy the selected cells.

 How to Keep Gridlines in Excel When Copy and Paste

  • Choose the cell where you want to have the output. In my case, I chose cell C16.
  • Now, Right-Click on the mouse.
  • Click on the Paste Special extended functions button.
  • From the available options, pick Keep Source Formatting (K) option.

This is how we can have the copied cells keeping gridlines.

 How to Keep Gridlines in Excel When Copy and Paste


2.2. Keep Source Column Widths (W) Option

Another way is applying Keep Source Column Widths (W) option is a way to keep gridlines while pasting the copied cells.

Steps:

  • Select the cells that you want to paste keeping the gridlines. Here, I have selected cells B4:C16 and F4:F16 at a time to have them in adjacent columns.
  • .Then, copy the cells using Copy command.

  • Next, pick a cell where you want to have the output. In my case, I chose cell C18.
  • Right-Click on the mouse.
  • Then, click on the Paste Special extended functions button.
  • From the available options, choose the Keep Source Column Widths (W) option.

How to Keep Gridlines in Excel When Copy and Paste

We can have the copied cells with gridlines on the chosen location.


2.3.  Values & Source Formatting (E) Option

We can even use the Value & Source Formatting (E) option to keep gridlines while pasting the copied cells.

Steps:

  • First of all, you have to choose and select the cells that you want to paste keeping the gridlines. Here, I have selected cells B4:B16 and E4:F16 at a time to have them in adjacent columns.
  • .Input the Copy command to copy the cells.

 How to Keep Gridlines in Excel When Copy and Paste

  • Next, pick a cell where you want to have the output. In my case, I chose cell C17.
  • Now, Right-Click on the mouse.
  • Click on the Paste Special extended functions button.
  • Afterward, choose the Value & Source Formatting (E) option from the available options.

Thus, we can have the copied cells keeping gridlines.

 How to Keep Gridlines in Excel When Copy and Paste


2.4. Pasting as Picture (U)

If we can have the cells as image, we will have all the formatting in an exact way. For this, we can use Picture command from the Paste Special options.

Steps:

  • Select the cells that you want to paste. Here, I have selected cells B4:D16.
  • Next, press CTRL + C to copy the selected cells.

  • After that, select the cell where you want to have the output. Here, I chose cell C18.
  • Then, Right-Click on the mouse.
  • Click on the Paste Special extended functions button.
  • Choose the Picture command from the Paste Special options.

 How to Keep Gridlines in Excel When Copy and Paste

This is how we can have the copied cells keeping gridlines.


Things to Remember

At the time of using the Keep Source Column Widths (W) option & Picture command from the Paste Special options, we can have the exact format keeping the gridlines. But in case of applying the normal Copy & Paste command,  Keep Source Formatting (K) option, and Value & Source Formatting (E) option to paste the cells keeping gridlines, we won’t be able to have the exact same cell width as the copied cell. This time, the copied cells will be in the exact cell width with related to the cell where we are moving the copied cells.


Practice Section

For more expertise, you can practice here.

 How to Keep Gridlines in Excel When Copy and Paste


Conclusion

That’s all for the article. In this article, I have tried to explain two very simple and efficient ways to Keep Gridlines in Excel when Copy and Paste. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo