So, now that you know about both sorting and filtering — how do you choose which to do? After all, they produce similar results in a way. The simplest answer is generally, “Whichever you want.” I personally use filtering so… Read moreSorting vs. Filtering: How to choose

Still with the example of the book inventory, imagine you have a very long series of books to record. Now, there are a variety of alternatives you could try, and all of them could be good for one purpose or… Read morePasting values: Basic how-to

Sooner or later, if you have a list of things in a spreadsheet, you’re probably going to find yourself wanting to sort it. In its simplest form, sorting a spreadsheet is like organizing a bookshelf or closet. Sure, if you’ve… Read moreSorting: Basic how-to

If you have an inventory or other detailed list in a spreadsheet, chances are that sooner or later you’ll want part of the list, and not the rest. Looking at the example of the book inventory, imagine that there was… Read moreFiltering: Basic How-To