Questions tagged [office-for-mac]
The Microsoft Office versions released for the Mac OS X operating system.
117
questions
1
vote
1
answer
393
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
269
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
627
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
391
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
88
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
123
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
148
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
230
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
616
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
154
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. ...
1
vote
1
answer
2k
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 (...
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 ...
2
votes
1
answer
6k
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....
3
votes
1
answer
7k
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 ...
4
votes
0
answers
660
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.
...
0
votes
1
answer
236
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), ...
0
votes
1
answer
803
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 ...
1
vote
0
answers
191
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 ...
1
vote
3
answers
5k
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 ...
5
votes
1
answer
32k
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 ...
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 ...
3
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 ...
1
vote
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 ...
1
vote
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" ...
3
votes
3
answers
19k
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 ...
2
votes
1
answer
219
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, ...
1
vote
3
answers
68k
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,...
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 ...
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 ...
-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 ...
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?
0
votes
1
answer
311
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 ...
3
votes
2
answers
3k
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 ...
1
vote
0
answers
963
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 ...
3
votes
1
answer
9k
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 ...
7
votes
1
answer
50k
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.
0
votes
1
answer
482
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/...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...