Categories
Microsoft Excel

How to Merge Cells in Excel (and When Not To)

To merge cells in Excel, select the cells you want to combine, go to the Home tab, and click Merge & Center in the Alignment group. Use the dropdown arrow for other options: Merge Across (merges each row separately), Merge Cells (merges without centring) and Unmerge Cells. Merging keeps only the value in the top-left cell and discards the rest, so it is best used for titles and labels, not for data you will sort, filter or analyse.

Categories
Microsoft Outlook

How to Schedule (Delay) an Email in Outlook

To schedule an email in Outlook, compose it as normal, then choose the schedule option instead of Send. In new Outlook and Outlook on the web, click the small arrow next to the Send button and select Schedule send, then pick a date and time. In classic Outlook, open the Options tab, click Delay Delivery, and set a “Do not deliver before” date and time. Outlook then sends the message for you at that moment.

Categories
Microsoft Excel

How to Create a Drop-Down List in Excel

To create a drop-down list in Excel, select the cell, open the Data tab, click Data Validation, choose Allow: List, and either type your items in the Source box separated by commas or select a range that contains them. Click OK, and a small arrow lets users pick from the list instead of typing.

Categories
Microsoft Outlook

How to Set Up an Out of Office in Outlook

To set an out of office in Outlook, open Automatic Replies: in new Outlook or on the web go to Settings > Accounts > Automatic replies; in classic Outlook go to File > Automatic Replies. Turn it on, set a start and end time, type your message, and save. Automatic Replies works on Microsoft 365 and Exchange accounts.

Categories
Microsoft Outlook

How to Recall an Email in Outlook

To recall an email in Outlook, open Sent Items, open the message, and choose Recall Message (new Outlook) or Actions > Recall This Message (classic Outlook). Recall only works if you and the recipient are on Microsoft 365 accounts in the same organisation; it cannot recall emails sent to external addresses like Gmail.