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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)> wrote in message
news:D[email protected]...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
How to copy and paste only visible cells from Excel using vbscript 0
Pasting into a filtered sheet 3
Cut & Paste in Excel without erasing cell borders? 1
Paste to Visible Cells only 1
To paste copied data in filtered/visible cells only 1
Copying and pasting to visible cells only 4

Back
Top