You might already learned how to Split windows and freeze spreadsheet panes to optimize the spreadsheet view. However, if you have a large spreadsheet which you need to review multiple parts of the spreadsheet at the same time, the above mentioned trick might just not be enough.
In this case, you will be more appreciate if you can show only the columns or rows you are interested in. In other words, you just need to hide the columns and rows that you dont want. The steps below guide you to hide or unhide rows and columns:
- Select the rows or columns to be hidden or shown
- Select Format -> Row -> Hide or Unhide, or Format -> Column -> Hide/Unhide
This tips allow you to hide and unhide particular rows or columns. It simplifies working with the excel spreadsheet. Apart from this, it also prevent certain information from being seen.