But you might wonder how to limit the number of columns in a filtered result set. You can’t using a simple Excel filter, because the feature filters the source data in place.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Understanding Excel Column Headers Excel refers to rows by number and columns by letter, starting the first row at one and the first column with "A".