how do I select, cut, and paste visible cells only
 

When I use filters to leave only certain cells visible, cut them and paste
them to a new column, when I open up the hidden cells, both visible and
invisible cells are pasted to the new column and not just the invisible cells
selected, cut, and pasted. This is a large workbook. A macro to do this
would be great for future use. I am a computer idiot.

how do I select, cut, and paste visible cells only
 

If you select the filtered area, press F5, special and select visible cells,
then copy it will only copy visible cells. You could record a macro while
doing this


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Cutting and pasting invisible cells." <Cutting and pasting invisible
wrote in message
...
When I use filters to leave only certain cells visible, cut them and paste
them to a new column, when I open up the hidden cells, both visible and
invisible cells are pasted to the new column and not just the invisible
cells
selected, cut, and pasted. This is a large workbook. A macro to do this
would be great for future use. I am a computer idiot.

how do I select, cut, and paste visible cells only
 

You can use Alt+; in your selection to restrict it to only visible cells, and
then when you copy and paste it will behave as you expected. That is a
keyboard shortcut for Edit - Go to - Special - Visible cells only.

Miguel.

"Cutting and pasting invisible cells." wrote:

When I use filters to leave only certain cells visible, cut them and paste
them to a new column, when I open up the hidden cells, both visible and
invisible cells are pasted to the new column and not just the invisible cells
selected, cut, and pasted. This is a large workbook. A macro to do this
would be great for future use. I am a computer idiot.