View Single Post
 
Old 07-05-2012, 01:05 PM
Slurpyga Slurpyga is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jul 2012
Posts: 2
Slurpyga is on a distinguished road
Default Using excel to track video game collection - questions

Over the past year or so I've been meaning to finally create a database of sorts to track my game collection(retail boxed/digital games, guides etc). I'm moving within the month, and am in the process of packing everything up so now is my best time to create said database. To be blunt, I've used excel for very basic items but never a large database with multiple 'categories'. I have opened excel but that's as far as I got because I want to make sure the best way to go about this. My first thought-through was I'll have about 10 columns(all ofwhich I would like to be able to sort by). And about a thousand rows(one row for each individual item). My question is really about entering the data and 'locking the rows of info together'. Should I just start entering data from left to right(title/release/genre/etc/etc)? I assume there is some way to lock all cells in a row together which will make this possible? IE: so that I can sort each column and 'all the data' in that row gets sorted as well. In essence I need to know: -Is there any special way I should enter the data(special cell) or just start typing the data in in each cell then format later? -How do I lock each row of information together? So that each row is 'one entry' rather then a row of 10 columns -Any special way to create sortable columns? Or will just clicking the header and hitting sort work? Thanks in advance, and sorry for the noob questions - but I'll probably never ever use excel after this so I don't really want to invest in a book and video guides that cover everything.
Reply With Quote