Okay, let’s say you’ve got an inventory with all the information you could possibly want… but you don’t necessarily want it all right now. Let’s say you’re browsing in a bookstore, and have your inventory on a chip in your… Read moreHiding and Showing: Basic How-To

Okay, time a brief introduction to some techniques that we’ll be needing from here on out. I’ve previously mentioned selecting one or more cells, but if we’re talking about potentially large detailed lists it’s now time to discuss how to… Read moreSelecting and navigating cells, rows, and columns: Basic How-To

Continuing with the example of the book inventory, let’s say that you set up the perfect inventory — and then realized you needed something else. The last time we moved, I had had enough of not being able to find… Read moreInserting columns: Basic how-to

To start off the discussion of detailed lists in spreadsheets, here’s a simple example: a book inventory. While this project focuses on books the techniques it demonstrates can be used for almost any sort of inventory. I’ve always wanted to… Read moreProject 5: Book inventory