Copy visible cells only

You have a table of data and you hide some rows and columns and you want to copy only the visible cells into another sheet? I’m going to show you some techniques that you can use to do that. Let’s see how our original table looks like:

Copy_Visible_only1

Now, let’s hide some rows and columns so that our table looks like this:

Copy_Visible_only2

If you select the entire table (cells A1:E12) and just copy and paste (Ctrl+C and Ctrl+V) it into another sheet, it would copy all rows and columns and would look like the original table. That’s not what we want to do, we just want to make a copy and show only the 7 rows and 4 columns that we see on the image above. For that we need to select the visible cells only so that we can copy only those. Let’s select again cells A1:E12 but this time we’re going to select first only the visible cells, before copying. We can do this by just using the shortcut Alt+; (semicolon) or you can go to the Home menu bar, on the Editing group, and click on the Find & Select button and choose Go To Special option.

Copy_Visible_only3

Instead of going to the menu bar, you can just press F5 or Ctrl+G to open the “Go To” dialog box and then just press the Special button on the bottom. On the Go To Special dialog box, select the “Visible cells only” option:

Copy_Visible_only4

This will select only the visible cells, as you can see on this image:

Copy_Visible_only5

Now you can just Ctrl+C (Copy) and Ctrl+V (Paste) it into another location. This will only copy the visible cells, like you wanted.
If you are working with Filters, you don’t need to use this techniques because, when you copy filtered data, it only copies the visible cells already.

7 comentários:

Anonymous said...

you just made a pivot table miracle for me. thank you so much!

Anonymous said...

this doesn't work

Unknown said...

You have to mark the cells you want to copy before you press Go to Special

Ahmed said...

The keyboard shortcut for Go To Special Visible Only is Alt+;

vanahi688 said...

Thuốc shisha
bình shisha giá rẻ
ke toan ha noi
hoc tin hoc van phong
dich vu ke toan
công ty kê toán hà nội
tieng anh newlight
dia chi hoc ke toan
dich vu ke toan gia re
trung tam ke toan ha noi
ke toan bac ninh
hoc chung chi ke toan
cong ty ke toan ha noi
kế toán hà nội
đào tạo kế toán tphcm
đào tạo kế toán tổng hợp
dạy kế toán thuế
đào tạo kế toán
trung tâm đào tạo kế toán hà nội
kế toán hà nội kthn
cong ty dich vu ke toan ha noi
day hoc ke toan
hoc ke toan thue
học kế toán thuế
trung tâm kế toán
đào tạo kế toán tốt nhất
làm báo cáo tài chính cuối năm
dịch vụ kế toán

Unknown said...

hoc ke toan tai dong nai
hoc ke toan tai thu duc
hoc ke toan tai nghe an
hoc ke toan tai hai phong
dich vu ke toan gia re
cong ty ke toan ha noi
hoc ke toan tai cau giay
cong ty lam dich vu ke toan tai ha noi
viet thue bao cao thuc tap
bao cao thuc tap ke toan

idn poker online said...

Poker ceme domino sudah menjadi permainan kalangan masyarakat tentunya, apalagi bisa bermain di hp seluler kalian tentunya akan lebih asik lagi bukan? jika ingin bermain permainan kartu kalian bisa datang kesitus kami untuk merasakan permainan kartu di aplikasi.

agen idn poker

agen idn poker deposit pulsa
agen poker idn yang bisa deposit pakai pulsa

deposit poker idn pakai pulsa
deposit poker idn pakai pulsa telkomsel

deposit poker idn pakai pulsa xl

cara deposit idn poker pakai pulsa

deposit idnplay

tambah kredit saldo idn poker

deposit idnplay pakai pulsa

deposit poker uang asli

tambah saldo idnplay


buat akun poker online

akun poker online uang asli


idn poker.apk versi 2.1.0.1

aplikasi mobile poker.apk


deposit poker pakai pulsa

idn poker online

deposit poker via ovo

deposit poker via pulsa telkomsel

deposit poker via pulsa xl