The Tech Edvocate

Top Menu

  • Advertisement
  • Apps
  • Home Page
  • Home Page Five (No Sidebar)
  • Home Page Four
  • Home Page Three
  • Home Page Two
  • Home Tech2
  • Icons [No Sidebar]
  • Left Sidbear Page
  • Lynch Educational Consulting
  • My Account
  • My Speaking Page
  • Newsletter Sign Up Confirmation
  • Newsletter Unsubscription
  • Our Brands
  • Page Example
  • Privacy Policy
  • Protected Content
  • Register
  • Request a Product Review
  • Shop
  • Shortcodes Examples
  • Signup
  • Start Here
    • Governance
    • Careers
    • Contact Us
  • Terms and Conditions
  • The Edvocate
  • The Tech Edvocate Product Guide
  • Topics
  • Write For Us
  • Advertise

Main Menu

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting, LLC.
      • Dr. Lynch’s Personal Website
      • Careers
    • Write For Us
    • The Tech Edvocate Product Guide
    • Contact Us
    • Books
    • Edupedia
    • Post a Job
    • The Edvocate Podcast
    • Terms and Conditions
    • Privacy Policy
  • Topics
    • Assistive Technology
    • Child Development Tech
    • Early Childhood & K-12 EdTech
    • EdTech Futures
    • EdTech News
    • EdTech Policy & Reform
    • EdTech Startups & Businesses
    • Higher Education EdTech
    • Online Learning & eLearning
    • Parent & Family Tech
    • Personalized Learning
    • Product Reviews
  • Advertise
  • Tech Edvocate Awards
  • The Edvocate
  • Pedagogue
  • School Ratings

logo

The Tech Edvocate

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting, LLC.
      • Dr. Lynch’s Personal Website
        • My Speaking Page
      • Careers
    • Write For Us
    • The Tech Edvocate Product Guide
    • Contact Us
    • Books
    • Edupedia
    • Post a Job
    • The Edvocate Podcast
    • Terms and Conditions
    • Privacy Policy
  • Topics
    • Assistive Technology
    • Child Development Tech
    • Early Childhood & K-12 EdTech
    • EdTech Futures
    • EdTech News
    • EdTech Policy & Reform
    • EdTech Startups & Businesses
    • Higher Education EdTech
    • Online Learning & eLearning
    • Parent & Family Tech
    • Personalized Learning
    • Product Reviews
  • Advertise
  • Tech Edvocate Awards
  • The Edvocate
  • Pedagogue
  • School Ratings
  • The AI Education Revolution: 10 Urgent Questions Universities Must Answer Now

  • Explosive Zero-Day Vulnerability: 15 Million Websites Under Siege – Is Yours Next?

  • The Ultimate Kuru Footwear Trio: A Comfort Revolution for Every Adventure

  • Why Your Mortgage Could Be Denied by Biased AI – And What the Fed Is Doing About It

  • Unprecedented: Lawsuit Demands Total AI Shutdown Amid Rising Global Panic

  • The Astonishing Truth: Microcredentials Now Trump MBAs for Data Science Jobs

  • The Astonishing Twist: AI Cuts Your Job, Then Helps You Sue Your Boss

  • The Staggering Truth About Palo Alto’s $4.5 Billion AI Bet

  • Mind-Blowing: Satellite Metals Now Outweigh Meteoroids, Sparking Urgent Insurance Crisis

  • The Silent Threat From Above: Your Sky Is Changing, And Here’s Why

Digital & Mobile Technology
Home›Digital & Mobile Technology›How to Copy and Paste Only Visible Cells in Google Sheets

How to Copy and Paste Only Visible Cells in Google Sheets

By Matthew Lynch
June 12, 2023
0
Spread the love

Google Sheets is an excellent tool for organizing and presenting your data in a useful way. One of the most common operations on Google Sheets is copying and pasting data. Copying data is not difficult; however, it becomes problematic when copying and pasting visible cells overlapping with the hidden ones. In this article, we will show you how to copy and paste only visible cells in Google Sheets.

Method 1: Using the Filter Function to Copy Visible Cells

The simplest way to copy and paste only visible cells is by using the Filter function. The Filter function allows you to filter out hidden rows and columns to view only visible ones. Here are the steps:

Step 1: Select the data range you want to copy.

Step 2: Click on the Data tab and select Create a Filter.

Step 3: Click on the drop-down arrow in the column you want to filter.

Step 4: In the Filter menu, uncheck the box next to the blank, and click OK. This will hide all the unwanted rows and columns.

Step 5: Once the desired data is filtered, select the entire range, right-click, and select Copy.

Step 6: Go to the intended location, right-click, and select Paste.

Step 7: Click on the Filter button again and select Clear.

Now you have successfully copied and pasted only visible cells in Google Sheets.

Method 2: Using a Script to Copy Visible Cells

If you need to copy and paste visible cells frequently, a script can help you automate this process. Here are the steps:

Step 1: Open the Google Sheets file you want to copy data from, and click on the Tools menu, select Script Editor.

Step 2: In the Script Editor, you can create a new script by clicking on File and selecting New script.

Step 3: Copy the script code below and paste it in the empty script editor.

“`
function copyVisibleCells() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getActiveRange();
var visibleRange = sheet.getRangeList(sheet.getFilter().getRangeList().getRanges()).getRanges()
.reduce(function(a, b) { return a ? a.union(b) : b });
var data = visibleRange.getValues();
var destination = sheet.getActiveRange();
destination.setValues(data);
return true;
}
“`
Step 4: Save the script with an appropriate name.

Step 5: Go back to the Google Sheets file, select the data range you want to copy and click on the Run menu, and select the copyVisibleCells function.

Step 6: The new Range of visible cells will be pasted to the current active range.

By using this simple script, you can copy and paste only visible cells in Google Sheets automatically and with ease.

Conclusion

Copying and pasting in Google Sheets is a great feature that can simplify your work. However, it becomes challenging when copying visible cells overlapping hidden ones. By using either the filter function or a script, you can achieve copying and pasting visible cells quickly and efficiently. We hope this article helps to improve your efficiency in using Google Sheets.

Previous Article

The Best Startup Communities for Entrepreneurs to ...

Next Article

YouTube Channels to Watch Scary Movies (Legally)

Matthew Lynch

Related articles More from author

  • Digital & Mobile Technology

    What Is a Radar Detector and How Does It Work?

    June 12, 2023
    By Matthew Lynch
  • Digital & Mobile Technology

    How to Turn on Facebook Messenger Dark Mode

    June 10, 2023
    By Matthew Lynch
  • Digital & Mobile Technology

    How to Edit a Tweet on Twitter

    August 5, 2023
    By Matthew Lynch
  • Digital & Mobile Technology

    How to Calculate Percentage in Excel

    July 6, 2023
    By Matthew Lynch
  • Digital & Mobile Technology

    The 9 Best Internet Service Providers of 2023

    June 4, 2023
    By Matthew Lynch
  • Digital & Mobile Technology

    YouTube TV Not Working? Here’s How To Fix It

    June 1, 2023
    By Matthew Lynch

Search

Login & Registration

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Newsletter

Signup for The Tech Edvocate Newsletter and have the latest in EdTech news and opinion delivered to your email address!

About Us

Since technology is not going anywhere and does more good than harm, adapting is the best course of action. That is where The Tech Edvocate comes in. We plan to cover the PreK-12 and Higher Education EdTech sectors and provide our readers with the latest news and opinion on the subject. From time to time, I will invite other voices to weigh in on important issues in EdTech. We hope to provide a well-rounded, multi-faceted look at the past, present, the future of EdTech in the US and internationally.

We started this journey back in June 2016, and we plan to continue it for many more years to come. I hope that you will join us in this discussion of the past, present and future of EdTech and lend your own insight to the issues that are discussed.

Newsletter

Signup for The Tech Edvocate Newsletter and have the latest in EdTech news and opinion delivered to your email address!

Contact Us

The Tech Edvocate
910 Goddin Street
Richmond, VA 23231
(601) 630-5238
[email protected]

Copyright © 2026 Matthew Lynch. All rights reserved.