Dec 28, 2020 · Excel freezes when trying to unhide rows Hi everyone, I made the mistake to hide all unused rows (i.e. all the way down to the 1,048,576th row) when I initially created my excel file …

Jan 13, 2016 · Allow resize Columns/Rows and disable hide/unhide Hi, This issue a bit difficult as if we tick on Format columns/rows to allow resize function, Excel will include Hide/Unhide function. Is there …

Dec 17, 2019 · Re: Cannot Unhide Rows after hiding all below, Greyed out The rows are not hidden, they are zero height. Click the top left corner to select the entire sheet. Go to Cells, Format, Autofit …

May 19, 2016 · Re: Unable to unhide hidden rows - except one at a time.. You may have to supply additional information, such as how these rows are hidden.

Dec 7, 2005 · I have blue row numbers and hidden rows that won't unhide but I see no evidence of grouping. There isn't any numbers at the top or anything. I can manually resize the row height but …

Nov 7, 2022 · Hide and unhide rows with buttons Hi, I am working on a form and want to unhide rows with one button and also delete values in the row and hide the rows if a different button is clicked. - I …

Jan 29, 2019 · Re: Cannot unhide rows unless I double click There may be event code within the workbook: try un-protecting the workbook/worksheet. Then save the workbook as a non-macro …

Jun 29, 2024 · Re: Hide/Unhide Rows Based on Row Cell Value Have a look at the attached. There's a macro to open a userform and that's tied to the icon on sheet1. When you click the "Save Copy As" …

Apr 20, 2024 · Re: Using a drop-down to hide/unhide rows and columns You can do this using the activex combobox (use the Developer tab), I sent the style to be just a dropdownlist, and named it …

Jun 27, 2014 · On a sheet titled "Checklist Results," I have 3 rows I need to hide/unhide; these are rows 53-55. I have A53, A54, and A55 set equal to the checkbox formulas (0 or 1) on the Critera Checklist …