Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Excel- copy and paste without hidden rows?


(!)

drewmeister_sd's Avatar
drewmeister_sd drewmeister_sd is offline
Computer Specs
Junior Member with 7 posts.
THREAD STARTER
 
Join Date: Aug 2007
Experience: Intermediate
30-Aug-2007, 12:56 PM #1
Solved: Excel- copy and paste without hidden rows?
Greetings.

I have a pivot table that I'm trying to pull a sample from. It is 1800 rows, of which about 400 have data that I want to use for my sample selection. I'm trying to generate my sample randomly. I've hidden the empty rows. I tried to copy this into another file, but the hidden rows are included as well. Data sort doesn't work, or I can't get it to work.

Any ideas? I was hoping to just copy the data only rows into a new file and generate random numbers for my sample, using the row #s as my selection criteria.
Anne Troy's Avatar
Computer Specs
Member with 11,714 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Intermediate
30-Aug-2007, 02:20 PM #2
Select the area.
Hit Edit-->Go To-->Special-->Visible Cells only
Copy.

Try that. I'm pretty sure it works, tho I didn't test it.
Zack Barresse's Avatar
Computer Specs
Member with 5,419 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
30-Aug-2007, 03:47 PM #3
If that doesn't work for you drewmeister_sd, try uploading a small sample of your work and lining out how you would like it to look.
drewmeister_sd's Avatar
drewmeister_sd drewmeister_sd is offline
Computer Specs
Junior Member with 7 posts.
THREAD STARTER
 
Join Date: Aug 2007
Experience: Intermediate
30-Aug-2007, 07:38 PM #4
Thank you so much Anne!

I read through 2 different manuals and couldn't find a solution. I was going to chuck my fancy statistically valid, random sample selection. My boss will like to hear this!
Anne Troy's Avatar
Computer Specs
Member with 11,714 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Intermediate
30-Aug-2007, 08:41 PM #5
Cool beans, Drew.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑