Question

what si the purpose of hiding/unhiding rows or columns?

Answer 1

After grouping the rows or columns, you can collaspe (basically, hide) them by pressing the ... For those who hide / unhide cells for various purposes, such as formatting or just hiding ..

Answer 2

Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set. Other users don't know simple keystroke commands that can streamline hiding and unhiding columns or rows. In this article, I'll explore these techniques as well as discuss two powerful alternatives to manually hide and unhide rows and columns. I'll also discuss how to re-enable an Excel keyboard shortcutthat's disabled in any operating system subsequent to Windows XP.AdvertisementHiding Rows and ColumnsLet's first explore the traditional approaches to hiding rows and columns. Going forward, I'll only explain rows – simply replace the word Row with Column in any menu commands that I describe if you want to hide or unhide columns. First, select the row or rows that you wish to hide or unhide, and then carry out these steps:*.Excel 2007 and later:On the Home tab, choose Format in the Cells section of the ribbon, and then choose Hide & Unhide, and then either Hide Rows or Unhide Rows.*.Excel 2003 and earlier:Choose Format, Row, and then either Hide or Unhide.Tip:Remember, to unhide rows, you must select rows on either side of the hidden set. If you're trying to unhide rows at the top of the worksheet, click on the first visible row, and then move your mouse up to the top of the screen.