Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bernie
 
Posts: n/a
Default paste excel sheet excluding hidden rows

I want to copy a sheet containing hidden rows and then copy & paste to a new
sheet excluding the hidden rows - how can I do this? Normal copy / paste
pastes the hidden rows too. Thanks, Bernie
  #2   Report Post  
Posted to microsoft.public.excel.misc
mickbarry
 
Posts: n/a
Default paste excel sheet excluding hidden rows


Bernie,
If the cells were hidden as a result of filtering (Data Filter
Autofilter)
then ALT; (shortcut for GOTO Special Visible Cells only)
Ctrl C (Copy)
Ctrl V (Paste)

Hope it helps
Regards Mick Barry


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=507181

  #3   Report Post  
Posted to microsoft.public.excel.misc
fbarbie
 
Posts: n/a
Default paste excel sheet excluding hidden rows


What is the converse of this? What if you want to paste data so that it
only goes into rows and cells that remain after autofiltering?


--
fbarbie
------------------------------------------------------------------------
fbarbie's Profile: http://www.excelforum.com/member.php...fo&userid=8110
View this thread: http://www.excelforum.com/showthread...hreadid=507181

  #4   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default paste excel sheet excluding hidden rows

When you paste, it will paste into a contiguous range, not the visible
cells in the filtered range.

Perhaps you could mark the visible rows, by putting an X in an adjacent
column. Then, sort by the marked column, and paste into the grouped cells.

fbarbie wrote:
What is the converse of this? What if you want to paste data so that it
only goes into rows and cells that remain after autofiltering?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and paste hidden rows tracykrulich Excel Worksheet Functions 1 October 13th 05 05:11 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
How do I stop an Excel sheet from automatically hiding rows when . kazyreed Excel Worksheet Functions 1 February 3rd 05 04:35 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"