Hiding rows and columns in Excel 2010 and 2013 removes them from the visible window, leaving only a small marker for reference, but doesn't actually delete cell contents. Excel can hide multiple rows or columns to help emphasize the results of a project while hiding calculations or other behind-the-scenes steps. Excel -- and all other Office applications -- can also hide the ribbon menu to provide more usable space on the screen.
Show or Hide Rows and Columns
To hide cells on a spreadsheet, select one or more rows or columns by clicking and dragging on the row or column headings. Click "Format" in the Cells section of the Home tab, pick "Hide & Unhide" and choose either "Hide Rows" or "Hide Columns." Restore the hidden cells by selecting a group of rows or columns spanning the hidden range and picking "Unhide Rows" or "Unhide Columns." You can also select rows or columns, right-click anywhere in the selection and pick "Hide" or "Unhide" from the pop-up menu. While collapsed, cells continue to function normally -- hidden formulas still produce results, and other formulas can point to hidden cells without issue.
Collapse or Expand the Ribbon
To collapse or expand the menu ribbon in any Office 2010 application, including Excel, click the small arrow near the "Minimize," "Maximize Down/Restore" and "Close" buttons on the top right of the title bar. With the ribbon collapsed, clicking a tab shows its contents until you make a selection from the menu or click somewhere in the spreadsheet. In Office 2013, click this arrow to see a list of three options. Choosing "Show Tabs" or "Show Tabs and Commands" switches between the collapsed and expanded states of these elements. The new option, "Auto-hide Ribbon," hides the entire bar until you click near the top of the window and works only in full-screen mode. In either version of Office, except when you have "Auto-hide Ribbon" enabled in Office 2013, press "Ctrl-F1" to quickly expand or collapse the ribbon.
How to Expand All Columns in Excel 2007
How to Expand & Collapse in Excel 2007; How to Expand All Hidden Lines in an Excel Spreadsheet; Comments. 1191591885 Jan 24,...
How to Expand All Hidden Lines in an Excel Spreadsheet
Excel offers users the ability to hide rows and columns on a spreadsheet, making it easier to view the remaining data. If...
How to Disable the Functions of a PivotTable
Microsoft: Expand, collapse, or show details in a PivotTable or PivotChart; ... Excel pivot tables help you organize and sort data easier...
How to Collapse Information in Word Documents
How to Expand & Collapse in Excel 2007; How to Expand & Collapse Text on a Web Page; Print this article; Instructions....
How to Expand an Axis in Excel
When you create an Excel chart, Excel automatically determines the minimum and maximum values for any value-based axes so that the chart...
How to Unhide a Row in an Excel Spreadsheet
How to Unhide a Row in an Excel Spreadsheet. Excel spreadsheets can get quite large, ... How to Expand & Collapse in...