• 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
341 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 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.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 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
Products
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Windows Server 2019 Essentials Key Global Windows Server 2019 Essentials Key Global
    Rated 4.71 out of 5
    $7.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • office-professional-2016-international Microsoft Office Professional Plus 2016 Retail CD Key
    Rated 4.92 out of 5
    $13.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Windows Server 2016 Essentials Key Global Windows Server 2016 Essentials Key Global
    Rated 4.79 out of 5
    $10.00
  • 5 Key Windows 10 Pro Key Global - Combo 5 KEY 5 Key Windows 10 Pro Key Global - Combo 5 KEY
    Rated 4.81 out of 5
    $25.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
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.75 out of 5
    $20.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.