|
|
declanm
Total Posts: 626
Last Post: 12-02-08
Member Since: 04-08-08
|
|
|
all you have to do is select ALL COLUMNS for each row you wish to sort. Easiest way to do this type of select is to position the cursor in the first column(which is always numbered and not part of the spreadsheet.) Then hold the cursor down and drag the cursor thru the row numbers for all rows you wish to sort. Click on Data tab, click on sort and specify the columns to be used for sorting and whether or not columns are to be sorted ascending or descending Then specify if a header row is included in your range to be sorted.
|
|
|
69miniCoop
Total Posts: 27
Last Post: 10-15-08
Member Since: 02-19-08
|
|
|
anytime buddy....excel is a lot more fun when ur job doesn't rely on it =) 2001 Mercedes E55 AMG - Daily Driver - she can't swim =( gone but not forgotten. 2005 BMW 645ci - the new Daily Driver! 1994 Mitsubishi 3000GT - Show Car 1969 Mini Cooper Innocenti - Toy
|
|
|
hondaguyjoe
Total Posts: 1409
Last Post: 12-02-08
Member Since: 02-16-01
|
|
|
This board is great thanks Alex for the Sheet!
99% of SU problems are Lucas electronics
|
|
|
69miniCoop
Total Posts: 27
Last Post: 10-15-08
Member Since: 02-19-08
|
|
|
send me you email address and i'll forward you the sheet formatted for you....than all you'll have to do is continue adding information kandygreen3k at aol dot com 2001 Mercedes E55 AMG - Daily Driver - she can't swim =( gone but not forgotten. 2005 BMW 645ci - the new Daily Driver! 1994 Mitsubishi 3000GT - Show Car 1969 Mini Cooper Innocenti - Toy
|
|
|
MikelSS
Total Posts: 55
Last Post: 05-14-08
Member Since: 10-30-07
|
|
|
Select all cells that you want to sort (from MkI to the 850 on MkIII) the select Data, Sort and it will ask you which column you want to sort first. Or you can do an even cooler thing: select the title row (Mini Mk to Size Engine) and select Data-Filter-Auto Filter. This way you can sort in various was with just a little drop menu from each column. Just remember to reset filters when you want to start again. I hope this helps and is not very confusing.
|
|
|
hondaguyjoe
Total Posts: 1409
Last Post: 12-02-08
Member Since: 02-16-01
|
|
|
Hey guys I need to do up an excel sheet and Im having trouble figuring out how to do something. how do you lock the info in a row all together. So if you sort by column all the info in the row stays together? For example Mini Mk Color Size wheels size engine MkI Blue 10 850 MkII Blue 12 998 MkIII white 10 850 What would I do to each row to keep the info together so if I were to sort by assending order of wheel size all the info for each car would stay correct and not just the wheel size info move. Thanks
99% of SU problems are Lucas electronics
|
Product Search
Shopping Cart
Product Home
Catalog
Sale Items
Clearance Items
Auctions
My Wish List
Article Browse
Technical Information
Installation Instructions
Galleries
Downloads
Forum
Frappr
Clubs & Links
Service Shops
Events
Mailing List Status
Logout
Newsletter Sign-Up
About Us
Contact Us
Warranty Info
Shipping Info
Return Policy
Privacy Policy
BMW MINI Parts
Engines
Performance
VTEC Conversions
Internet Specials!
Posted: May-14-2008 06:10PM
