#Add in for zooming on excel on mac how to#
#Add in for zooming on excel on mac for mac#

The first option, Р Р†Р вЂљРЎС™Touch Bar shows,Р Р†Р вЂљРЎСљ lets you decide what the touch bar shows. In the Р Р†Р вЂљРЎС™KeyboardР Р†Р вЂљРЎСљ tab of this section, which will open by default, youР Р†Р вЂљРІвЂћСћll find the options related to the touch bar. Either way, to get started you need to head to System Preferences, then to the Keyboard section. Maybe youР Р†Р вЂљРІвЂћСћre not a big fan of the App Controls, and would prefer to always see the expanded Control Strip.

#Add in for zooming on excel on mac how to#

How to Hide The Control Strip or App Controls To see these, simply hold the Р Р†Р вЂљРЎС™fnР Р†Р вЂљРЎСљ key.Р вЂќР вЂћll of this is basic, but itР Р†Р вЂљРІвЂћСћs important to understand before you start customizing things. ThatР Р†Р вЂљРІвЂћСћs about all the touch bar can do, save one more trick: the old-fashioned F keys (F1, F2, etc.). Microsoft Word, meanwhile, gives you exactly the sort of buttons youР Р†Р вЂљРІвЂћСћre used to seeing in a Microsoft Word toolbar.Р вЂќР вЂћnd some applications, mostly older ones, show nothing at all here. Safari gives you back buttons, a search bar, and a new tab button, for example. This space is used by whatever app is open, to show basically whatever that application feels is important. ItР Р†Р вЂљРІвЂћСћs possible to make this the default, though (more on that later).Р вЂќР вЂЎor now, letР Р†Р вЂљРІвЂћСћs talk about the rest of that empty space, which Apple refers to as App Controls. Most users will only see it when they specifically expand the Command Strip. Save the template.This is called the Expanded Control Strip. Set the File Format field to Excel Macro-Enabled Template (.xltm). Note the path and go back to File > Save As. If you have trouble finding this you can exit out of the Save As and go to File > Save as Template and it will navigate you to the correct Library area where you can then find the Startup > Excel folder. For me this was a Users > username > Library > Group Containers > UBF8T346G9.Office > User Content > Startup > Excel. Navigate to your Excel startup directory. I'm not sure if this is necessary or not, but I did it based on some other documentation I found.Р вЂќР’В¬lick File > Save As. In my case I simply changed the zoom to 150%. Make the adjustments you need to make to the template. Open a new Excel document or existing template. I finally found the solution in this support article from Microsoft under the 'Use a custom template for all new workbooks' section:

#Add in for zooming on excel on mac for mac#

I was struggling with this for Microsoft Excel for Mac (Office 365, Version 16.38, around May 2020). You should now find the default workbook has all the customisations you made at Steps 6 & 7.

xltx extension at the end of the file name, then manually remove the. ( Note: when saving the file, if Excel has placed the. Save the workbook as an Excel template, making sure you use the name 'workbook', and make sure it's saved in the xlstart folder you created at Step 1.While you're at it, you can also customise a whole heap of other attributes if you like.Open a new workbook and customise your Zoom setting to 150%.

For open all files in set the xlstart folder you created at Step 1 as the path.

Go to Preferences > General > At startup.

You can create this folder anywhere, but I prefer doing it within the Documents folder.

On your Mac create a new folder called 'xlstart'.

In the interests of providing alternatives, I thought I'd share my preferred method as well: I've also seen a number of different ways people have used to achieve a totally customised default workbook. There is a lot of confusion around how to do this, not just because it's changed from Excel 2011 to Excel 2016, but also because the process has even changed during Excel 2016's lifecycle.

Add-in for zooming on excel on mac