Questions tagged [office-for-mac]
The Microsoft Office versions released for the Mac OS X operating system.
117
questions
1
vote
1
answer
418
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. ...
1
vote
2
answers
2k
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 ...
1
vote
0
answers
20
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 ...
0
votes
1
answer
290
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 ...
1
vote
2
answers
694
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....
0
votes
1
answer
493
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 ...
0
votes
0
answers
21
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 ...
3
votes
5
answers
7k
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 ...
0
votes
0
answers
91
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 ...
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
0
votes
0
answers
127
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.
0
votes
2
answers
164
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:
2
votes
1
answer
239
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 ...
2
votes
0
answers
654
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 ...
0
votes
1
answer
160
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. ...