{"id":2243,"date":"2026-10-01T10:48:49","date_gmt":"2026-10-01T10:48:49","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2243"},"modified":"2026-10-31T12:13:08","modified_gmt":"2026-10-31T12:13:08","slug":"hide-and-unhide","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/formatting\/hide-and-unhide\/","title":{"rendered":"Hide and unhide"},"content":{"rendered":"
\n
\n
\n
\n
\n\t\t\t\t\t\t[addtoany]<\/p>\n

Hide and unhide<\/h1>\n

Among the options that appear when you click Format in the Cells group (under the Home tab) you also find the tools for deciding what is to be visible in the workbook – you can hide and unhide rows or columns. Hidden rows and columns are indicated by small gaps between the row headings and column headings respectively.<\/p>\n

\"FormatHideUnhide\"<\/p>\n

Columns are visible:
\n\"Basic<\/p>\n

Columns are hidden:
\n\"hidden<\/p>\n

To unhide columns, select the surrounding columns and then click Unhide Columns.<\/p>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/div>\n
\n
\n
<\/p>\n
\n
\n

Previous<\/h2>\n

Adjust column width and row height<\/a><\/p>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n

Index<\/h2>\n

Excel Basic Course Online<\/a><\/p>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n

Next<\/h2>\n

Group<\/a><\/p>\n

<\/div>\n<\/p><\/div>\n<\/p><\/div>\n

<\/center><\/div>\n<\/div>\n

Some of our customers<\/h2>\n

We have both large and small companies as customers.<\/p>\n

\n
\n
\n
\n\t\t\t\t\t\t
\"Continental\"<\/a><\/div><\/div><\/div>
\"Kalmar<\/a><\/div><\/div><\/div>
\"Lundstams\"<\/a><\/div><\/div><\/div>
\"Fria<\/a><\/div><\/div><\/div>
\"Newsec\"<\/a><\/div><\/div><\/div>
\"EMC\"<\/a><\/div><\/div><\/div>
\"Fortum\"<\/a><\/div><\/div><\/div>
\"Navetti\"<\/a><\/div><\/div><\/div>
\"Stockholm<\/a><\/div><\/div><\/div>
\"Viafone\"<\/a><\/div><\/div><\/div>
\"Visma\"<\/a><\/div><\/div><\/div>
\"Hush\u00e5llningss\u00e4llskapet\"<\/a><\/div><\/div><\/div><\/div>
<\/i><\/div>
<\/i><\/div><\/div><\/div><\/p>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n