• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
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
350 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
  • 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
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • office-professional-2016-international Microsoft Office Professional Plus 2016 Retail CD Key
    Rated 4.92 out of 5
    $13.00
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Windows 10 Pro OEM Key Global - Reinstalling win is still active Windows 10 Pro OEM Key Global - Reinstalling win is still active
    Rated 4.88 out of 5
    $6.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • Microsoft Visio Standard 2016 Key 1PC Microsoft Visio Standard 2016 Key 1PC $9.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.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.