Office and productivity

Add X-axis values in Excel through Select Data and the Axis label range box. Covers custom labels, scatter charts, dynamic named ranges and fixes for wrong labels.

Unprotect a workbook in Excel by selecting Review > Protect Workbook and entering the password. Five methods, including VBA, file passwords and unprotected copies.

Cross words out in Google Docs by selecting the text and pressing Alt + Shift + 5 (Cmd + Shift + X on Mac), or use Format > Text > Strikethrough.

Sign in to Outlook with a QR code by scanning the code desktop Outlook shows with the Outlook mobile app. Covers work badges, Authenticator setup and fixes.

Check for Microsoft Office updates in any app via File > Account > Update Options > Update Now. Steps for Microsoft 365, older Office, Mac and iPhone, plus fixes.

Install add-ins in Microsoft Outlook from Add apps or Get Add-ins, then turn them on, off or remove them in new Outlook, classic Outlook and Outlook on the web.

Use Google Docs offline by turning on Offline in Google Drive settings in Chrome or Edge with the Docs Offline extension. Mobile steps, syncing and fixes.

Cycle through Excel tabs on keyboard with Ctrl + Page Down and Ctrl + Page Up. Shortcuts for Windows, Mac and Excel for the web, plus fixes when they fail.

Fix the Something Went Wrong error in Office: restart, update, run Online Repair, sign in again, remove bad add-ins, clear the cache, or reinstall Microsoft 365.

Wrap text automatically in Excel with the Wrap Text button, Format Cells, AutoFit row height, keyboard KeyTips or a VBA macro. Steps, checks and fixes.

Use breakout rooms in Zoom: turn them on in the web portal, click Breakout Rooms in a meeting, assign people, then Open All Rooms. Options, pre-assigning and fixes.

The name cannot be matched to a name in the address list: clear the Outlook nickname cache, unhide the mailbox in the GAL, and retest Autodiscover.