Categories
Microsoft Word

How to Add Page Numbers in Word (and Skip Page 1)

To add page numbers in Word, go to the Insert tab, click Page Number in the Header & Footer group, choose a position (Top of Page, Bottom of Page or Page Margins) and click a style. Word numbers every page automatically and updates the numbers as you add or remove pages. To leave the first page unnumbered, tick Different First Page on the Header & Footer tab. To change the style (such as i, ii, iii) or the starting number, use Page Number > Format Page Numbers.

Categories
Microsoft Excel

How to Freeze Panes in Excel (Rows & Columns)

To freeze panes in Excel, go to the View tab and click Freeze Panes in the Window group. Choose Freeze Top Row to keep your headings visible, or Freeze First Column to keep the left column visible. To freeze several rows and columns at once, select the cell immediately below and to the right of the rows and columns you want to lock (for example C3 to lock rows 1 to 2 and columns A to B), then choose Freeze Panes. To undo it, click Freeze Panes > Unfreeze Panes.

Categories
Microsoft Outlook

How to Add a Signature in Outlook (and Change It)

To add a signature in Outlook, go to Settings > Accounts > Signatures in new Outlook or Outlook on the web (in classic Outlook, File > Options > Mail > Signatures). Click New signature, give it a name, type your name, title and contact details, and click Save. Then choose it as the default for new messages and for replies and forwards so it appears automatically. To change your signature, return to the same screen, select it, edit it and save.

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.