Question: How do I unhide column A in a sheet in Microsoft Excel 2011 for Mac? Answer: Select Go To under the Edit menu. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. Select the Column > Unhide under the Format menu. Now you should be able to see column A in your Excel spreadsheet.
I need to hide subtotals for some fields but not others in Excel for Mac (either 2011 or 2016). I see that this is easy to do in the Windows version by choosing field settings but I don't see the corresponding option on the Mac version.
So I thought I'd use VBA to accomplish this. Unfortunately I'm new to VBA and am not finding success. I used guidance from another website which shows how to suppress ALL subtotals. But I need help customizing this to suppress only certain fields (columns).
If anyone can help guide me that would be most appreciated. Sub NoSubtotals 'pivot table tutorial by contextures.com 'turns off subtotals in pivot table '.PivotFields could be changed to '.RowFields or.ColumnFields Dim pt As PivotTable Dim pf As PivotField On Error Resume Next For Each pt In ActiveSheet.PivotTables pt.ManualUpdate = True For Each pf In pt.PivotFields 'First, set index 1 (Automatic) to True, 'so all other values are set to False pf.Subtotals(1) = True pf.Subtotals(1) = False Next pf pt.ManualUpdate = False Next pt End Sub. Hi Xoconochco, Based on your descriptionI don't see the corresponding option on the Mac version. Hi Xoconochco, Based on your description, your original issue is to hide subtotals for some fields in Mac, am I right? I will move this thread to the more related with forum. They are more familiar with Excel in Mac.
Reference: Thanks for your understanding. Best Regards, Edward We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click to participate the survey. Hi Xoconochco, Based on your descriptionI don't see the corresponding option on the Mac version.