This quick guide will explore a few methods that can be used to hide and unhide rows and columns in Excel. This allows you to focus on only the data that is necessary for you to complete the task at hand. When dealing with large data sets in Excel it can be useful to hide rows and columns.