How to Hide a Column in Google Sheets

Spreadsheets often contain vast amounts of data, much of which you may not need to look at every single day. For instance, you might have a column dedicated to employee ID numbers or complex background calculation formulas that are essential for the sheet to function, but simply clutter up the screen when you are trying to read a final report. Instead of deleting these vital columns, Google Sheets allows you to easily hide them from view.

How to Hide a Single Column

Hiding a column removes it from the screen, pushing the adjacent columns together, but all the data inside remains intact and continues to work perfectly in any formulas.

1. Open your Google Sheets document.
2. Look at the very top of the spreadsheet grid where the column letters are displayed (A, B, C, D, etc.).
3. Hover your mouse over the letter of the column you want to hide (for example, Column C).
4. A small downward-pointing arrow will appear on the right side of the column letter box.
5. Click that downward arrow (or simply Right-click anywhere on the column letter).
6. A long drop-down menu will appear.
7. Scroll down the menu and click on Hide column.
8. Column C will instantly vanish. You will notice that the letters at the top now skip directly from B to D.

How to Hide Multiple Columns at Once

If you have a block of columns you want to hide (e.g., historical data from January, February, and March), you can hide them all simultaneously.

1. Click and hold your mouse button on the first column letter (e.g., Column B).
2. Drag your mouse across the headers to highlight multiple columns (e.g., drag to Column D). The selected columns will be highlighted in light blue.
3. Right-click anywhere inside the highlighted column headers.
4. Select Hide columns B – D from the menu.

How to Unhide a Column

Bringing hidden data back is just as easy.

1. Look closely at the column headers where the hidden column used to be (between B and D).
2. You will see a slightly thicker border line, and two small, opposing arrows pointing outward (◀ ▶).
3. Simply click on those small arrows.
4. The hidden column (or columns) will instantly expand back into view, restoring the normal alphabetical order.

Why Hiding is Better Than Deleting

If you delete a column, any formulas elsewhere in your spreadsheet that referenced that data will instantly break, resulting in ugly #REF! errors. Hiding columns is the safest way to clean up your workspace for a presentation or daily use without risking the structural integrity of your data.