Even cutting a few seconds out of a recurring Excel task can be a huge help for Finance staffers. So here’s an easier way to handle a very common process.
Say you selected an entire data range in Excel because you need to convert that data into a table, but the fact that the range you selected spans a number of screens makes that task a major hassle. This should make the process easier for you:
- Click on any cell in the range you’re working with
- Hit F5
- In the Go To dialog, click on the Special button
- Click Current Region, and finally.
- Hit OK.
Result: Excel will select all of the data in the current range; this includes blanks.