New Posts For Thread: Excel help, pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-pleaseI need to select 30000 rows but I do not want to select the first 10 rows. At the moment, I am simply scrolling down the page starting on row 11 but it takes a couple of minutes every time. Is there a quicker way of selecting these cells.Thanks in adThank you all for your help. I'm going with Aviboyd's suggestion. Excel is truly amazing. I still haven't come across anything you can't do with this program.https://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415626#420415626Thank you all for your help. I'm going with Aviboyd's suggestion. Excel is truly amazing. I still haven't come across anything you can't do with this program.Sat, 27 Feb 2010 21:26:19 -0600Select all the rows you want then in the name box type a name likeselection click enter then any time you want to select those rows go to the drop down in the name box and click on selection. Voila!https://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415562#420415562Select all the rows you want then in the name box type a name likeselection click enter then any time you want to select those rows go to the drop down in the name box and click on selection. Voila!Sat, 27 Feb 2010 07:26:33 -0600Sorry that should be Range(Rows(11), Rows(30000)).Selecthttps://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415558#420415558Sorry that should be Range(Rows(11), Rows(30000)).SelectSat, 27 Feb 2010 05:28:24 -0600Create a command button. Click the command button icon in the control toolbox toolbar. Double click where you want the button in the spreadsheet. The VBA code for Sub CommandButton1_Click should appear. Type in Range(Rows(10), Rows(30000)).SelectChttps://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415554#420415554Create a command button. Click the command button icon in the control toolbox toolbar. Double click where you want the button in the spreadsheet. The VBA code for Sub CommandButton1_Click should appear. Type in Range(Rows(10), Rows(30000)).SelectCSat, 27 Feb 2010 05:26:56 -0600Highlight your first row, press Shift/Ctrl/down arrow, that will instantly highlight all the rows.https://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415550#420415550Highlight your first row, press Shift/Ctrl/down arrow, that will instantly highlight all the rows.Sat, 27 Feb 2010 05:09:19 -0600Can't you just freeze the first 10 rows so that you cannot pick them up?https://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415546#420415546Can't you just freeze the first 10 rows so that you cannot pick them up?Sat, 27 Feb 2010 05:07:21 -0600Thanks, but is there no way of doing this without scrolling? What is "the brick?" I assume it is a way to make scrolling super fast that I don't yet know about.https://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415542#420415542Thanks, but is there no way of doing this without scrolling? What is "the brick?" I assume it is a way to make scrolling super fast that I don't yet know about.Sat, 27 Feb 2010 05:01:45 -0600Click on the Cell or Row number (to highlight entire row) that you want, then hold down the Shift button on your keyboard. Then scroll down to where you want to be (left click and hold down on the 'brick' in the scroll window to move fast), then clihttps://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415538#420415538Click on the Cell or Row number (to highlight entire row) that you want, then hold down the Shift button on your keyboard. Then scroll down to where you want to be (left click and hold down on the 'brick' in the scroll window to move fast), then cliSat, 27 Feb 2010 02:29:23 -0600I need to select 30000 rows but I do not want to select the first 10 rows. At the moment, I am simply scrolling down the page starting on row 11 but it takes a couple of minutes every time. Is there a quicker way of selecting these cells.Thanks in adhttps://community.betfair.com/general_betting/go/thread/view/94082/23524770/excel-help-please?post_id=420415534#420415534I need to select 30000 rows but I do not want to select the first 10 rows. At the moment, I am simply scrolling down the page starting on row 11 but it takes a couple of minutes every time. Is there a quicker way of selecting these cells.Thanks in adSat, 27 Feb 2010 00:49:41 -0600