Search for courses or lessons
Redeem a coupon
Start free trial
What is a contiguous data range?
A range of data made up of distinct values
A range of data uninterrupted by blank rows or columns
A range of data with no blank cells
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 sort and filter the data
It allows us to use the range as a PivotTable data source
It allows us to write better formulas
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement