(This method will not work if you've typed in the column or row identifier.)Ĭlick the Home tab and in the Cells group, click Format > Hide and Unhide and pick either Hide Rows or Hide Columns. Right-click the selected column or row you want to hide and choose Hide. Once you make your selection(s), follow one of these two methods to hide the columns or rows. (For more, check out our guide to the Excel name box.) For example, if you want to hide the second row, for type B2. To do this, you need to press ( CTRL + SHIFT + 9 ) keys and it will unhide the hidden rows that intersect the current active cell.
#Unhide rows in excel for mac how to
Hope you understood how to unhide all the rows and rows at once. Select multiple adjacent columns or rows: Click the first column or row, hold the Shift key, and click the last column or row. Select Unhide option to unhide all the rows at once.
:max_bytes(150000):strip_icc()/01-RowsHighlighted-5c3f8a8cc9e77c0001ca0a5d.jpg "unhide rows in excel for mac")
Start by selecting the column(s) or row(s) you want to hide. Right-click and select 'Unhide' from the popup menu. Fortunately, Microsoft Excel makes it easy to do this. Question: How do I unhide a row that has been hidden in Microsoft Excel 2011 for Mac Answer: Select the row above and the row below the hidden row. If you're dealing with a data-heavy spreadsheet, sometimes it's helpful to hide or unhide rows and columns to better see the information you need to analyze, rather than deleting the row.
0 kommentar(er)
