Tip Ride the Range from the Bottom to Find Last

It is difficult to trust data from anywhere. If you are analyzing data in Excel, remember that the data is often coming from who-knows-what system written who-knows-how-long ago. The universal truth is that sooner or later, some clerk somewhere will find a way to break the source system and will manage to enter a record without an invoice number. Maybe it takes a power failure to do it, but invariably, we cannot count on having every cell filled in.

This is a problem when using End+Down. This key combination does not take you to the last row with data in the worksheet. It takes you to the last row with data in the current range. In Figure 2.45, hitting End+Down would move the cursor to cell A6 instead of cell A10.

0 0

Post a comment