Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
What is a contiguous data range?
A range of data with no blank cells
A range of data uninterrupted by blank rows or columns
A range of data made up of distinct values
How do we create a contiguous range?
Remove all blank rows and columns
Go to the Data tab and click the Make Contiguous button
Sort it so that all data types are together
To create a contiguous range, we can enter values all the way down the column immediately next to multiple non-contiguous ranges. What is the main benefit of doing this?
It allows us to use the range as a PivotTable data source
It allows us to write better formulas
It allows us to sort and filter the data