There are a few ways. You can use the Hide options in the menus on the old versions of Excel, under the Rows option on the Format menu. On the newer versions, you'll find it in the Visibility group in the Format options on the cells group. You can also hide a row by reducing its height until it cannot be seen. You can also use the Ctrl - 9 key combination.
The short key to hide a row in MS Excel is Ctrl key and the number nine. The short key to hide a column is Ctrl key and the number zero. You first need to click on a cell in the column or row that you want to hide.
Click home tab, click hide and unhide, click unhide sheet. Click home tab, click hide and unhide click hide sheet.
Yes you can. Ctrl - 9 hides a row. Ctrl - 0 hides a column. Add the Shift key to those combinations and they can be unhidden.
well ,there is a ''row hide'' blues band in belgrade, Serbia
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
Each intersection of a row and column is a cell. So it will depend on which version of Excel you have There are 16,777,216 cells in Excel 2003 and earlier. There are 17,179,869,184 cells in Excel 2007 and after.
It is inserted above it.
When you reduce the row height in excel the row is hidden
Header Row, Banded Row and Calculated Columns make up an Excel Table.
The last row number for Excel 2007 is 1048576.
heading row