Excel Cells Selection

[rkrt1]

Hi Dear Fellows

It often happens, when I try to copy multiple cells, Excel doesn't copy all cells as a single selection, instead, it selects in stages (picture below). Due to this, every time I have to paste the data in stages based on the division of selection below.

Anybody can pls help me to figure out how to copy the whole range as a single selection (like pic 2), please? This will solve one of the biggest problems I am facing.

Thanks

 

[Joe4]

It looks like you have filtered data.
My guess is some rows are being hidden by the filters, and that is why it is segmenting the range.
Is that correct?

 

[rkrt1]

It looks like you have filtered data.
My guess is some rows are being hidden by the filters, and that is why it is segmenting the range.
Is that correct?

Yes, the data is filtered

 

[Joe4]

So, are you just trying to copy the visible cells and not the hidden ones?

 

[rkrt1]

So, are you just trying to copy the visible cells and not the hidden ones?

Yup. I am trying to copy the visible cells only.

 

[Joe4]

See here: Copy visible cells only

 

[rkrt1]

See here: Copy visible cells only

Amazing.
Thanks bunch dear @Joe4

 

[Joe4]

You are welcome.
Glad I was able to help!