Enable macros on a specific worksheet in excel 2016 for mac

broken image

The Sheet Navigation toolbar is available by default, but the sheet's creator can turn off this display as follows: Simply select a sheet in the list to select that sheet. Excel will display a list of all the sheets in the workbook, with the current sheet checked. Right-click the Sheet Navigation toolbar. You can use the keyboard shortcuts + and + to scroll through the sheets, but with lots of sheets, that can take awhile. Of course, you can click a sheet tab, but if you have a lot of sheets, they're not all visible.

broken image

Moving from sheet to sheet is just as easy, but perhaps not as intuitive.

broken image

There are a number of ways: scrolling,, the Name box, arrow keys, and so on. Moving around in an Excel sheet quickly becomes second nature.