Questions tagged [office-for-mac]

The Microsoft Office versions released for the Mac OS X operating system.

Filter by
Sorted by
Tagged with
0 votes
1 answer
76 views

Excel Data Validation List not visible

I am trying to make a dynamic calendar in Excel 2018 for myself through watching YouTube video tutorial. But I am constantly having a problem with "Data Validation" not displaying the list. ...
user avatar
  • 1
0 votes
2 answers
304 views

How to filter inbox based on current message's subject or sender in Outlook?

MS Outlook for Mac: 16.50 I've recently switched from Thunderbird to Outlook due to corporate mandate, and it's mostly gone well. The most important capability I had with Thunderbird is the one thing ...
user avatar
1 vote
0 answers
18 views

MS Word for Mac - change colour of existing INK annotations in whole doc

In the picture below the tick mark and the "M2" were added using lilac-coloured ink: The color is a bit hard to read (on screen or paper) so I want to change ALL the ink in the doc to be a ...
user avatar
  • 111
0 votes
1 answer
72 views

Wildcards Not Working in Excel Mac Filters Dropdown

Can anyone please explain to me why this doesn't work in my Mac version of Excel when the same thing works on the Windows version? I've tried the (?) and (*) wildcard characters, and I can't find ...
user avatar
0 votes
0 answers
117 views

Gray Box in Excel VBA Editor

A gray rectangle appeared while I was editing when I pressed something I wasn't supposed to. Is anyone familiar with resetting the Excel VBA view or getting rid of this rectangle? I'm working on a Mac....
user avatar
  • 101
0 votes
1 answer
125 views

Insert today's date in cell (command + ;) defaults to nonsensical 1900 date in mac

I know ctrl+; (windows) and cmd+; (mac) will insert today's date on the current active cell in excel. I'm facing a problem where it's inserting 1/0/1900 11:01:00 PM: Very confusing. Does anyone know ...
user avatar
0 votes
0 answers
13 views

PowerPoint: edit master slide shapes from within slides

I've made a master slide layout in Powerpoint, consisting of a rectangle with a textbox inside it. I would like to adjust the rectangle so that it contains the textbox, as the text differs between ...
user avatar
3 votes
4 answers
4k views

Outlook for Mac: Filter Unread never matches the Inbox badge count

I've looked through the various answers about counts being wrong, but none of them seem to address this issue directly. I have a current version Outlook for Mac (v16.39 - Office 365) When I read ...
user avatar
  • 139
0 votes
0 answers
34 views

need raw query to show flagged emails OR emails with red category

what's the proper raw query for me to utilize if I wanted to show only emails I've flagged OR emails I've categorized with the red color? I'd like to pull both these types of emails in one smart ...
user avatar
1 vote
2 answers
2k views

How to export from Powerpoint to PDF on MAC without creating a gigantic PDF?

When I export a 5mb pptx to pdf using powerpoint for Mac I get a 30mb PDF. Using the Compress Pictures option form powerpoint doesn't make any difference
user avatar
0 votes
0 answers
84 views

Blank space in MS Word (Mac)

Does anyone know how I can get rid of the blank space indicated in the image? It's not part of the footer, nor of the footnote and only exists on the first page.
user avatar
0 votes
2 answers
107 views

Excel how to remove selection area name?

So it appears once I created accounts it selects a group of cells. How can I delete accounts so it will not select a group of cells anymore. Please see screenshots:
user avatar
1 vote
1 answer
106 views

How do I make macOS native Contacts the default application for adding a contact instead of Microsoft Outlook's Contacts?

My Outlook Version is 16.14.1. Elaboration: I'm in the native Messages client. Someone sends me a contact through iMessage. I add that contact through the UI in Messages. Expectation: the contact ...
user avatar
2 votes
0 answers
391 views

Microsoft Word text underline layered over text different to preview

I am having an issue with Microsoft Word where the underline of underlined text is showing layered on top of the text (specifically drop letters). I've coloured this underline, which is why I've seen ...
user avatar
  • 21
0 votes
1 answer
126 views

Format an arbitrary date in Word

I need to insert a specific date in Word and have it formatted with the name of the day in the form "Name of the Day, DD.MM.YYYY". If I change the date the name of the day would be change accordingly. ...
user avatar
1 vote
1 answer
1k views

Excel Chart - Line Per Week, value by Day

I have a table with 3 columns: Week of year (number), Day of week (number: 1 for sunday, 2 for mondai, etc...) and earnings (number also). I would like to have a chart where the X axis are the days (...
user avatar
  • 137
1 vote
3 answers
5k views

Did Excel 2016 for Mac change its column width specifications from inches to something else?

A couple of weeks ago, I was working in Microsoft Excel 2016 for Mac, using an Office 365 subscription in the standard channel. When I would select a column and then "Column Width", my recollection is ...
user avatar
2 votes
1 answer
5k views

Sort/filter a protected sheet

I want to enable auto filter on a protected sheet in Excel. When I protect the sheet I make sure to allow sort/filter, but I'm still not allowed to use it. Solutions online (like https://answers....
user avatar
  • 121
3 votes
1 answer
6k views

Disable OneDrive Office 2016 for Mac

Is there a way to hide the OneDrive option when using the File Open dialog in Office for Mac 2016? I don't store anything in OneDrive, and I always have to switch to "On My Mac", which is irritating ...
user avatar
  • 1,242
4 votes
0 answers
644 views

How To Make Microsoft AutoUpdate Update Automatically on a Mac

Lots of programs that I run on my mac update themselves automatically in the background without any action required by me. The ones that come to mind immediately are Chrome, Dropbox, and Plex. ...
user avatar
  • 163
0 votes
1 answer
227 views

Can I format the Y-axis in this way?

I'm using Excel version 15.15 on a late 2014 Mac Mini running El Capitan 10.11.1. I am trying to represent 3 things; Profit & Loss for Rates & FX and for Credit (two different asset classes), ...
user avatar
0 votes
1 answer
734 views

Office for Mac 2016 :: PowerPoint :: Rename Objects

How can I rename objects in PowerPoint for Mac 2016, similar to PowerPoint 2016 for Windows? The same window allows you to toggle visibility of individual elements on a slide. I can't find this ...
user avatar
1 vote
0 answers
166 views

Word for Mac keeps converting PDF figures to bitmap

I have a PDF file that I need to use as a figure in a Word document. I can insert the PDF without problems, and I can export the document as a PDF from Word, retaining all details in the figure. But ...
user avatar
  • 2,757
1 vote
3 answers
4k views

How do I delete specific text in multiple cells at once?

I have a massive list of email addresses; but just to make things simple i am dealing with 3 - 10 email addresses that are typed up in 1 cell and i cant seem to MASS delete specific ones. Is there any ...
user avatar
  • 19
5 votes
1 answer
29k views

How do I set my profile picture in Outlook for Mac 2011?

How do I set my profile picture so that people can see my smiling face when they read e-mail messages from me? I've tried Outlook > Preferences > Accounts, but there are no options for a photo in ...
user avatar
  • 413
1 vote
1 answer
1k views

How to change the date format in Microsoft Word 'track changes' balloons

I'm using Microsoft Word for Mac, version 14.3.8. I've got track changes enabled, and it's flagging my changes with little balloons on the right hand-side. All well and good so far. Then it tells ...
user avatar
  • 141
2 votes
4 answers
9k views

How to disable tracking of formatting changes in Word for Mac 2011?

I use change tracking in Microsoft Word to collaborate with others while jointly editing a document, however, I am not interested in tracking formatting changes. On the Windows version of Word, I was ...
user avatar
  • 7,658
0 votes
1 answer
3k views

Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have: Starting Time B1: 09:30:00 am Ending Time C1: 17:00:00 pm Total Hours D1: =C1-B1 (06:30) I want to sum the values ...
user avatar
  • 1,664
0 votes
1 answer
5k views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
user avatar
  • 109
3 votes
3 answers
18k views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
user avatar
2 votes
1 answer
214 views

Excel opens all files in directory

Excel 2011 is behaving strange. When I open a file, Excel responds by opening all (.xlsx and .csv) files in the directory! I'm running OS X Mavericks. Tried several ways of opening: double click, ...
user avatar
  • 23
1 vote
3 answers
67k views

How to find a Word file if it isn't in auto recovery?

I have a Mac running OS X 10.6.8 and was working on my dissertation in Word, pressing Save regularly. A message came up saying Word had to unexpectedly quit, and then when I went to open my document,...
user avatar
  • 19
0 votes
1 answer
1k views

How to set a shortcut to "Customize Keyboard..." in Excel Mac 2011

I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut. Apparently we can't do do it via Excel because there ...
user avatar
  • 927
2 votes
1 answer
3k views

Excel Mac VBA Loop Through Cells and reset some values

I currently have 12 copies of a Workbook - one for each one of our company's locations. There are multiple columns, and one row for each day of the month. Every day the Location Manager fills out 2 ...
user avatar
-1 votes
1 answer
3k views

Office for Mac is slow, but only on my user profile, not others

I have Mac OS X Lion. The Microsoft Office on my profile is extremely slow. I deleted Office and reinstalled it but the performance didn't improve. I created another user and tried to open the same ...
user avatar
  • 99
1 vote
1 answer
2k views

Printing E-mails - Outlook for Mac

When printing an e-mail the "Attachment" icon and Attachment name do not print. How do I change the settings to correct this?
user avatar
  • 11
0 votes
1 answer
308 views

Combine Excel worksheets despite adding new sheets

I have an Excel worksheet that works as template for a questionnaire. My aim was simply to copy the worksheet into a new one while preserving the formatting and other stuff, and I could then just fill ...
user avatar
  • 241
3 votes
2 answers
2k views

Does the search in Microsoft Word have a proximity operator?

I need to search for a word within a certain number of words of another word. Is that possible in Microsoft Word? For example, word1 *3 word2 would return the results for 'word1' where it is 3 words ...
user avatar
  • 525
1 vote
0 answers
859 views

Show embedded images in Mac Word

I have a client who insists on sending me screenshots as images embedded in MS Word docx files. I can view these images by opening the documents in Word on my Windows machine but on any Mac machines ...
user avatar
3 votes
1 answer
8k views

How to reset footnote numbers for each page?

Is it possible to have Microsoft Word reset the footnote numbers on each page? I'm using Mac Word 2011 but are there any Word versions which support this? If yes maybe I could figure out how to do it ...
user avatar
  • 525
6 votes
3 answers
39k views

Keyboard Shortcut to Fit Column Width to Text in Mac Excel?

On a PC this is Alt+O,C,A, as explained here. Is there an equivalent keyboard shortcut in Excel for Mac, to fit the column width to the width of the text? I'm using the 2011 version.
user avatar
  • 525
0 votes
1 answer
466 views

Can't setup Thunderbird to read Outlook mail accounts

I consider myself geeky yet my soul is burning over a fairly simple problem. I need to set-up a number of email accounts on my computer. I have a remote POSTFIX/Courier server which is able to sent/...
user avatar
  • 101
1 vote
1 answer
2k views

Can I customize the install package for Microsoft Office Mac 2011?

I am sending my sister a USB installer for Microsoft Office Mac 2011, for the MacBook Air I recently gave her. I don’t want to fill the limited disk space with things like Outlook and a bunch of ...
user avatar
1 vote
0 answers
55 views

Is it possible to import the Office 2011's themes (for Mac) to use them in Office 2007 for windows?

Is there a way to import(convert) the PowerPoint themes from office 2011 (for mac) to Office 2007 or later for Windows (supposing you own them both)? The themes included with Office for mac come in a ...
user avatar
  • 111
1 vote
0 answers
308 views

Spell check doesn't work in protected forms in Word 2011 for Mac

We have a form template many staff members use. We created it in Word 2004 for Mac, and I was told a shortcoming was there was no way to turn on the spell checker (a real hassle!). I hoped this would ...
user avatar
  • 11
2 votes
1 answer
9k views

I can't open a Word file because it's too large

I was creating a file with MS Word 2007 where I included a number of images. I didn't compress them as I was putting them into the file. I managed to save the file, but have not been able to reopen it ...
user avatar
  • 21
8 votes
1 answer
3k views

Show messages from other folders in conversation view on Outlook for Mac 2011

On Outlook 2010 it is possible to show messages from other folders in the conversation view (it's an option in the Conversation Settings menu on the ribbon). Is there a similar option for Outlook ...
user avatar
  • 181
3 votes
2 answers
2k views

Resetting Styles to Default in Microsoft Word 2008

I want to reset all my MS-Word "Styles" to their default settings; i.e. fonts, sizes, spacing, etc. There doesn't seem to be an option to do this in the "Styles" panel. Is there any other way to do ...
user avatar
  • 187
7 votes
1 answer
5k views

How to create a "poll" in Microsoft Outlook 2011

Is it possible to create a vote/poll in a message in Microsoft Outlook 2011 for Mac OS X? Here's an example of how it could be done in Windows version of Outlook.
user avatar
  • 183
2 votes
1 answer
8k views

How to edit multilevel list in Word 2011 Mac

I use the multilevel list feature in Word as described here to set up proper nested numbering linked to styles. I did this on Windows, and it worked well. Now I am editing the documents on my Mac ...
user avatar
  • 297