 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Conditional formatting - how to populate through 150.000 rows?
Hello, the title says it all; say I'm using conditional formatting formula in the R1 and I want to populate it throughout 150.000 rows (Excel 2007, of course); is there an easy way to do this (I mean, something instead of having to drag 'the corner' all the way down ...) ? Some kind of a shortcut? Mac Select all 15000 and then set the CF based on the first selected cell.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hello, > [quoted text clipped - 5 lines] > 'the corner' all the way down ...) ? Some kind of a shortcut? > Mac Well, that's what I want to avoid..:-) In other words - now, when the maxrow limit is much 'far away', are there any ways to 'jump forward', to speed up ...? > Select all 15000 and then set the CF based on the first selected cell. > [quoted text clipped - 7 lines] > > 'the corner' all the way down ...) ? Some kind of a shortcut? > > Mac If the data is contiguous in that column, hold down the <shift> key, press <end> followed by <down-arrow>, then release <shift>. If not contiguous, then press F5 (GoTo) and enter A150000. Select the cell in the appropriate column, hold down <shift>, press <ctrl-end>, select the appropriate cell, then release <shift>. A third alternative is just to select the complete column by clicking on the column identifier. Hope this helps. Pete > Well, that's what I want to avoid..:-) In other words - now, when the maxrow > limit is much 'far away', are there any ways to 'jump forward', to speed up [quoted text clipped - 21 lines] > > - Show quoted text - Or just hit control-A to select all. >If the data is contiguous in that column, hold down the <shift> key, >press <end> followed by <down-arrow>, then release <shift>. [quoted text clipped - 50 lines] > > Hi Mac, I don't know if the name box is in 2007, but in previous versions you simply click in the name box and enter say A1:A65000 then hit enter. That will select cells A1 through A65000. The name box is just to the left of the formula bar and usually displays the active cell. HTH Martin > Hello, > [quoted text clipped - 5 lines] > 'the corner' all the way down ...) ? Some kind of a shortcut? > Mac Yep, I realized it a few moments ago. Thanks anyway! > Hi Mac, > [quoted text clipped - 18 lines] > > 'the corner' all the way down ...) ? Some kind of a shortcut? > > Mac
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.