Hiding zero values in multiple columns - Microsoft Community
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 ...
If statement in VBA - if cell in one sheet = True then hide column in ...
Jun 23, 2025 · I have a list of column names in one sheet (Criteria) with a check box associated to a cell next to each name and want to have columns hidden in sheet Calls if the boxes are checked. For …
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 menu) --> I want to
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 …
Microsoft Community
Microsoft Community
Excel的单元格变得极小，即使比例放到400%也很小 - Microsoft Q&A
Excel的单元格变得极小，即使比例放到400%也很小 匿名 2023年6月18日 06:36
VBA - Question on Array - Microsoft Community
Dec 14, 2015 · When using Excel VBA to create macros, is it possible to create a single 3-dimensional array instead of two 2-dimensional arrays then copy a selected range.value into the 3-dimensional …
为什么EXCEL表格里面没有内容,但显示文件很大 - Microsoft Q&A
锁定的问题。此问题已从 Microsoft 支持社区迁移。 你可投票决定它是否有用，但不能添加评论或回复，也不能关注问题 ...
Excel的多重合并计算数据区域透视表是否可以选择多个行标签？应该如 …
我了解到您想要在Excel数据透视表设置多个行标签并列显示。 这个网站中有修改数据透视表的教程，我猜测您想要的是其中这两个选项中描述的功能。 设计数据透视表的布局和格式 - Microsoft 支持 期待 …
Tastenkombination: geschützter Bindestrich - Microsoft Q&A
Plötzlich, seit dem letzten Update, geht die Tastenkombination [STRG + UMSCHALT + -] für den geschützten Bindestrich nicht mehr. Diese Kombination ist plötzlich tiefstellen, also eigentlich STRG …