Aug 11, 2014 · VBA to hide cells in excel I am tyring to create macro that will hide cells depending on what data is in the cell. I am currently using this and it is working but I want to be able to …

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 …

Excel Hide Rows When Value Entered I have to develop an excelsheet where a row is hidden automatically when the value is enter. There is 3 condition An example like this: Condition 1 If …

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 …

Jan 24, 2011 · It a value of "--" appears in a given cell of row 4, it will hide a column. If something else is inputted (from a dropdown list) a column will appear dynamically and show the result of …

Jun 23, 2025 · Can I hide the "cells grid" in a spreadsheet? I have made a spreadsheet showing a number of charts - 8 charts on the same page, each chart is full page width and about 40 mm …

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 …

Jun 29, 2011 · I have a macro that will hide any rows in a range that have a zero value in a particular column.. Application.ScreenUpdating = False Dim r As Range, cell As Range On ...

Jun 6, 2011 · 5. Empty a third of the cells on both ranges, same pattern per sheet 6. Remove the empty cells by using the different Shift direction options 7. Save the workbook as C:\Excel …

May 7, 2021 · If you are seeing the formula in the cell then Excel is treating it as TEXT. Change the format of the cell to 'General' (your screenshot shows it to be General) then edit the …