Hide and Unhide Columns, Rows, and Cells in Excel – Knowligent
Hide and Unhide Columns, Rows, and Cells in Excel

Hide and Unhide Columns, Rows, and Cells in Excel

HomeHow to, TechHide and Unhide Columns, Rows, and Cells in Excel

You can hide columns and rows in Excel to create a neater worksheet without deleting data you might need later, although there's no way to hide individual cells. In this guide, we'll walk you through three ways to hide and unhide columns in Excel 2019, 2016, 2013, 2010, 2007, and Excel for Microsoft 365.

The key combination for hiding columns is Ctrl+0.

Click a cell in the column you want to hide to make it the active cell.

Hold down the Ctrl key on your keyboard.