Hide Rows in Excel Archives

[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)

May 22, 2022 Excel Formulas

Sometimes, while working in Microsoft Excel, we see some rows not showing although they are not hidden. In such cases, the usual Hide & Unhide ...

VBA to Hide Rows Based on Cell Value in Excel (14 Examples)

May 24, 2022 Macros & Excel VBA 2

Sometimes we need to hide some specific rows based on various values from different cells in our large dataset in Excel for better readability. ...

Hide Duplicate Rows Based on One Column in Excel (4 Methods)

May 23, 2022 Excel Basics

Hiding duplicate rows are one of the most frequent tasks that we need to do in Excel. In this article, you will learn 4 methods to hide duplicate ...

VBA to Hide Rows Based on Criteria in Excel (15 Useful Examples)

May 23, 2022 Macros & Excel VBA

Sometimes we need to hide some specific rows based on various criteria from our large dataset in Excel for better readability. Implementing VBA macro ...

How to Hide Blank Rows in Excel VBA (4 Useful Methods)

May 23, 2022 Macros & Excel VBA

This article illustrates how to hide rows that are entirely blank or have blank cells in them using VBA code in Excel. Here we’ll use Excel’s ...

Excel VBA: Unhide All Rows in Excel (5 Practical Examples)

Jan 25, 2023 Macros & Excel VBA

The article will provide you with some basic concepts on how to unhide all rows by using Excel VBA. Suppose, you had a large dataset and you didn’t ...

Excel Macro: Hide Rows Based on Cell Text in Excel (3 Simple Methods)

May 25, 2022 Macros & Excel VBA

In this article, I’ll show you how you can develop a Macro to hide rows based on cell text with VBA in Excel. Download Practice Workbook ...

Formula to Hide Rows in Excel (7 Methods)

May 31, 2022 Excel Formulas

In Excel, while we want to view as many rows or information as possible, at the same time we want to hide some of the unimportant rows. Maybe because ...

Hide Rows Based on Cell Value with Conditional Formatting in Excel

May 24, 2022 Excel Basics

In this article, we’re going to show you 2 methods in Excel to hide rows based on cell value conditional formatting. To demonstrate our methods, ...

How to Unhide Multiple Rows in Excel (9 Methods)

May 24, 2022 Excel Basics

If you are looking for some special tricks to unhide multiple rows in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

Hidden Rows in Excel: How to Unhide or Delete Them?

May 24, 2022 Excel Basics

In this article, we will explain the different attributes of excel hidden rows. While working with a big dataset there might be a lot of hidden rows ...

How to Hide Rows Based on Cell Value in Excel (5 Methods)

May 25, 2022 Excel Basics 4

In day-to-day uses, we need to hide rows based on cell values in Excel to deal with a huge dataset. Typically, an Excel dataset contains numerous ...

VBA to Hide Rows in Excel (14 Methods)

May 24, 2022 Macros & Excel VBA

Sometimes we need to hide some specific rows when using our large dataset in Excel for better readability. Implementing VBA macro is the most ...

How to Hide and Unhide Rows in Excel (6 Easiest Ways)

May 25, 2022 Excel Basics

To develop or sometimes to update the Excel Sheet, we often need to hide and unhide rows in Excel for our further use. In this article, we are going ...

Unhide All Rows Not Working in Excel (5 Issues & Solutions)

May 25, 2022 Excel Basics

In many cases, you have to unhide unnecessary rows to make particular rows more presentable. Unfortunately, you may get troubled if unhiding all rows ...