paste special pastes into hidden cells while paste does not in 200

paste special pastes into hidden cells while paste does not in 200

Post by YW5jaGFyd2 » Tue, 17 Oct 2006 06:27:01


Please try the following: 1. Copy one cell then 2. (having a filter on)
select over hidden cells and 3. paste. This will only fill the filtered cells
while paste special will also fill the hidden cells. Oddly enough this
inconsistency does not happen when the cells are hidden manually. This
unexplained inconsistency is counter intuitive and can have quite a
devastating result on a spreadsheet.
Personally I would prefer if I would not have to think of hidden cells when
copying, cutting or pasting. Take for example the great subtotals function:
copying the evel 2results will paste the hidden cells and not the wanted
subtotals. The subtotals have to be copied individually and that can get
quite tedious if the result are more than a few lines wide and high.
These problems happen in Excel versions 2000 and 2003.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.yqcomputer.com/
 
 
 

1. Where can I find the old "Paste Special" (Edit/Paste Special)?

2. why does cut and paste pastes sometimes paste the print screen

I'll explain the problem. When i am in Microsoft Word and lets say, i want to
cut and paste from one place to another, it quite often pastes as if i had
pressed the print screen. So, instread of the text i wanted to see, i see a
picture of the screen. There does seem to be a pattern. If i copy/cut the
text and then move to the place i want to paste it, if i then move the cursor
down, say two lines to fit the copied text in, that is when it happens. If i
prepair it before hand it does not happen.

This started on my old Acer computer. I've replaced it at the weekend with a
new sony laptop. I was devistated to discover that as i have brought my old
files over, i have also brought the old problem with it.

things i have checked.
The print screen button is not stuck on.
I have NAV professional which is kept upto date
I have Microsoft and ad-aware antispyware

Oddities:
on the old computer, the cut and paste problem would occure in applications
such as IE, for instance, cutting a web address and pasting. I do not think
that is happening with my new computer.

any suggests folks?

3. Copy/Paste in Excel prints highlighted cells and does not paste

4. Paste Special and Paste Object

5. pasting a forumla w/o the paste/special/value

6. MS Excel Paste Special>Paste All

7. Paste and Paste Special options are disabled

8. Paste Link is greyed out during Paste Special

9. Can't Copy and Paste or Paste Special between Excel Workbooks

10. How flip a selection before pasting - Paste special

11. HELP - Excel 2003 cut, copy, paste and paste special problems

12. Paste and Paste Special No Longer Working - Excel 2003

13. 'paste special', 'paste link' formatting transfer

14. "paste special" "paste link"

15. help w/ generic copy & paste/paste special routine