How to Unhide Rows in Excel on SharePoint: Web or Desktop

How-to basics · Updated November 18, 2026

To unhide rows in an Excel workbook stored on SharePoint, open it in Excel, select the row headers above and below the hidden rows, then choose Home > Format > Hide & Unhide > Unhide Rows. In Excel for the web, you can also right-click the selected row headers and choose Unhide Rows. SharePoint stores and shares the file; the row changes are made in Excel.

What You’ll Need

  • Access to the SharePoint site and the workbook. You need permission to edit the file to change its rows.
  • A current browser for Excel for the web, or the Excel desktop app. The steps below focus on Microsoft 365 for Windows; the Mac and web differences are noted where useful.
  • The name of the worksheet containing the rows. If you are unsure which rows are missing, check for filters or collapsed groups as well as hidden rows.

Step-by-Step

  1. Open the workbook from SharePoint. Go to the SharePoint document library, locate the Excel file, and select it. It will usually open in Excel for the web. If it opens in preview mode, choose Edit Workbook or the available option to edit in the browser. If you prefer desktop Excel, use Open in Desktop App. The wording can vary slightly with your organization’s SharePoint setup.
  2. Confirm that editing is available. Look for editing controls in the ribbon and check that the workbook is not marked read-only. If you have only viewing permission, you can inspect the sheet but cannot unhide rows in the shared original. Ask the file owner for edit access, or use a permitted copy if you only need to work on your own version.
  3. Choose the correct worksheet. Select the sheet tab at the bottom of the workbook. Hidden rows are a worksheet-level setting, so unhide actions on one sheet do not reveal rows on another. If the sheet tabs are not visible, use the sheet navigation controls to find the worksheet, or ask the workbook owner whether the sheet itself is hidden or protected.
  4. Check whether rows are actually hidden. Look at the row numbers along the left edge. If the numbering jumps, such as from 8 to 12, rows 9 through 11 may be hidden. A very small gap or a boundary line between row numbers can also indicate hidden rows. If the row numbers are consecutive but records are missing, a filter or collapsed outline may be responsible instead; see Troubleshooting below.
  5. Select the row headers on either side of the gap. Click the number of the row immediately above the hidden range, then drag down to the number immediately below it. For example, if the row numbers jump from 8 to 12, select row headers 8 through 12. Selecting the headers is important: selecting cells inside the worksheet may not select the hidden rows themselves. For a non-adjacent range, repeat the procedure for each gap.
  6. Unhide the selected rows. In Excel for Microsoft 365 on Windows, go to Home > Format > Hide & Unhide > Unhide Rows. Alternatively, right-click one of the selected row numbers and choose Unhide. In Excel for the web, select the surrounding row headers, right-click, and choose Unhide Rows if the command is available; otherwise use Home > Format > Hide & Unhide > Unhide Rows. In Excel for Mac, select the row headers and use Home > Format > Hide & Unhide > Unhide Rows, or use the row-header context menu.
  7. Reveal rows at the top or bottom of the sheet. If row 1 is hidden, there is no row above it to select. Click the Select All button at the top-left corner of the grid, where the column letters and row numbers meet, then use Home > Format > Hide & Unhide > Unhide Rows. The same whole-sheet selection can help when you do not know which rows are hidden. Be aware that it unhides every hidden row on that worksheet, not just one range.
  8. Check the result and allow it to save. Confirm that the missing row numbers and expected contents are visible. Excel for the web generally saves changes to SharePoint automatically; wait for the saving indicator to finish before closing the tab. In desktop Excel, save the workbook with Ctrl+S on Windows or Command+S on Mac. If several people are editing, allow time for the change to sync and check that you are working in the shared file rather than a downloaded copy.

Common Mistakes

Selecting cells instead of row numbers: A selection within the worksheet grid may not include the hidden rows. Use the numbered row headers at the left. If the selection is difficult to make, click the first visible row number, hold Shift, and click the last visible row number that borders the hidden range.

Assuming missing records must be hidden: Filters and collapsed outline groups can make rows disappear without using the Hide command. Unhiding rows will not clear a filter or expand a group. Check for filter arrows in the header row and plus or minus controls beside the row numbers.

Unhiding everything without checking: Selecting the entire worksheet is a useful fix for a hidden first row, but it can reveal rows that were intentionally concealed. If you know the affected range, select only the row headers around that gap.

Editing the wrong copy or sheet: A downloaded file, a duplicate in another folder, or a different worksheet may look similar to the shared workbook. Check the file name, location, and sheet tab before making changes.

Expecting a view-only change to update the shared file: If the workbook is read-only, your edits may be blocked or saved as a separate copy. Confirm that the original file allows editing before assuming the shared version has changed.

Tips

If you know the exact range, use the name box to navigate to it, then select its row headers. The name box is to the left of the formula bar and normally shows a cell reference such as A1. Selecting a cell range there can help you reach a distant area, but make sure the final selection includes the row headers before choosing Unhide Rows.

Use the smallest selection that solves the problem. This preserves intentional hidden sections elsewhere in a worksheet and makes it easier to see what changed. If a workbook is used by a team, tell collaborators which rows you revealed; other people may have hidden them to simplify a report or protect a working layout.

When a worksheet contains outline groups, look for level buttons or plus and minus symbols beside the row numbers. A plus sign usually expands a collapsed group; select it to show the grouped rows. This is different from unhiding manually hidden rows, though both can affect which rows are visible.

For a shared workbook, make sure your change has synced before navigating away. In Excel for the web, wait until saving is complete. In desktop Excel, save and check for any sync or upload warning. If another person changes the workbook at the same time, review the visible result after the update finishes.

Troubleshooting

Unhide Rows is unavailable or nothing changes. First confirm that you selected row headers spanning the hidden range, rather than just cells. Try selecting the row immediately above and below the gap again. If the command remains unavailable, the worksheet may be protected. In desktop Excel, check Review > Unprotect Sheet; Excel for the web also provides sheet protection controls on the Review tab when available. You may need the sheet password or help from its owner. Do not try to bypass protection.

The row numbers are consecutive, but some data is missing. Check the header row for filter dropdowns. Open the relevant dropdown and choose the option to clear that column’s filter, or select all values so no records are excluded. A filter can hide rows while keeping the row numbering pattern, so it can be mistaken for missing data. If the data is in a table, check the table’s filter controls too.

A plus sign appears beside the row numbers. The rows are likely grouped and collapsed. Select the plus sign to expand the group, or use the outline level controls near the top-left of the sheet to show more detail. If no outline controls appear, check whether the rows are manually hidden instead.

The rows still look blank after you unhide them. Check whether the rows have a very small height. Select the row headers around the affected area, then use Home > Format > Row Height and enter a reasonable value, such as 15, if the height is set too low. Also check whether cell contents are white, formatted to blend into the background, or covered by another display issue; unhiding changes visibility, not cell contents or formatting.

You cannot edit or the change does not appear for others. Confirm that you have edit permission and that you changed the file in the SharePoint library, not a local download. In desktop Excel, check for an upload or sync error and save again when connected. In the browser, wait for the saving indicator; if it remains stuck, avoid making repeated conflicting edits and ask the site or file owner to check access and sync status.

Frequently Asked Questions

Can I unhide rows in Excel for the web from SharePoint?
Yes. Open the workbook in Excel for the web, select the row headers around the hidden range, then use the row-header right-click menu or Home > Format > Hide & Unhide > Unhide Rows. Your permission level must allow editing.

Do I need to download the workbook first?
No. You can unhide rows directly in Excel for the web, and the change is saved to the SharePoint workbook when syncing completes. Opening it in desktop Excel is optional, but make sure you are editing the shared file rather than a separate download.

How do I unhide the first row?
Select the Select All button at the corner between the column letters and row numbers, then choose Home > Format > Hide & Unhide > Unhide Rows. This selects the whole worksheet and reveals all manually hidden rows on that sheet.

Why do rows disappear again after I unhide them?
A filter may still be active, a grouped section may be collapsed, or another editor may have changed the workbook. Clear the relevant filter or expand the group, then check that the shared file has finished syncing. If the rows are manually hidden again, ask collaborators whether the layout is being changed.

Will unhiding rows change or delete their data?
No. Unhide Rows changes whether the rows are displayed; it does not remove their contents. If the data itself has been deleted, filtered out, or replaced, unhiding alone will not restore it. Check the workbook’s version history or contact its owner if you need an earlier version.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.