You have a large amount of Data in Excel and you want to look at certain parts of the data; temporarily putting your data in the right order, or maybe blocking out the other bits of data so that things are a little less confusing to look at.


Solution

  • You can keep your data organised in Excel by sorting or filtering that data based on their columns.


Steps

This video from Pip shows you how this is achieved using Filters in Excel.