• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
Excel

How to copy an Excel data table without hidden rows and columns.

0 Comments

With a data table that has some rows and columns hidden, when copying to a new data table, Excel by default copies and displays all hidden rows and columns. This requires you to hide the rows and columns again. So how do you copy an Excel data table without hidden rows and columns? Let’s refer to the article below on Buffcom.net.

Assuming we have the full data table below.

Cách sao chép bảng dữ liệu Excel không ẩn hàng, cột

Cách sao chép bảng dữ liệu Excel không ẩn hàng, cột

And here is the data table after hiding columns A and C. If copied in the usual way, these two columns will still appear in the new Excel file. To copy without showing the hidden columns A and C, do the following:

Cách sao chép bảng dữ liệu Excel không ẩn hàng, cột

Cách sao chép bảng dữ liệu Excel không ẩn hàng, cột

Step 1: Open the Go To dialog box

First, select the entire data table. On the toolbar, go to the Home tab, choose Find & Select, and then select Go To… from the drop-down list.

How to copy an Excel data table without hidden rows and columns2

How to copy an Excel data table without hidden rows and columns2

Step 2: Open the Go To Special dialog box

When the Go To dialog box appears, select Special at the bottom.

How to copy an Excel data table without hidden rows and columns 3

How to copy an Excel data table without hidden rows and columns 3

In the Go To Special dialog box, tick the Visible cells only option. Then click OK to save. Now you have set up the feature to only copy the visible rows and columns.

How to copy an Excel data table without hidden rows and columns 4

How to copy an Excel data table without hidden rows and columns 4

Step 3: Copy the data

Proceed to copy the data as usual (select the data table, press Ctrl + C to copy, and Ctrl + V to paste). The result is that the hidden columns will not appear in the new Excel file, and Excel will automatically reorder the remaining columns.

How to copy an Excel data table without hidden rows and columns 5

How to copy an Excel data table without hidden rows and columns 5

Above is the guide on how to copy an Excel data table without hidden rows and columns. We hope you find it helpful and can apply it successfully. Good luck!

Rate this post
59
359 Views
10 ways to open Disk Defragmenter on WindowsPrev10 ways to open Disk Defragmenter on WindowsFebruary 16, 2023
Inserting Images into Word, Editing and Compressing Images...February 17, 2023Inserting Images into Word, Editing and Compressing Images...Next

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
Products
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.