Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Copying filtered table doesn't work as it is expected in Excel 2010

02 Jun 2014   #1
Franky

windows 7 32-bit
 
 
Copying filtered table doesn't work as it is expected in Excel 2010

Hi all,

I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2).

Now everything is ready to start the copying! So I select all the table (Double CTRL+A inside the table) then go into the "Go to special" dialog box and choose the "Visible cells only". Then I simply copy that selected filtered range of that table and paste it as follows, (image no. 3);

As it's clear, the right-side of the image shows the result of the copy-paste which of course is very odd! Why not all of the visible rows are pasted please?




Attached Thumbnails
Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-3.png  
Attached Images
Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-1.png Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-2.png 
My System SpecsSystem Spec
.
02 Jun 2014   #2
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Rows 6,9,13,14,16-19 are hidden! Unhide them after the copy/paste action. You can do that by not applying the filter anymore afterwards! So the data you want is just there as you want it. Only you did hide it.

Not odd at all
My System SpecsSystem Spec
02 Jun 2014   #3
Franky

windows 7 32-bit
 
 

you are right completely. Thank you very much.
My System SpecsSystem Spec
.

02 Jun 2014   #4
Kaktussoft

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Kurdman View Post
you are right completely. Thank you very much.
Tip of the day: Don't put any data to left and right of data you probably gonna hide/filter. don't put any data underneath data you probably gonna hide/filter (tables can extend).

In short: Put extra stuff only above the table.
In your case you better move/paste in another sheet.
My System SpecsSystem Spec
03 Jun 2014   #5
Franky

windows 7 32-bit
 
 

Thanks again.
My System SpecsSystem Spec
Reply

 Copying filtered table doesn't work as it is expected in Excel 2010




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
excel 2010 document looks different on work PC
My wife asked me to create an excel document for her at home on my PC which I duly did but she tells me that the nice layout I had produced looks a mess on her work PC which is also running version 2010. I'm in a quandary as to why this has happened and how to fix this please. I did embed the...
Microsoft Office
Inspect document doesn't show anything, Excel 2010
In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why? Thanks in advance.
Microsoft Office
Total row doesn't work properly, Excel 2010
In my Excel 2010 file and in one of its sheets I have a small table. As following, when I checked the Total Row option in Table tools > Design > Table style options > Total Row the tabled appeared as follows. But it is against of the info when I hold the mouse pointer over the Total Row check box...
Microsoft Office
Print preview doesn't work properly in Excel 2010
Hello all, First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to see its preview. But the problem is that the lines between tue and wed and also...
Microsoft Office
Excel 2010 emailed spreadsheet doesn't save/overwrite the orignal
I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to...
Microsoft Office
Excel 2007 doesn't work properly with windows 7
I have found several issue on excel now I'm using windows 7. When you select multiple cells, using control, they aren't highlighted. I also have issues with excel crashing all the time, even on relatively small files and running on a 8Gb machine Anyone else having the same issues?
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App