• 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
55
346 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
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.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
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
Products
  • 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
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
  • Microsoft Visio Standard 2016 Key 1PC Microsoft Visio Standard 2016 Key 1PC $9.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail Key Global - 5 PC
    Rated 4.96 out of 5
    $15.00
  • Windows Server 2019 Standard Key Global Windows Server 2019 Standard Key Global
    Rated 4.68 out of 5
    $7.00
  • Windows 10 Enterprise LTSC 2019 Key Global Windows 10 Enterprise LTSC 2019 Key Global
    Rated 4.83 out of 5
    $9.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.