Notices
The Basement Non-Honda/Acura discussion. Content should be tasteful and "primetime" safe.

access/excel help

Thread Tools
 
Old Jul 29, 2005 | 01:37 PM
  #21  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default

Originally Posted by RB
easiest way:

step one: click on the number of the first row you want to delete.
step two: hold down the shift button.
step three: click on the number of the last row you want to delete.
step four: right click, chose delete.

Viola.
except all rows are scattered throughout the 5000 rows

you lose
Reply
Old Jul 29, 2005 | 02:13 PM
  #22  
RB's Avatar
RB
snitches get stitches
 
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
Default

Originally Posted by Grifter
except all rows are scattered throughout the 5000 rows

you lose


replace the shift button with the CTRL button

i win
Reply
Old Jul 29, 2005 | 02:20 PM
  #23  
DakarM's Avatar
DakarM
 
Joined: Oct 2000
Posts: 44,908
Likes: 0
From: Location Location
Default

he meant he has to search all 5000lines manually. with joshs method it would take just a few clicks
__________________
'00 Dakar Bus CRS Edition
LCD Squad #0001
Originally Posted by WiLL
...I really wanna get out and shoot people.
Reply
Old Jul 29, 2005 | 02:25 PM
  #24  
Grifter's Avatar
Grifter
Thread Starter
Senior Member
 
Joined: Dec 2000
Posts: 44,835
Likes: 0
From: the southwest
Default

Originally Posted by RB
replace the shift button with the CTRL button

i win
i would have to look thru all 5000 rows, which would take about a day's work

you lose again
Reply
Old Jul 29, 2005 | 02:30 PM
  #25  
RB's Avatar
RB
snitches get stitches
 
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
Default

i lose
Reply
Old Jul 29, 2005 | 03:22 PM
  #26  
westcoaststyle's Avatar
westcoaststyle
Still here... sorta...
 
Joined: Sep 2000
Posts: 17,177
Likes: 2
From: CO
Default

and I win. :yay:

wned:
Reply




All times are GMT -8. The time now is 07:28 AM.