And row 5 is the the single row of headings. A blank column H separates the main data set from a lookup table in columns I and J. A blank row 569 separates the main data set from some explanatory notes. In Figure 1, there is a blank row (row 4) between the titles and headings. And if you have some tables to the right of the data, you need one completely blank column between your data and the other tables. The same applies if you have boilerplate notes below the data-there has to be a completely blank row between the last row of data and the notes. For example, if you have titles in cells A1:A3, then row 4 needs to be completely blank. If there are titles above the headers, a blank row is needed between the titles and headers. Your data needs to have a single row of headers at the top. The sort method used in this article doesn’t allowing sorting by color or by icon. Let’s look at a way to use the old sort method in Excel 2007 or later versions. Unfortunately, that recorded code also remembers that you had 123 rows, even if you have more or less rows in the future. Yet even if you’re doing a simple “Sort by column F descending within column C ascending” sort, the macro recorder generates complicated code that could allow for sorting by color or icon. You can now sort by cell color, font color, or icon, and you’re allowed more than three levels. But following the release of Excel 2007, sorting became complicated. You would specify up to three key fields and indicate if you wanted each field sorted ascending or descending.

Excel vba on key press