New answers tagged

2

When putting a sum-over-the-entire-column formula into a regular cell, you are basically self-referencing the formula cell as a value cell. Try putting the the formula into a footer row. This way you can reference only the cells in a column without including the header or footer row. Add a footer row in the "Header & Footer" section in the Format > ...


0

Using version 5.1 (5683), to my (limited) knowledge of Numbers, there is not an equivalent of the Excel =SUM(ABOVE) formula in Numbers. If you primarily want to use the keyboard, start by adding a keyboard shortcut for the SUM formula in Numbers in System Preferences > Keyboard > Shortcuts > App Shortcuts as shown in the image further below. I gave it: ^S ...


-2

You can define your expression by writing = sum( and then clicking with your cursor on the first row you want to include and then dragging the cursor down to the last row. This is much simpler than writing the values in. Below is an image of a sum expression. The only thing I actually typed was the characters = sum(. After using the cursor to select B2 ...


-1

The problem was fixed years ago, but has returned to all Word, Excel and PowerPoint 2019 version 16.29.0 (19090802) for Mac released yesterday: they only show "File - Open Recent - More" and not any recent item there! Somebody knows how to fix it or is this an Office bug?


0

There is a slight possibility that if you export your current document to a PDF, open it on Acrobat Reader, put your mouse over that image for a few seconds, a tooltip will come up and prompting you the original location of the image. However, since your image was imported through a PDF but not a direct file, this method may not 100% work.


0

I just used the "customize keyboard" in the Tools menu and it works fine... This image shows it being set up:


1

Unfortunately it seems like the office suite (Excel included) automatically compresses the image. You'd have to just insert the original image. There may be a workaround for this but I haven't been able to solve it yet. Sorry I couldn't be of more help.


1

Setting to zero Finder's menu recent items count (via System Preferences > General) also sets to zero all Office applications' Open Recent... items count. Not a definitive solution but a viable workaround until Microsoft fixes the issue (assuming that is a bug that Office apps "touch" all files listed in Open Recent... when File menu is clicked)


1

Looks like some destination e-mail address is wrong formmated (like: missing domain, or just some name without full e-mail address) I would check all the destination recipient address and validate them for syntax. It the case for checking syntax name@domain.com (formatting syntax). This is not because non-existing final destination mail, is just ...


1

Press up arrow, command and enter for the slide show from beginning Press command and enter from the current slide. If is not working again then uninstall powerpoint by using "Appdelete" or "CleanMyMacX" then reinstall again.


0

This is also a workaround but maybe a little quicker. In calendar view, select original meeting Click on the Reply All button in the ribbon -> this creates an email to all attendees Save this In drafts folder select the email you just created Click on the meeting button in the ribbon -> this creates a new meeting request for all attendees of the original ...


1

Simple answer: no. Apple removed the PPT-like quick format bar when iWork '09 was replaced by the current versions. Anyway, here are my workarunds/best practices: Question 1 a) You can keep the "Arrange" tools palette open for quick access to – well – the Arrange tools. View menu -> Show Arrange Tools b) Most Arrange menu items /Align, Distribute) don't ...


0

For Outlook on Mac, Go to top toolbar 'Get Add-ins'-->'My add-ins'--> Click the ... button to see the remove add-in option.


1

Unless I'm missing something from your question, you've actually already worked out how to do this. That is, if you first filter by one column the way you want, and then filter by the second column the way you want, you've effectively filtered both columns. So, using your example, say you filter the location column so that only people in location X are ...


1

You likely have an email stuck in the Outbox. Outlook is nowhere near the horror show it used to be but it is a complicated beast that wouldn't know an understandable error message if it bit it. So look down the left hand side of your Outlook window in the folders. There is likely one there called Outbox and it is in bold possibly with a "(1)" next to it. ...


Top 50 recent answers are included