How do you hide sheets in excel based on cell value Oct 31, 2023 · One easy way to hide rows based on cell value is to create a filter for the data group. Whether you’re tracking sales, organizing team tasks, or keeping tabs on your personal budget, it offers a ton of features to make life easier. Below, I’ll show you how to automatically check whether a cell has a zero value and then apply conditional formatting to those cells. Sep 4, 2018 · 0 I recently created a company excel workbook that used to have an a lot of rarely used columns/cells and was tasked with making it simpler but still universal. To make zero cells empty, follow these steps: In the Ribbon go to File > Options. for example if B2=1, then i want Column 5 to 8 Nov 16, 2025 · In general, Excel’s conditional formatting is used to highlight a cell based on its own value. Say you have the following data set with zero values in several cells. Aug 2, 2024 · This article demonstrates how to hide formulas in Excel until data is entered. Improve your real estate models fast—no coding experience needed. By doing so, once you input a desired range or criteria to filter, the irrelevant data will be hidden automatically. I have made a macro for Excel sheet, but here it works ISBLANK() in excel is a built in function to check for what it states. Suppose you have a data sheet where all Conclusion In conclusion, hiding rows based on cell value in Excel is a valuable skill that can help you organize and analyze your data more effectively. Apr 28, 2024 · Use dropdown menus to hide and unhide Excel tabs with simple VBA. My understanding is that the code needs to go on the sheet tab. As with most features in Excel, there are at least two ways for you to do this. Select ‘Change with rules…’ and add your conditional formatting preferences. Or maybe it has to be exactly a change from 13 to 10. $ is included so if you move over to another column, it still reflects column E. You can also select nonadjacent ranges or the entire sheet. Feb 20, 2025 · Learn how to hide cells in Excel based on conditions. I am trying to create a private sub that will hide or show sheets with matching names based on the cell value "View"/"Hide" EX: (LIST) 1 View 2 View 3 Hide 4 Hide 5 View *How to Hide Rows Based on Cell Values In Excel*Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. This tutorial provides step-by-step instructions & code examples To hide or unhide a specific worksheet tab based on a cell value in another worksheet, the following VBA code may do you a favor, please do as follows: 1. You can do this by setting up a conditional formatting rule or using a formula to define the criteria for unhiding rows. Learn simple filtering and automated scripting to focus on key data and improve spreadsheet clarity. Download the sample workbook and enjoy learning with us! Mar 15, 2023 · Fortunately, Microsoft anticipated these challenges when it developed Excel and included tools you can use to locate the information you need by hiding the rows you don’t need to see based on their cell value. if cell A4 match with M28 for any sheet then should just show this How to hide rows based on cell color in excel? In this advanced excel tutorial, I'll explain how you can hide multiple rows at once based on the cell color. Note I've also included a data validation Jun 14, 2024 · Learn some simple and effective ways to hide columns in excel. May 9, 2023 · Yes, you can use 9 Quick and Easy Ways to Hide Rows in Excel to hide a group of rows based on a specific value. That hides the 0s by changing the font color of the selected cells. That said, the only way I can think of doing this is via a Worksheet_Change macro which I've code on the attached. Feb 8, 2024 · Hello, very new to VBA so apologies if this is a very simple answer! I have an excel sheet (made by someone else) that runs a macro that gives a new row a number and creates a new worksheet with the same number as you'll see in the image. However, it is not practical for hiding many rows at once. In the spreadsheet below, there are three columns: Name, InvoiceId and Paid. How to hide worksheets. Apr 4, 2011 · I want to show or hide 3 different charts based on the cell value in G20. They hide and unhide sheets based on their tab color. May 17, 2025 · In summary, the ability to auto hide rows based on cell values within spreadsheet applications like Microsoft Excel and Google Sheets is a powerful tool that can dramatically improve data organization and accessibility. Hide Rows Based on the Value of a Cell In Excel, you can use filters to hide rows in a table. Feb 28, 2023 · Do you know any other easy ways to hide rows based on cell value in Excel? Let us know in the comments! Aug 6, 2024 · In this article, we learned how to hide cells in Excel using different ways, we covered every possible way to hide cells in Excel. One last one you may be able to help me with. Feb 28, 2023 · Do you know any other easy ways to hide rows based on cell value in Excel? Let us know in the comments! If you have a sheet that contains confidential information, such as employee salaries, you can hide the values of those cells by using a custom number format. I have a data validation list in G20 that has 3 options, Estimate, Goal, or Actual cost. Continuing up to number 250 in A6 showing all rows up to row 258. This tutorial provides step-by-step instructions for both real-time and macro-executed hiding. e if the cell value us "yes" it is visible, if it is "no" it is hidden. : Based on the cell value in C3, I'd potentially like rows 5 to 23… Jun 23, 2015 · There may be times when you want to hide information in certain cells or hide entire rows or columns in an Excel worksheet. Additionally, you can group related data together to quickly identify patterns and trends. To see how this works,…. So, I created a set of macros to automate the task. it should be hidden when open file except sheet MAIN which search for specific sheet in cell A4 . The method you choose to delete the rows will depend on how your data is structured and what’s the cell value or condition based on which you want to delete these rows. That in itself isn't the most difficult part, but I'm having troubles with the loop as I need to hide 300 rows based on 300 cell values individually. What if the value was 13 and selected 9? Maybe you meant hide 2 to 14 if the selected value is anything less than what it was before. Place the code in worksheet D. Jun 9, 2015 · My question relates to this post, but with different formula criteria: How to hide formula results until conditions are met. Automate tedious tasks, create focused reports, and boost your spreadsheet efficiency easily. Apr 18, 2022 · Currently I'm working on Excel sheets whereas I need certain columns to be hidden based on cell value. The macros I wrote are a very simple solution. In this tutorial, I will show you ways to hide zero values in Excel and one method to select and remove all the zero values from the dataset. Here we’re talking about hiding individual cells or ranges. i. May 28, 2008 · I would like to have certain sheets be hidden or shown to the user, based on the value in a drop-down list. Jul 31, 2019 · This process can be time consuming if it's something you do every week or month. Jul 3, 2024 · 2 quick methods in Excel hide rows based on cell value conditional formatting using triple semicolon and white text. Apr 25, 2018 · I see how you hide rows based on the content of a cell. I made a similar checkbox inside a sheet to hide extra columns. On the Format menu, click Cells, and then click the Protection tab. Set code to run with changes on your sheet. Apr 22, 2023 · Hiding rows in Excel based on a cell value means making certain rows in a worksheet invisible, based on the value in a particular cell or range of cells. I am able to accomplish this manually with filters but it does not automatically show the row again if the value changes. It’s another case of Office having an official and unofficial hiding option. Hiding rows based on chosen value Hi! I'd like to make a script that hides/shows rows based on chosen value. Nov 15, 2025 · A simple INDEX-MATCH formula handles single criteria, but when you need to match both rows and columns with multiple criteria, you need more advanced formulas. For the time being, as a workaround, you can keep your formulas in another (separate) Google Sheets file (a copy of your original file) and import the formulas to the Sheet in which you wish to hide the formulas. *How to Hide Rows Based on Cell Values In Excel*Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Jan 2, 2019 · I'm trying to hide a sheet in an Excel workbook based on the contents of any of the cells in a given range. for example if B2=1, then i want Column 5 to 8 Jul 17, 2024 · How to Hide Rows in Excel Based on Cell Value Hiding rows in Excel based on a cell value is a great way to keep your worksheets tidy and only display relevant data. Follow the steps for easy implementation and enhance your Excel skills! #excel #excelTips”. EX In the sheet "EquipmentList" if B2 = "No" then hide Row 5 in sheet "A_Summary". A step-by-step guide for dynamic data management. To hide a row or column, select a set of rows or columns, right click, and choose ‘Hide’. Download the practice workbook and practice. I was able to create a checkbox with VBA code and when the box is checked it will show Sheet X. Aug 19, 2019 · No it is not possible to hide cells without hiding the entire column or row in which it is found. Feb 17, 2025 · Discover how to hide rows in Google Sheets based on cell value. What syntax do I use to unhide the selected sheet? Thanks Private Sub Worksheet_Change (ByVal Target As Range) ' Has the cell with the dropdown changed? May 9, 2023 · Are you looking for ways to keep confidential data safe in Excel spreadsheets? Discover all the tips and tricks to hide cells in Excel and protect your data in an efficient way. Discover methods to tidy reports and focus on key data with step-by-step guidance. Starting again with row 9 being the first row, so if number 1 is in the A6 cell then row 9 is shown, if number 2 is in A6 then rows 9 and 10 are shown. Generating Fillable Forms Unlike Excel Hide Rows Based On Cell Value In Another Sheet printable forms, fillable forms, customers can fill out details straight on the electronic paper. Free Downloa Excel Conditional Formatting with Formula | Highlight Rows based on a cell value 5 Excel Drop-Down Techniques Every Professional Should Know The XLOOKUP trick nobody talks about (and it's GENIUS) Feb 20, 2025 · Learn how to hide cells in Excel based on conditions using AI. Feb 17, 2025 · Google Sheets is a fantastic tool for managing and analyzing data. Jun 16, 2020 · 0 I'm trying to hide/unhide rows in "Output" sheet conditional on cell values in "Input" sheet. Aug 3, 2025 · Conditional formatting is a built-in feature in Excel that enables you to apply formatting based on specific conditions, such as cell value. For example, if cell A14 equals 1 then the combo Box needs to be used; otherwise it is irrelevant and should not be used. In this tutorial, I will show you six examples of using VBA to hide rows based on cell values. Hiding rows using VBA is fast and efficient. Note: You should provide an apparent reason for hiding rows in Excel, especially when collaborating with others Oct 30, 2019 · Now, I want to be able to dynamic hide or unhide sheets based on value In column “B” (or any other column on this “Workbook content” sheet). 4 days ago · Hiding Zero Values with Conditional Formatting You don’t need to delete every zero value to hide it in Google Sheets. Topic: Excel Macro - How to Automatically Hide Columns based on Cell Value Scenario: You want to automatically hide columns/content when you select certain value in a specified cell Function May 7, 2019 · Hi all, I'm very sorry if this has been answered elsewhere, but I'd like to hide a select number of rows based on a cell value and perform this several times within a sheet. To do this, you can use Excel’s built-in filter function or write a simple VBA script. May 26, 2010 · Hello, You can hide the column or hide the formula (if applicable) in the column. Topic: Excel Macro - How to Automatically Hide Columns based on Cell Value Scenario: You want to automatically hide columns/content when you select certain value in a specified cell Function Apr 3, 2023 · Hide Zeros – Excel Options In the Excel Options, you can disable showing zeros for zero values for a worksheet or for a whole workbook. May 21, 2024 · Hi, I am trying to write a line of code to that will hide rows in a summary table based on a Yes/No reference in another sheet. To start, download this Excel workbook we’ve created for you. Let's say I have two sheets - "Sheet1" and "Sheet2". Looking to simplify financial reporting in Excel? 👉 Join our Jet Reports Training and learn to create real-time, dynamic reports with confidence. This particular technique requires VBA code which I supply via the link above. Jan 29, 2014 · Hi All, I am in need of a macro to hide worksheets that do not match a certain cell value (which I have range named) in the "input data sheet". Ie. if cell A4 match with M28 for any sheet then should just show this Topic: Excel Macro - How to Automatically Hide Rows based on Cell Value in Each Row Scenario: You want to automatically hide columns/content when you select certain value in a specified cell May 13, 2013 · I am looking for VBA to Hide Rows (37:38), Based on value ("No") of a cell (D26) in another worksheet (Control Center). If this value matches cell value on the other worksheets, then hide all other worksheets and keep the "valid" worksheet visible NVS_SCN is the range name that needs to be compared to the value in P4 of worksheets 2 thru 4 Example: NVS_SCN (located on 79 Likes, TikTok video from Xybernetics247 (@xybernetics247): “Learn how to efficiently hide Excel sheets based on cell values with VBA. How to unhide worksheets using VBA. Select the range of cells whose formulas you want to hide. A user can specify a condition in the formula and Excel will hide the corresponding rows that meet that condition. Sep 29, 2024 · I created 365 worksheets that are numbered 1 - 365 On the main page (LIST) there is a drop down selection box with "View" or "Hide" as an option. Jun 23, 2015 · There may be times when you want to hide information in certain cells or hide entire rows or columns in an Excel worksheet. Feb 20, 2025 · Discover how to hide cells in Excel based on conditions using ChatGPT. Learn to hide (or unhide) worksheet tabs or workbooks in Excel. You can use Conditional Formatting to make the cells appear blank by using the custom format of ;;; which will show nothing in the cell but the formula bar will show the value. This guide provides an easy-to-follow, step-by-step tutorial on how to achieve this. I have a main Index that has a column that has G2:G30 for the range of values to indicate if the sheet will be shown. Discover three effective methods, from filters to automation, to save time and focus on key data. For example I have a Jul 6, 2024 · This article illustrates several examples to hide or unhide columns in Excel based on drop-down list selection. But what happens when you need to streamline your view and focus only on specific data? That’s where hiding rows based on cell values comes into play. Mar 16, 2021 · How can I hide various Excel sheets in an Excel document based on a cell's value using a drop down data validation list? I tried right clicking a sheet and selecting 'view code' and pasting the following code into the pop up Microsoft Visual Basic for Applications window: Oct 25, 2006 · Re: Unhide Sheet Based On Cell Value Contents You could use this, it will unhide the shet specified In A1 and hide the others. Sep 24, 2019 · I do not use all of them all the time, and so I want to hide unused ones at the time based on what i'm working on. This list should contain the criteria for which you want to unhide rows. Discover easy methods like AutoFilter and advanced VBA scripts to streamline your data analysis. Identify the rows to unhide: Next, identify the rows that you want to unhide based on the selection from the drop down list. For example I have a May 25, 2016 · I'm looking for code that will hide one or more sheets based on a cell value in Sheet1. I need a code to hide or unhide each worksheet depending my declaration to a cell. After making the form layout, you should include interactive areas where individuals can input their details. However, you can use a formula to format an entire column based on the value of a different column. This is referred to as Conditional Hiding. Step-by-step instructions included. Jul 28, 2024 · In this article, I’ve explained 4 ways to hide duplicates in Excel. If you have a sheet that contains confidential information, such as employee salaries, you can hide the values of those cells by using a custom number format. By using conditional formatting to hide columns, you can automate the process and avoid manual work. How to I hide sheets 2, 3, 4, and 5 based on a different cell in sheet 1 being YES / NO? This is what sheet 1 looks like in columns A and B respectively. ×Sorry to interruptCSS Error Jul 24, 2024 · Greetings, My excel file has 5 sheets. 👍 It’s a straightforward process and we’ll show you how to do it in this Excel tutorial. Sheet1 displays when the file is opened. Hiding rows in Excel based on cell values is a useful feature that can help you manage and organize your data more effectively, while also improving the security and clarity of your spreadsheets. Conserve the file in a fillable style such Aug 29, 2024 · Whatever the reason, learning how to hide formulas in Excel is important. Each of these section will evaluate a "Yes" or "No" value in different cells and show/hide the next 15 rows in the same sheet, show/hide rows Sheet2, and hide a certain worksheet entirely (ranging from Sheet3 to Sheet 30). Free Downloa Feb 20, 2025 · Learn how to hide cells in Excel based on conditions using AI. For example, if I enter "A" in cell A1 (or if this cell has no entered value), I want to have rows 3-4 hidden. Discover key methods today. If cell D26 in worksheet "Control Center" is blank or "Yes", I do NOT want hide the row. I hope that helps. How do I hide rows in Google Sheets based on cell value? In Google Docs, open a spreadsheet, select a group of cells, and click the icon to change the cell background. Using vba code, how do I display a specific hidden sheet base on cell value? I use vba to hide/unhide sheet rows. Jul 19, 2016 · Based on the drop down selection, a tab becomes visible to the user and 2 specific other tabs get hidden. #dax #powerbi #except #sqlserver #excel #dat May 20, 2023 · Learn how to easily hide rows in Microsoft Excel based on a cell’s value using our step-by-step guide. Hide Sheets by Name Hide Sheets with a Specific Word in the Name Hide Sheets Based on Cell Value Hide Sheets Based on Tab Color Make the Sheet Very Hidden (Cannot Be Unhidden by User) Check If the Worksheet is Hidden VBA Codes to Unhide Sheets Unhide Sheets By Names Unhide All Hidden Sheets Unhide Sheets With Specific Words in the Name Apr 20, 2018 · Ultimately, Excel formula belongs to the Cell or Cells so that in other words I can say Yes on the basis of the Formula's result (which is a cell value) you can Hide or unhide one or multiple worksheets. VBA macros are a more advanced method for hiding columns in Excel. Occasionally, you may want to hide entire rows, columns, or even worksheets all based on some criteria that may or may not be present. Suppose you have a dataset as shown Apr 11, 2022 · Something a little less obvious is how to hide an individual cell within an Excel workbook. How to hide rows based on cell color in excel? In this advanced excel tutorial, I'll explain how you can hide multiple rows at once based on the cell color. Unchecking it hides Sheet X. Select the Hidden check box. Aug 5, 2025 · To make your worksheet more efficient and effective, you can optimize it by hiding rows based on a cell value in Excel. By applying a custom number format, you can hide the values of those cells on the worksheet. Jan 23, 2024 · Hello, I'd like to hide a select number of rows on sheet 2 (Civil Test) based of a drop down data validation cell value from sheet 1 (Pre Con Checklist) and perform this several times within sheet 2 (Civil Test) . May 24, 2022 · Im in need of help with a form im doing on excel, i need a code to make rows hide and unhide based on cell value from a data validation list. For example, if B1=“Hide”; B2=“Hide”; B3=“Show”; B4=“Hide”; B5=“Show”; B6=“Show” then sheets with name “1”, “2”, “4” should be hidden and other sheets (“3 Nov 12, 2018 · This video demonstrates how to hide multiple excel sheets on the basis of the selected value in a drop down list. Nov 6, 2024 · Learn to hide or unhide Excel sheets based on cell values. Jul 11, 2019 · Thank you. How to hide multiple Excel worksheets at the same time using Excel, VBA and Shortcut methods. Ive found some online but they dont work. Suppose you have a worksheet that contains confidential information, such as employee salaries, that you do not want a co-worker who stops by your desk to see. Learn how to automatically hide rows in Excel based on cell values using filters, formulas, and VBA. Creating them resembles forms but needs some extra actions. I need this to happen for multiple sheets. Maintenance on this will be a bear if someone adds sections. Deleting the cell clears it, but you can no longer use its contents for formulas. Conditional formatting is a great way to do this, as it allows you to highlight cells that meet certain conditions automatically. ×Sorry to interruptCSS Error In Excel, you can simplify the view of your data by hiding rows. How to use the Case function in VBA. May 21, 2020 · To hide or unhide a specific worksheet tab based on a cell value in another worksheet, the following VBA code may do you a favor, please do as follows: 1. Or perhaps you multiply the values in a range of cells by the value in another cell that you do not want to be visible on the worksheet. Learn how to hide rows in Excel based on specific cell values using filters and VBA. Whether you are working with a large dataset or simply trying to focus on specific information, knowing how to hide rows based on cell value can save you time and effort. Nov 12, 2024 · Based on the first 2 examples, the logical outcome if they went from blank to 10 would be to unhide rows 2 to 11, so why hide 12 to 14 is a bit of a mystery. The cell value from sheet 1 (Pre Con Checklist) is a drop down data validation cell with the only options being Y or N. Improve your Excel skills with this useful tip. So for example, I would like to hide row 12 in "Output" sheet if cell B6 in "Input" sheet contains a Learn how to hide columns in Excel based on cell values using VBA macros. Aug 25, 2016 · Dear All Excel Experts, I would like to seek help from you to provide me a VBA that will hide and unhide the specific sheets i want. To exclude cells with certain values, set an appropriate filter. You can follow any of the methods depending on your need. Feb 12, 2025 · Learn how to hide rows in Excel based on cell values. Hi, thanks for reading! Sheets Rookie here, I am looking to have a sheet AUTOMATICALLY hide and unhide entire rows based on the value of a specific cell in that row. Select the cells. Hide and Show worksheet based on cell selected Value. And if the dropdown changes, it clears a certain column that the user would input the data in, hide the column and make visible the tab the user now selects. May 9, 2023 · The “Hide” function in Excel is a simple way to hide individual rows or ranges of rows. If cell T39 = 1 the shape should be visible and for any other value the shape should be hidden. every sheet contain reference no in cell M28 . I have it working, but I feel I've coded it poorly. Jul 11, 2019 · I am trying to create a workbook which hides inactive sheets based on a cell value on the front sheet. In column J the 'Status' column there's a drop down list where you can choose a few different options. Feb 9, 2025 · In this tutorial I will show you how to hide rows in Google Sheets based on cell value. To avoid confusion I would like to set up a VB script that has it hidden by default and Hide Sheets by Name Hide Sheets with a Specific Word in the Name Hide Sheets Based on Cell Value Hide Sheets Based on Tab Color Make the Sheet Very Hidden (Cannot Be Unhidden by User) Check If the Worksheet is Hidden VBA Codes to Unhide Sheets Unhide Sheets By Names Unhide All Hidden Sheets Unhide Sheets With Specific Words in the Name Apr 20, 2018 · Ultimately, Excel formula belongs to the Cell or Cells so that in other words I can say Yes on the basis of the Formula's result (which is a cell value) you can Hide or unhide one or multiple worksheets. Excel doesn't even allow us to unhide multiple sheets at the same time. However, don't do that on the number, as that would always reference that number only, rather than following down to E10, for example, if you copy the formula down the row. The simplified view can help you focus on the necessary data for your task. Automate sheet visibility changes for more dynamic and responsive workbooks. Go the worksheet which contains the cell value you want to hide another sheet based on. Oct 30, 2024 · Learn how to hide or unhide a Command Button in Excel based on a specified cell value using VBA. Hide & Unhide by Tab Color There are many ways to solve this problem. Sep 18, 2022 · There are two ways to hide Excel cell contents that you don’t want visible, but still available able to use in calculations. For example if cell A2 (in Sheet1) = 2, then hide Sheet5 and Sheet6; again if A2 = 3, then hide Sheet6. Here's the setup for a spreadsheet to calculate the percentage discoun Aug 19, 2019 · No it is not possible to hide cells without hiding the entire column or row in which it is found. In this case, cells with zero values will be empty. com Dec 29, 2020 · I've got an excel sheet with 5 sheets, sheet 1 acting as the main sheet. However, the formula bar still contains the value. Example - I have a worksheet named 'Inputs', on which there is a drop-down box with two options - Scenario 1 and Scenario 2. Using a formula to hide rows based on a cell value is a useful method for hiding multiple rows at once. You can use the filtering option to filter the rows based on the specific value and then hide the filtered rows. This tutorial demonstrates how to hide rows based on values they contain in Excel and Google Sheets. You won’t have to worry about data leakage again! Overview of hiding cells in Excel Hiding cells in Excel: A Comprehensive Guide When working with large Excel spreadsheets, hiding cells can help organize data and Aug 7, 2024 · This article discusses 14 effective examples of how to hide rows based on different cell value in Excel with VBA. Is it also possible to use the same macro to set the print area of the document so that it prints the rows that are still active? Jan 4, 2011 · Hi kc27315, You should consider changing the title of your thread to be more descriptive of your problem to help others searching for an answer to this (or a similar) issue - something like "Hide Or Show An Image Based On A Cell Value". May 30, 2021 · hello I have about 60 sheets . Instead, use conditional formatting. Worksheet names appear on the tabs along the bottom of a workbook. By following these steps and customizing the code to fit your specific needs, you can efficiently show or hide worksheets in Microsoft Excel based on the content of a particular cell See full list on exceldemy. In this tutorial, I will show you multiple ways to delete rows in Excel based on a cell value or a condition. It allows you to highlight a cell if a different cell contains a certain text or numeric value. I would like to hide rows on a sheet based on a number in a cell (A6). There are about 100 sheets and I can't do this procedure every time I add a new sheet. Jul 2, 2024 · Learn how to effortlessly pull data from another sheet in Excel based on cell value with this step-by-step guide, ensuring efficient and accurate data management. Learn how to hide cells, rows, and columns in Google Sheets to create cleaner reports, protect data, and focus your audience. By default, MATCH finds the position of your lookup value and INDEX uses that position to return the corresponding value. In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. Apr 20, 2012 · I want to show and hide shapes on a sheet based on the value in a cell. Nov 29, 2007 · I have a combo box that is only relevant if a certain cell contains a certain value. Hide cell values When you hide a value in a cell, the cell appears to be empty. Apr 20, 2018 · Tried to follow some advice based on a previous post (VBA code to hide or unhide rows based on a cell value) to create a macro so that I can show/hide certain rows based on a dropdown list. Aug 7, 2024 · This article discusses 14 effective examples of how to hide rows based on different cell value in Excel with VBA. If I enter "B" or "C" in cell A1, I want to have rows 3-4 shown. There are separate options for hiding row, columns or entire worksheets (aka Feb 5, 2022 · It's easy to use filtering to hide rows based on the value in a cell, but how do you hide rows based on the values in two cells? Here are a couple of ideas on how you can pare down your data. Nov 16, 2025 · How to highlight cells in Excel based on a list in another sheet? First, select the range to highlight (B2:B10), and go to the Home tab >> Conditional Formatting drop-down >> New Rule >> Use a Formula to Determine Which Cells to Format. ryhbf pjqgu iaunkcs uas buhkjve muaohor foe tapvb nieh pdaxwp aer vfrz vsna meylz jftj