How do I hide columns and rows in Excel? Hiding rows or columns in an Excel spreadsheet is easily done through the context menu — the menu that appears when you right click. To start, let’s consider the following example spreadsheet:
Here’s a screenshot:
Now let’s say we want to send this spreadsheet to a co-worker who is only interested in the “Order Total” column. Since they don’t need to see the “Price” and “Qty.” columns you can hide them to make room for other data. To hide these columns, do the following:
The entire “B” column will now be hidden. The data will not be gone, but it won’t be visible in the spreadsheet. You can hide a row the same way:
If the rows/columns to be hidden are directly next to each other, you can click & drag to highlight them all, the right-click and choose “Hide” once to hide them all.
Now let’s say you want to see the hidden data again. Unhiding a row or column is very similar to hiding it. Here are the steps: