Skip to content
  • 086 167 3923
  • hello@SummitSolutions.co.za
  • Login
  • Sign up for online courses
Menu
  • Login
  • Sign up for online courses
  • 086 167 3923
  • hello@SummitSolutions.co.za
  • Login
  • Sign up for online courses
Menu
  • Login
  • Sign up for online courses
  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Menu
  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Facebook Linkedin
  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Menu
  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Facebook Linkedin

Copy and Paste excluding hidden Rows and Columns

  • Jul 16, 2021
  • 1:26 pm

Normal copy and paste includes hidden rows and columns, so how do you Copy and Paste just the cells that are visible? Select Visible Cells only before copying. The quick guide…

  1. Select the range you want to copy (ctrl + A)
  2. Call up Go To (Ctrl + G)
  3. Click on the Special… button bottom left
  4. Select the Visible Cells only option and click on OK
  5. Copy (ctrl + C) and Paste (ctrl + V)
Download Excel template

To learn more of these simple tips, and increase your overall proficiency, check out our basic Excel training course, ideal for beginners or those wanting to upskill their Excel knowledge.

PrevPreviousCopy and Paste with Column Widths
NextDuplicate content from cell aboveNext
Back to all Excel tips
Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp
Share on email

Contact us

  • 086 167 3923
  • hello@summitsolutions.co.za
  • Head Office: The Junction, 49 Garlick Avenue, Garlington, Hilton, 3245

Sign up for our newsletter

Receive our monthly Excel tips and news to your inbox!

Quick links

  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Menu
  • Home
  • Online courses
    • The High-Five Bundle!
    • MS Excel Beginner Course
    • MS Excel Intermediate Course
    • MS Excel Advanced Course
    • MS Excel Automation
    • Shop all courses
  • Corporate training
  • Consulting
  • Blog
  • Tips
  • FAQs
  • Contact
Facebook Linkedin

© Custom IT Solutions cc | Terms | Privacy Policy | Cookie Policy | Website by Yellow Door Collective

Scroll to top
Login

Lost Your Password?