
Excel Macro hiding rows based on cell value - Microsoft Community
Apr 29, 2025 · I am trying to create a macro to unhide rows based on a cell value. There will be a location list and for each location entered I want to unhide rows on the next sheet. I have put …
Unable to Unhide Rows - Microsoft Community
Jun 28, 2023 · I'm unable to unhide rows in excel spreadsheets that I haven't protected. Is there a simple explanation for this?
how do I hide rows - Microsoft Community
Apr 30, 2024 · Hi Liz. I am an Excel user like you. To hide a row or rows 1. select the row or rows you want to hide by clicking on the row numbers at the left of the screen. 2. right click inside …
Unhide rows in Excel - Microsoft Community
Jul 3, 2025 · I have been using Excel spreadsheet but have been able to unhide rows. I've followed the right-click, unhide directions. Originally I downloaded the information included in …
Macro to Hide and Unhide Rows based on cell values
Feb 10, 2021 · Macro to Hide and Unhide Rows based on cell values I found this code from someone else and tried to modify it to my needs. I have never messed with macros before so …
Unhide sheet in excel for iPad - Microsoft Community
Jul 3, 2024 · 要在iPad上的Excel工作簿中隐藏工作表,您需要至少打开两张工作表,选择sheet1和sheet4,如图所示,单击sheet4并选择隐藏。 同样,要取消隐藏 Excel 工作簿中的工作表, …
VBA macro to hide/unhide rows based on values in a range
Dec 19, 2014 · Hi! What I'd like to do, is for excel to automatically (without calling the menu to run the macro) apply the following to a certain worksheet: if a cell D1 = "PL" (it's a dropdown …
unhide any hidden rows, run macro, hide the same hidden rows back
Mar 5, 2021 · i have a few macros that fill down data. to ensure that the fill downs are working properly... - All in one code... i need to be able to unhide whatever rows (remember the exact …
Excel formula to sum the product of multiple rows with two criteria
Jan 30, 2024 · Here are the factors: 1. There are multiple people with various rates. 2. The number of hours vary as well. 3. There are two categories of people. 3a. Category A needs a …
i would like to have rows hide/unhide based off of one input cell
Mar 7, 2024 · i would like to have rows hide/unhide based off of one input cell From the research i have done so far i have gathered the solution to this will be VBA. I have next to no experience …