Data in hidden rows and columns. The show data in hidden rows and columns option in the hidden and empty cells Settings window is used to instruct Excel to display the values on sparklines. Even if the rows or columns in which they are located are hidden