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 > ...
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.
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)
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 firstname.lastname@example.org (formatting syntax).
This is not because non-existing final destination mail, is just ...
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.
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:
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 ...
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 ...