Excel Question - Chicagoland Sportbikes
Chicagoland Sportbikes
 
Geek Squad to the rescue! fucken computer crashing on you again? another porn site infected your computer? tierd of your wife seeing your anal fisting videos and want to lock her out of the external HD? get the answers you need from our local computer experts.

 
LinkBack Thread Tools Display Modes
post #1 of 10 (permalink) Old 04-27-2007, 11:02 AM Thread Starter
You got the talkin' done
 
jrock's Avatar
 
Join Date: May 2006
Location: Alaska, WI
Posts: 15,711
Location: Alaska, WI
Sportbike: 2016 Honda Africa Twin & 1979 Honda CB750F
Years Riding: long enough to have fallen off a few times - glad I wear a helmet!
How you found us: Loose Lips Sink Ships, Loose Wires Cause Fires
           
Excel Question

Is there a test or a function that will search for and report on hidden cells?

If you ain't with us, then it's just bad news.
jrock is offline  
Sponsored Links
Advertisement
 
post #2 of 10 (permalink) Old 04-27-2007, 11:05 AM
Puppy Love!
 
Gixx's Avatar
 
Join Date: Aug 2005
Location: Aurora
Posts: 3,462
Location: Aurora
Sportbike: 05' Gixxer 6
Years Riding: Grew up in the dirt, going on my 7th season on the street..
How you found us: Homer Simpson
           
Send a message via AIM to Gixx Send a message via Yahoo to Gixx
Do you just want to know where the hidden cells are or how many there are??

KJ
_____________________________________________
The CLSB Bitch Wrecking Crew

Quote:
I'm here to chew some bubble gum, and kick some ass.......and I'm all out of bubblegum!!
MySpace
XBox Live - Gixx009
Gixx is offline  
post #3 of 10 (permalink) Old 04-27-2007, 11:17 AM Thread Starter
You got the talkin' done
 
jrock's Avatar
 
Join Date: May 2006
Location: Alaska, WI
Posts: 15,711
Location: Alaska, WI
Sportbike: 2016 Honda Africa Twin & 1979 Honda CB750F
Years Riding: long enough to have fallen off a few times - glad I wear a helmet!
How you found us: Loose Lips Sink Ships, Loose Wires Cause Fires
           
Quote:
Originally Posted by Gixx View Post
Do you just want to know where the hidden cells are or how many there are??
Yes

If you ain't with us, then it's just bad news.
jrock is offline  
Sponsored Links
Advertisement
 
post #4 of 10 (permalink) Old 04-27-2007, 11:30 AM
Puppy Love!
 
Gixx's Avatar
 
Join Date: Aug 2005
Location: Aurora
Posts: 3,462
Location: Aurora
Sportbike: 05' Gixxer 6
Years Riding: Grew up in the dirt, going on my 7th season on the street..
How you found us: Homer Simpson
           
Send a message via AIM to Gixx Send a message via Yahoo to Gixx
You can put all the "hidden" cell data in a chart. Go to Tools, Options, and then in the chart tab under active chart uncheck the box that says "Plot visible cells only".....

KJ
_____________________________________________
The CLSB Bitch Wrecking Crew

Quote:
I'm here to chew some bubble gum, and kick some ass.......and I'm all out of bubblegum!!
MySpace
XBox Live - Gixx009
Gixx is offline  
post #5 of 10 (permalink) Old 04-27-2007, 11:33 AM Thread Starter
You got the talkin' done
 
jrock's Avatar
 
Join Date: May 2006
Location: Alaska, WI
Posts: 15,711
Location: Alaska, WI
Sportbike: 2016 Honda Africa Twin & 1979 Honda CB750F
Years Riding: long enough to have fallen off a few times - glad I wear a helmet!
How you found us: Loose Lips Sink Ships, Loose Wires Cause Fires
           
Quote:
Originally Posted by Gixx View Post
You can put all the "hidden" cell data in a chart. Go to Tools, Options, and then in the chart tab under active chart uncheck the box that says "Plot visible cells only".....
The active chart section is greyed out.

Do you know why that might be?

If you ain't with us, then it's just bad news.
jrock is offline  
post #6 of 10 (permalink) Old 04-27-2007, 11:36 AM Thread Starter
You got the talkin' done
 
jrock's Avatar
 
Join Date: May 2006
Location: Alaska, WI
Posts: 15,711
Location: Alaska, WI
Sportbike: 2016 Honda Africa Twin & 1979 Honda CB750F
Years Riding: long enough to have fallen off a few times - glad I wear a helmet!
How you found us: Loose Lips Sink Ships, Loose Wires Cause Fires
           
Nevermind. Gotta make a chart first. Doh!

If you ain't with us, then it's just bad news.
jrock is offline  
post #7 of 10 (permalink) Old 04-27-2007, 12:09 PM
yo quiero su taco
 
whiteSeatEnvy's Avatar
 
Join Date: Dec 2002
Location: Woodridge
Posts: 12,745
Location: Woodridge
Sportbike: Honda CBR 954 blk/slvr
Years Riding: 10 years
How you found us: They found me. Follow the white rabbit.
           
"Why don't you just go to www.google.com or buy a book on Excel and do some reading? We aren't here to do your friggin' lame ass research for you."

"includes 10 used-car dealers or auto repair shops, 11 liquor stores and bars--two of which advertise lingerie fashion shows and a third billed as a "gentlemen's club"--three cut-rate motels and one trailer park. The squat, brick municipal building is next to a currency exchange and a few steps from an adult video store. The bars open at 10 a.m. and close at 6:30 a.m."

Quote:
Originally Posted by admin View Post
Something must be fishy...I am going to go poke around in the back end..
whiteSeatEnvy is offline  
post #8 of 10 (permalink) Old 04-27-2007, 12:33 PM Thread Starter
You got the talkin' done
 
jrock's Avatar
 
Join Date: May 2006
Location: Alaska, WI
Posts: 15,711
Location: Alaska, WI
Sportbike: 2016 Honda Africa Twin & 1979 Honda CB750F
Years Riding: long enough to have fallen off a few times - glad I wear a helmet!
How you found us: Loose Lips Sink Ships, Loose Wires Cause Fires
           
Quote:
Originally Posted by whiteSeatEnvy View Post
"Why don't you just go to www.google.com or buy a book on Excel and do some reading? We aren't here to do your friggin' lame ass research for you."



Excel for dummies?



If you ain't with us, then it's just bad news.
jrock is offline  
post #9 of 10 (permalink) Old 04-27-2007, 01:42 PM
Puppy Love!
 
Gixx's Avatar
 
Join Date: Aug 2005
Location: Aurora
Posts: 3,462
Location: Aurora
Sportbike: 05' Gixxer 6
Years Riding: Grew up in the dirt, going on my 7th season on the street..
How you found us: Homer Simpson
           
Send a message via AIM to Gixx Send a message via Yahoo to Gixx
Quote:
Originally Posted by jrock View Post
Nevermind. Gotta make a chart first. Doh!
I spend about 4 hours a day m-f in excel....I have to do all kinds of crazy shit everyday. It's annoying, but I've learned a lot about excel.

KJ
_____________________________________________
The CLSB Bitch Wrecking Crew

Quote:
I'm here to chew some bubble gum, and kick some ass.......and I'm all out of bubblegum!!
MySpace
XBox Live - Gixx009
Gixx is offline  
post #10 of 10 (permalink) Old 04-27-2007, 01:50 PM
[Online]
 
Fracker's Avatar
 
Join Date: Mar 2005
Location: Chicago
Posts: 3,695
Location: Chicago
Sportbike: Multistrada 1100S; CBR600RR
Years Riding: Since 2004
How you found us: CRR
           
Do you know VBA? Just bring up the editor (Alt+F11), iterate through all the cells and check their property. If you don't, I can look into that, it's just a few lines of code.

- Stas

Thou shalt not disfigure the soul.
Fracker is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Chicagoland Sportbikes forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

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

 
For the best viewing experience please update your browser to Google Chrome