If the columns or rows are contiguous, you can also take advantage of the grouping tool within Excel. For example, you can hide or unhide more than one column at a time. Did you know that there are several ways you can learn how to hide columns in Excel? While most people know about this Microsoft software feature, there are a couple of things that you might not be aware of.