A
ancharwashere
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 “level 2†results 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.microsoft.com/office/com...55ad82d&dg=microsoft.public.excel.crashesgpfs
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 “level 2†results 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.microsoft.com/office/com...55ad82d&dg=microsoft.public.excel.crashesgpfs