Finance News & Insights

Selecting multiple-screen data ranges in Excel? Here’s a simpler way to do it

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.

Print Friendly

Subscribe Today

Get the latest and greatest finance news and insights delivered to your inbox.