Step 4: Click the Format button in the Cells section of the ribbon at the top of the window. The column contains a small number number of values in a large number of rows and several rows with empty cells. Step 3: Click the Home tab at the top of the window. I have a spreadsheet with Autofilter turned on but am getting strange results for one of the columns. This is going to select the entire worksheet. Step 2: Click the cell at the top-left corner of the spreadsheet, between the 1 and the A. For computers with a touch bar, Excel would crash when you press the equals sign to begin writing a. This was affecting computers with the macOS version 10.13 (High Sierra). Step 1: Open the spreadsheet with the hidden rows in Excel 2013. Fixed an issue where the row numbering was reversed and some row numbers or content would appear to be a mirror image of what it should look like.
Trouble unhiding rows numbers for mac bug how to#
You can read this article to learn how to hide rows in Excel 2013. Here you will have options that enable you to either unhide or hide both rows and also. The Format option in Microsoft Excel would be located on the right-hand side of the toolbar. Often times rows are hidden for a good reason, and you may find that displaying the hidden rows makes the spreadsheet difficult to read. Step 1: The first step for unhiding all the rows in Microsoft Excel would need you to go to the Home tab. On the Home tab, click Format from the Cells group. Here are the steps: Select a specific cell or range for adjusting the row height. If you have cells with wrapped text, then try adjusting the row height of the cell or range to make the data visible.
The steps below are going to show you how to unhide all of the hidden rows in Excel 2013. Workaround 4 Adjust Row Height to Make the Cell Data Visible. Often this is done because the cells in certain rows contain irrelevant information, information that is part of a formula and should not be edited, or because it negatively affects the display of the spreadsheet.įortunately it is possible to unhide these rows so that you can view and edit the information contained within them. Are you working on a spreadsheet that you got from someone else, and you notice that the row numbering is not sequential? This is occurring because the person that created the spreadsheet elected to hide some rows.