# Office365

# Download

- Open Office 365: [<span>https://www.office.com/</span>](https://www.office.com/).
- Sign in with the UZH Microsoft Account (in the center or on the top right). ![alt text](https://wikiall.math.uzh.ch/public/Office365/Setup?action=AttachFile&do=get&target=Office_365_Signin.png "alt text")
- Nowadays (2026), Copilot opens up first, click on the 3by3 dot matrix icon in the top left, then *More apps*. [![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/E5Kimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/E5Kimage.png)
- Then click on *install apps,* then *Microsoft 365 apps* and proceed from there.
    
    [![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/AjGimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/AjGimage.png)

# Excel

### Issues

#### Numbers are unwillingly converted to dates

- Excel is configured to recognize dates and change the formatting of a cell automatically, whenever it recognizes a date.
- Sometimes the recognition is faulty, which results in cells being formatted as dates, even though it is just a number.
- There are two approaches to fix the issue: 
    1. Format all the cells before inserting numbers (select either "standard" or "number"):

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/gJbimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/gJbimage.png)

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/lGbimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/lGbimage.png)

1. Change decimal &amp; thousands separator (regional settings): 
    - Click File &gt; Options
    - On the Advanced tab, under Editing options, clear the "Use system separators" check box
    - Type new separators in the "Decimal separator" and "Thousands separator boxes"

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/fn2image.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/fn2image.png)

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/hIqimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/hIqimage.png)

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/scaled-1680-/sQCimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-07/sQCimage.png)

# OneDrive

- No good solution for UZH users.
- In general, there are different variants to access !OneDrive from Linux.
- Unfortunately: UZH policy blocks apps (used with UZH Microsoft account), which are not not privileged (security reasons) - the only allowed app is Microsoft !OneDrive App (only for Windows/Mac).
- It is possible to install a Web-App, which behaves a little bit like a lokal app, but the files are still remote.

### OneDrive WebApp

- Open [https://uzh-my.sharepoint.com/](https://uzh-my.sharepoint.com/) and log in - best in Chrome or Brave.
- Click on the install icon (upper right corner)

[![onedrive-install.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/onedrive-install.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/onedrive-install.png)

- From now on, you can start !OneDrive via the Menu &gt; Type: !Onedrive &gt; click

[![onedrive-start.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/onedrive-start.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/onedrive-start.png)

- But this is only a webinterface, <span style="text-decoration: underline;">not local storage</span>, see [drive.math.uzh.ch](https://wiki.math.uzh.ch/public/books/public-wiki/page/drivemathuzhch "drive.math.uzh.ch") for a file sharing solution including local storage.

# Outlook

- URL: [https://outlook.com](https://outlook.com)
- To login, use your UZH identity (email address, MFA setup [https://wiki.math.uzh.ch/public/books/public-wiki/page/microsoft-authentication](https://wiki.math.uzh.ch/public/books/public-wiki/page/microsoft-authentication))
- FAQ: [https://www.zi.uzh.ch/de/support/Outlook-und-Kollaboration-Office-365/outlook/faq.html](https://www.zi.uzh.ch/de/support/Outlook-und-Kollaboration-Office-365/outlook/faq.html)

### Out of Office

- [https://wiki.math.uzh.ch/public/email/vacation\_ooo\_out\_of\_office](https://wiki.math.uzh.ch/public/books/public-wiki/page/vacation-ooo-out-of-office "vacation ooo out of office")

### Shared Mailbox

#### Webinterface

##### Open another mailbox

[![outlook-su01.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-su01.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-su01.png)

[![outlook-su02.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-su02.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-su02.png)

##### Shared Accounts im Outlook Webinterface anzeigen

[![outlook.admin-accounts.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-admin-accounts.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/outlook-admin-accounts.png)


#### Outlook App (e.g. Citrix)

##### Shared Mailbox anzeigen

- Doku: [https://support.microsoft.com/en-us/office/open-and-use-a-shared-mailbox-in-outlook-d94a8e9e-21f1-4240-808b-de9c9c088afd#picktab=classic\_outlook](https://support.microsoft.com/en-us/office/open-and-use-a-shared-mailbox-in-outlook-d94a8e9e-21f1-4240-808b-de9c9c088afd#picktab=classic_outlook)
- Eigentlich sollten shared mailboxes direkt angezeigt werden.
- Ist das nicht / nur teilweise der Fall kann unter (Classic Outlook, Link s.o.) weitere Accounts hinzugefuegt werden.

##### New Mail: 'From' automatically selected by current selected mailbox

If there are multiple email adresses configured and a new email is created: it would be nice if 'from' points automatically to the last selected email account.

According to Microsoft, this is not supported by Outlook ([Link](https://support.microsoft.com/en-us/office/change-the-account-used-to-send-email-messages-2bdd8d4f-e30f-4ec8-88a0-406ce7b23cc5)).

##### Why is the 'From' button missing?

See: [Link](https://support.microsoft.com/en-us/office/change-the-account-used-to-send-email-messages-2bdd8d4f-e30f-4ec8-88a0-406ce7b23cc5)

##### Saving mail in drafts folder of the current email account

- Short: only with extra effort.
- Long: [https://learn.microsoft.com/en-us/answers/questions/5490248/drafts-are-saving-to-my-drafts-folder-instead-of-m](https://learn.microsoft.com/en-us/answers/questions/5490248/drafts-are-saving-to-my-drafts-folder-instead-of-m)

### Email forward

Setting up an email forward in Office 365 (Outlook) via Webinterface.

- Log in to [https://outlook.office365.com](https://outlook.office365.com)
- Go to `Settings > View all Outlook settings`

[![m365forward.01.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/m365forward-01.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-06/m365forward-01.png)

- Go to `Mail > Forwarding`

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-08/scaled-1680-/wfvimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-08/wfvimage.png)

##### Disable

- When you log in on the webinterface, just click on *Turn Off*:

[![image.png](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-08/scaled-1680-/Kjpimage.png)](https://wiki.math.uzh.ch/public/uploads/images/gallery/2026-08/Kjpimage.png)

## Hints

### Outlook for Mac: Realname

- Beim anlegen des IMAP Kontos: bei der Anmeldung „Synchronisation mit Microsoft Konto“ ausschalten. Danach kann beim Konto der Realname geändert werden.

### 'Reply All' should not include myself

- Currently we don't know if this is an option.