The blue row numbers indicate you r rows are in filter mode. Try Data> Filter and turn off Autofilter or undo an Advanced Filter.
This of course begs the question “Why do the row numbers become blue?”
The row numbers become blue typically when a filter is applied. In my case, there is no filter applied, nor are there any columns hidden. Was this reply helpful? Sorry this didn’t help. Thanks for your feedback. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.
I ran across this same exact issue with excel and figured out how to fix it! Just remove your filter completely and then add it back and the blue row numbers go back to their default non-filtered color. 🙂 Hope that works for you. It did for me.
Is the cell data always blue in Excel?
No, that is not the case. It is the row number which is showing blue, not the cell data. The row numbers become blue typically when a filter is applied. In my case, there is no filter applied, nor are there any columns hidden.
This of course begs the question “What does the blue color indicate in a cell filter?”
The blue color indicates a filter is hiding rows. Only the visible cells are sorted if you click the sort button. I am an unpaid volunteer and do not work for Microsoft.
Microsoft excel row does not autofit?
You may be unable to use the Auto . Fit feature for columns or rows that contain merged cells in Microsoft Excel. In addition, if the Wrap Text feature is also selected, text is not wrapped automatically. In Excel, you cannot use the Auto. Fit feature on a column that contains a cell merged with cells in other columns.
Why is Autofit not working on my Microsoft Excel 98 version?
For a Microsoft Excel 98 version and a Microsoft Excel 2001 for Mac version of this article, see 179045. You may be unable to use the Auto. Fit feature for columns or rows that contain merged cells in Microsoft Excel. In addition, if the Wrap Text feature is also selected, text is not wrapped automatically.
Can I use Autofit on a row that contains a cell?
You cannot use Auto. Fit on a row that contains a cell merged with cells in other rows. When you use merged cells, manually adjust row height and column width by using the following procedures, as appropriate for the version of Excel that you are running.
Another frequently asked query is “Does Autofit wrap text automatically in Excel?”.
In addition, if the Wrap Text feature is also selected, text is not wrapped automatically. In Excel, you cannot use the Auto. Fit feature on a column that contains a cell merged with cells in other columns. You cannot use Auto. Fit on a row that contains a cell merged with cells in other rows.
How do you unhide rows in microsoft excel?
Unhide all Rows in Excel
Open the Excel document. Click the “Select All” button . Click the Home tab.
How do I unhide hidden rows in Excel?
Click Unhide in the drop-down menu. 1 Hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below 2 Right-click one of the selected row numbers. 3 Click Unhide in the drop-down menu.
How to unhide the cursor in a worksheet in Excel?
If the cursor is in an empty cell, the whole worksheet is selected. But if the cursor is in one of contiguous cells with data, only that group of cells is selected; to select all cells, press Ctrl+A one more time. Once the entire sheet is selected, you can unhide all rows by doing one of the following: Press Ctrl + Shift + 9 (the fastest way).
How do I change the width of a row in Excel?
Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width.
In Microsoft Office Excel 2007 and later versions, click the Home tab, click Format in the Cells group, and then click Auto. Fit Row Height. If your Excel sheet contains merged cells, visit the following Microsoft website:.
How do I show or unhide rows in a group?
To show one or several adjacent rows, select the row above and below the row(s) that you want to unhide. To unhide multiple non-adjacent rows, select all the rows between the first and last visible rows in the group. For example, to unhide rows 3, 7, and 9, you select rows 2 – 10,.