I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. Being able to create new shortcuts for commands, or edit existing shortcuts. I have googled for this and searched the support site for this. Search Community member. When I go to click on preferences, they are greyed out. I've restarted Excel, restarted my MBPro. Signed in and out of MS Office.
Hi all, A short note so that I can remember, and you can find, the template location for Office 2016 on the Mac. Why do I do this?
It may appear, and certainly Google will agree, that your template location is: /Library/Application Support/Microsoft/Office/User Templates/My Templates BTW, you get Library by holding do the Option key and select Go. Without the Option key being pressed you will not see it. However, the correct path is: /Library/Group Containers/UBF8T346G9.Office/User Content/Templates I thought the UBF8T thing might be different for different people but I have checked several different Mac’s and they have the same one.
So now you have the location where you can place your templates and Office will find them. Update:. 3/6/16 – Thanks to Rick I was reminded I had not used the proper slash – should be / rather then. 11/25/15 – Thanks to Ian, you can see below in comments where the stock templates are. Certainly not where one might expect. Much appreciate it Ian!. 9/29/15 – A reader (seen below in comments) asked where the stock templates are stored.
He wanted to remove them to clean things up. A good question and I was not able to answer. Plus, I looked quite hard, and used Google, and nothing was found. I even know some of their file names and no luck. Hopefully someone reading this might be able to help? Michael END.
Indeed, this is where “user templates” are stored. But Microsoft does a disservice calling them templates.
When I store a template there and then call it up later, the file has the name of the template ad with the dot or dot extensions. Most other programs I use — indeed even Word 2011 — templates open as untitled documents that must be renamed. This may seem like a minor glitch, but these documents are not really templates. With this type of file behavior, users could just as easily locate their own “template,” saved as a doc or docx file anywhere convenient for them. Of course, they’d have to be careful to rename the document appropriately. But that’s what you have to do with these Word 2016 non-templates anyway.
I hope this (and other problems) are fixed in the final roll out. But I’m not holding my breath.
Thanks so much for this column! Regarding the workgroup vs. User templates: I usually work with Word for PC but I believe this is the same for Mac or PC. Word comes with a default location for user templates as you explained, and it has the ability to set any location you want as the Workgroup templates folder.
I would not set the workgroup templates folder to the same location as the user templates folder as someone else suggested because, like you say, they’d both be looking in the same location. Typically a business organization that has “firm” templates set up (maybe letter, memo, fax, proposal, etc.) will put all of their templates in the Workgroup templates folder, or in sub folders of it.
That way they can add, change, rename, and delete the firm templates without affecting anything end users are doing in their “My templates” location. In both the user/my templates and workgroup templates folders, if you create sub folders and put templates in them, they should show up as category/tabs when you go to create a document from “my templates.” The Word default templates that come with word are somewhere else altogether, as you discussed in this thread.
I have never removed them but it is my understanding that, with the PC version of Word at least, you can “uninstall” them or tell word not to include them as you’re installing Word. Though it sounds as if deleting them after the fact works just as well. Let me add a little extra knowledge to this discussion. Like the Windows version you can change the file locations in Mac Office.
However, in the 2016 version the icon only shows up on the Word preferences pane, but any changes affect Excel and Powerpoint too. I use a Dropbox folder so that template changes are available on both my laptop and desktop. In doing this I realised that templates are presented in sub-folder sequence, that is all those in “A” will appear before those in “B”, and so on.
I use this to group templates by client. Has anybody else lost their Excel template with the latest Mac Office 2016 update? My template is gone from the folder and when I open a new Excel file, my preferred formatting isn’t there. I tried creating a new template (Book.xltx) and saving it in the correct folder, but when I open Excel, the formatting still isn’t there. Interestingly, when I just “double click” on the “Book.xltx” file in Finder, it opens with the correct formatting. Something tells me Excel is opening another template file from a different location.
I figured out a way to make it work, but I’m still disappointed that 1) my old template is gone (on my wife’s computer the same problem), and 2) that the old method of just having the template file in the templates folder would open the file. I created a folder for the template and then set Excel to “At startup, open all files in:” that folder. In Excel, go to Preferences, under Authoring, click General, for the “At startup, open all files in:” location click “Select” and go to the folder you created. Note: if you have any other files in that folder, Excel will try to open them also! Search for: Follow Blog via Email Enter your email address to follow this blog and receive notifications of new posts by email. Join 2,087 other followers Recent Posts. Archives.
Categories. Meta. Search for: Recent Posts. Archives. Categories.
Meta.
Microsoft has, including new versions of Word, Excel, PowerPoint, and Outlook. The first major Mac release since Office 2011 brings redesigned interfaces and new features, including those focusing on cloud integration and collaboration. The new office suite had been in beta testing since March.: If you already use Office on a PC or iPad, you will find yourself right at home in Office 2016 for Mac. It works the way you expect, with the familiar ribbon interface and powerful task panes. Mac users will appreciate the modernized Office experience and the integration of Mac capabilities like Full Screen view and Multi-Touch TM gestures. With full Retina® display support, your Office documents look sharper and more vibrant than ever.
Office for Mac is cloud-connected, so you can quickly get to the documents you’ve recently used on other devices and pick up where you left off. New, built-in document sharing tools make it easy to invite teammates to work on a document together. When sharing documents, you won’t have to worry about losing content or formatting, as Office for Mac offers unparalleled compatibility with Office on PCs, tablets, phones and online. Office 2016 for Mac now includes a Yosemite-inspired design, and offers full screen support, Retina display support, and multi-touch gestures. Word for Mac 2016 Word offers a new Design tab that allows users to easily apply designer-quality layouts, colors and fonts throughout their documents.
Collaboration features mean users can work on the same document simultaneously with their teammates, using threaded comments to have a conversation right next to the corresponding text. Excel for Mac 2016 The new Excel for Mac will recommend charts best suited for the data the user is working with with chart previews.
Keyboard shortcuts, autocomplete and an improved formula builder save time when users are creating spreadsheets or entering data. The new PivotTable Slicers aid with deeper analysis, help users filter large volumes of data and discover patterns.
PowerPoint for Mac 2016 PowerPoint for Mac 2016 offers an improved Presenter View that gives users full control when presenting by showing the current slide, next slide, speaker notes and a timer on the user’s screen, while the audience only sees the presentation on the big screen. PowerPoint offers new templates, and slide transitions. A new animation pane helps users design and fine-tune animations. Outlook for Mac 2016 Outlook for Mac was released last October, and works alongside today’s release, offering push mail support, an improved conversation mode, and message previews. An improved mail merge to work with Word, and Propose a New Time capabilities for appointments have been added to Outlook. OneNote for Mac 2016 OneNote offers users the ability to capture ideas in digital notebooks and access them on any device.
The OneNote search engine that tracks your tags, indexes your typed notes and recognizes text in images and handwritten notes. Bold, italicize, underline or highlight notes, insert files, pictures and tables and organize your notes however you want. You can also share notebooks with friends, family or colleagues so everyone can work together on travel plans, household tasks or work projects. Microsoft Office for Mac 2016 is available for all Office 365 subscribers today, and can be installed by logging into your Office account and following the directions found there. It’s a little over 1.6 GB of a download, and installation proved to be a matter of a few clicks and a two-minute wait on my 2011 MacBook Pro with SSD. Office is officially supported on Macs running OS X Yosemite.
The suite will be available as a one-time purchase in the fall. Office subscriptions come in a number of levels: Office 365 Personal, offers Office access for 1 computer, 1 phone, and 1 tablet, is priced at $69.99 per year or $6.99 per month. Office 365 Home, offers access for 5 computers, 5 tablets, and 5 phones is priced at $99.99 per year or $9.99 per month. Microsoft also offers plans for students and businesses at various price levels.