December 28

0 comments

Excel – Copy and paste excluding hidden columns or rows

By Sharyn Baines

December 28, 2014

Hide, Modifying, Paste

Learn how to copy and paste excluding hidden columns or rows.

Ever tried to copy and paste data thinking you will be pasting, excluding the hidden columns or rows?

Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.

In this post I’ll explain how to copy and paste only the visible data – hidden cells are excluded.

 

Copy and paste excluding hidden columns or rows

1.First select the data range, including the hidden rows or columns.

2. Press F5.

3. Click Special and then select Visible Cells Only.
copy and paste excluding hidden columns or rows

4. Click OK.

5. Now Copy the selected cells and then Paste them where required. Only the visible cells will be pasted.

 

Sharyn is an expert trainer.  She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.

She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

If you enjoyed this you may also enjoy...

How to freeze a row in Excel

[Watch on YouTube] /  [Subscribe to our YouTube Channel]Let’s look at how to freeze a row in Excel.  It can be a real pain when you don’t have freeze panes on, and when you start to scroll down the screen you lose the headings at the top of your columns. 

Read More

Use Conditional Formatting to identify cells that are of interest

  Learn how to use Conditional Formatting to identify cells that are of interest. For example, you can apply a Conditional Format that checks to see a cell’s value is greater than $500. If it is the Conditional Format can change the Fill colour of the cell. Therefore making it really easy for you (and others using

Read More

Find, modify and break links to an Excel workbook

  Learn how to find, modify and break links to an Excel workbook. Linking is great, until you no longer need it. Then it can be a bit of a pain. A couple of challenges may come your way if you weren’t the creator of the workbook that contains links. One challenge is identifying where the linked data

Read More

Link cells in the same or different Excel worksheets

Learn how to link Link cells in the same or different Excel worksheets. Linking saves a huge amount of time (and a huge amount of mistakes) in that it allows you to create connections from one cell to another. For example, if I’m creating a personal cash flow worksheet and at the end of the month I

Read More

Insert an Excel function into your workbook

Learn how to insert an Excel function into your workbook. Excel comes equipped with a large number of pre-defined formulas. These are known as functions. There is a great amount of functions available in Excel. Each created for a specific purpose. There are functions specific to Maths, Science, Finance, and Engineering to name a few. 

Read More

Sharyn Baines

About the author

Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand. She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"0328f":{"name":"Main Accent","parent":-1},"7f7c0":{"name":"Accent Darker","parent":"0328f","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"0328f":{"val":"var(--tcb-skin-color-0)"},"7f7c0":{"val":"rgb(4, 20, 37)","hsl_parent_dependency":{"h":210,"l":0.08,"s":0.81}}},"gradients":[]},"original":{"colors":{"0328f":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"7f7c0":{"val":"rgb(4, 21, 39)","hsl_parent_dependency":{"h":210,"s":0.81,"l":0.08,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__
Previous Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"0328f":{"name":"Main Accent","parent":-1},"7f7c0":{"name":"Accent Darker","parent":"0328f","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"0328f":{"val":"var(--tcb-skin-color-0)"},"7f7c0":{"val":"rgb(4, 20, 37)","hsl_parent_dependency":{"h":210,"l":0.08,"s":0.81}}},"gradients":[]},"original":{"colors":{"0328f":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}},"7f7c0":{"val":"rgb(4, 21, 39)","hsl_parent_dependency":{"h":210,"s":0.81,"l":0.08,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__
Next Article

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!

>