Once selected, go to Excel’s Menu Bar and choose both Format > Column > Unhide and Format > Row > Unhide. Clicking this cell will select all cells in your spreadsheet, both hidden and not. First, click the top-left heading cell that looks like a white arrow pointing to the bottom-right corner. If you need to expand your table, or simply don’t like the new look, you can easily unhide the cells. You’re now left with a spreadsheet that features only cells containing your data, resulting in a much cleaner look. Finally, head back up to Excel’s Menu Bar and choose Format > Row > Hide.This will jump you to the very bottom of the spreadsheet and select all the rows in between. With the bottommost cell selected, press and hold Shift and then press Command + Down Arrow. Similar to the steps above, this time select the first row beneath your data.
Next, we need to deal with the cells below your data.You’ll now see all the cells to the right of your data disappear. With your cells still selected, go to Excel’s Menu Bar and choose Format > Column > Hide. Now we have to tell Excel to hide these cells.This will jump you to the end of the spreadsheet while the Shift key automatically selects every cell in between. We can apply the Unhide Sheet feature to unhide a hidden worksheet at a time in Excel. With the rightmost empty column selected, press and hold the Shift key and then press Command + Right Arrow. Unhide all hidden worksheets one by one in Excel.Because Excel gives users spreadsheets with tens of thousands of rows and columns, we’ll use keyboard shortcuts to quickly jump to the end. Now we need to select all columns from this starting point to the end of the spreadsheet. Select the first column to the right of your data.Elapsed for Year(): 0.109375Īlso note that in addition to this, the dates in the column you're searching are coming through as Variants, it may help to explicitly cast them to dates: If v = Month(CDate(cell.Value)) And intCurrentYear = Year(CDate(cell.Make sure to leave room for expansion, if necessary. Since you likely can't run the benchmark. It doesn't rely on parsing the strings for formatting, so it's much more efficient (and easy to read): Sub Benchmarks()ĭim starting As Double, test As Date, i As Longĭebug.Print "Elapsed: " & (Timer - starting) I would try replacing the calls to DatePart() with calls to Month() and Year() in situations like this - even for non-Mac users. I'm not a Mac user, but it's entirely possible that there's some weirdness around the date functions, particularly those that require formatting to resolve. I'm with on this one, nothing obviously wrong with the code.
If v = DatePart("m", cell.Value) And DatePart("yyyy", cell.Value) = intCurrentYear Then = FalseĪpplication.Goto Reference:=Range("a1"), Scroll:=True 'comparing each column to array of months in current quarter and hiding if false 'loading months of current quarter into an array intCurrentMonth This function works: Sub GANTT_Filter_Show_All()īut this one only hides all the columns: Sub GANTT_Filter_This_Quarter()ĭim intCurrentMonth As Integer, intCurrentYear As Integer, rngDates As Range, cell As Rangeĭim intCurrentQuarterMonths(3) As Integer
#Hide worksheet in excel for mac version 15 windows#
I can only assume Excel for Mac is having a problem with what's in the FOR EACH loop, but I can't figure out what! I'd appreciate any guidance: I need to get this system working on both Windows and Mac. The "unhide all columns" macro works fine the other functions get as far as hiding all columns but not as far as unhiding the ones I want to see.
But when I open the worksheet in Excel 2011 for Mac, the macros give odd results. They were all written in Excel 2013 for Windows (running in parallels on my MBA, if that's relevant) and work fine there. I have a set of macros to hide and unhide columns based on the contents of a specific row.
0 kommentar(er)
