How to Expand All Rows in Excel 2013: A Step-by-Step Guide

Expanding all rows in Excel 2013 is a simple task that involves selecting all rows, right-clicking on one of the row numbers, and choosing “Unhide” from the context menu. This will reveal any rows that were previously hidden and ensure that all rows in the worksheet are visible.

After completing the action, all the rows in the Excel spreadsheet will be displayed. This is useful when you want to view all the data without any hidden rows interfering with your analysis or when you need to print the entire worksheet.


Are you tired of endlessly scrolling through your Excel 2013 workbook, trying to locate hidden rows that are causing you headaches? Maybe you’ve inherited a spreadsheet from a colleague, or you’ve hidden rows yourself for better readability, and now it’s time to reveal all that data again. Whatever the reason, understanding how to expand all rows in Excel 2013 is an essential skill for anyone who wants to master this powerful software.

Why is this important, you ask? Well, hiding and unhiding rows is a common tactic used to simplify data review or focus on specific sections of your spreadsheet. But there comes a time when you need to see the whole picture again. Whether you’re double-checking figures, preparing for a presentation, or simply tidying up your workspace, being able to expand all rows quickly and efficiently is a real time-saver. Plus, it’s a nifty trick that can impress your coworkers or boss!

This article is for Excel users of all levels, whether you’re a seasoned pro or just starting. Let’s dive into the step-by-step process.

Step by Step Tutorial to Expand All Rows in Excel 2013

Before we begin, understand that following these steps will reveal any rows that have been hidden in your workbook.

Step 1: Select all rows

Click on the triangle at the top-left corner of the worksheet to select all rows in the spreadsheet.

This action ensures that any changes you apply will affect the entire sheet, rather than just one section.

Step 2: Right-click on the row numbers

Once all rows are selected, right-click on any of the row numbers on the left-hand side of the sheet.

This brings up the context menu, which provides different options for manipulating the rows.

Step 3: Choose “Unhide” from the context menu

From the context menu that appears, click on “Unhide.”

Selecting “Unhide” will expand any rows that are currently hidden, making them visible again on your worksheet.


Enhanced visibilityExpanding all rows allows you to see all the data in your workbook, making it easier to analyze and work with.
Better organizationWith all rows visible, it’s easier to spot errors or inconsistencies in your data.
Increased productivityYou can work more efficiently when you don’t have to constantly hide and unhide rows manually.


Possibility of clutterWith all rows expanded, your worksheet may become cluttered, making it harder to focus on specific data.
Increased scrollingWith more rows visible, you may need to scroll more to find the information you need.
Risk of information overloadHaving all data visible at once can be overwhelming and may make it more challenging to extract meaningful insights.

Additional Information

Excel is a versatile tool, and while expanding all rows is a fairly straightforward process, there are a few additional tips and insights that can enhance your Excel experience. For instance, if you frequently need to hide and unhide rows, consider using grouping and outlining features to create a more manageable structure. You can also use keyboard shortcuts (Ctrl + Shift + 9 to unhide rows) for quicker access. Remember to save your spreadsheet before making significant changes, just in case you need to revert back to a previous state.

Finally, while we’ve focused on Excel 2013, these steps can generally be applied to other versions of Excel with minor adjustments. So, don’t be afraid to experiment, and always ensure you’re working with a version of Excel that’s updated and compatible with your operating system.


  1. Select all rows in the spreadsheet.
  2. Right-click on any row number.
  3. Click on “Unhide” from the context menu.

Frequently Asked Questions

What if “Unhide” is not an option in the context menu?

If “Unhide” is not available, it means there are no hidden rows in the selected area.

Can I expand specific rows instead of all of them?

Yes, you can select individual rows or a range of rows, then right-click and choose “Unhide” to expand only those rows.

Will expanding all rows affect my data?

No, expanding rows will not alter the data itself, only the visibility of the rows.

Can I use a keyboard shortcut to expand all rows?

Yes, you can use the keyboard shortcut Ctrl + Shift + 9 to unhide rows in Excel.

What if I accidentally expand rows I didn’t mean to?

You can always re-hide rows by selecting them, right-clicking, and choosing “Hide” from the context menu.


Expanding all rows in Excel 2013 is a useful skill that can save you time and help you manage your data more effectively. Whether you’re a beginner or an experienced user, following the simple steps outlined in this article will enable you to navigate your spreadsheets with ease. Remember that while Excel is a powerful tool, it’s also user-friendly and designed to make your work life easier.

So go ahead and unhide those rows; let the data shine in its full glory. And if you find yourself stuck or in need of a quick refresher, revisit this guide as often as you need. Excel is all about making your work efficient, and knowing how to expand all rows is just one of the many tricks to streamline your data management. Happy Excelling!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy