Office and productivity

Move rows in Excel without replacing data: Shift-drag the row border, use Insert Cut Cells, swap rows with the pointer, or automate it with a VBA macro.

Create a daily cash book format in Excel with a running balance formula, a table with drop-downs, a template or a VBA macro. Steps, formulas and fixes.

Open PDF files in Windows 11 by double-clicking them, which loads Microsoft Edge’s built-in reader. Use Open with, separate windows, and fix PDFs that won’t open.

Get Microsoft Word as a student free with a school email via Office 365 Education, install desktop Word if your school licenses it, or use the college discount.

Use voice typing in Google Docs with Tools > Voice typing or Ctrl + Shift + S on Windows and Mac, plus keyboard dictation on iPhone and Android, and fixes.

Find mean, median and mode in Excel with AVERAGE, MEDIAN and MODE.SNGL, the Analysis ToolPak, or a manual sort-and-count check, with a worked example.

Make a worksheet in Word: set margins, add a name and date header, build questions in tables, add answer lines and check boxes, then save, print or share as PDF.

Remove white space in Excel with =TRIM(A2), Find and Replace, SUBSTITUTE, Power Query or a VBA macro. Fix nonbreaking spaces and delete blank rows too.

Find word count in Microsoft Word from the status bar, the Word Count box or Review > Word Count online. Count selected text, insert a count and fix a missing one.

Insert a text box in Google Docs with Insert > Drawing > New > Text box, or use a one-cell table. Steps for desktop and phone, borders, editing and fixes.

A Google Meet join code is a 10-character meeting ID. Enter it at meet.google.com, in Gmail or the Meet app, and learn how long codes last and why they fail.

Do a test call on Teams from Settings > Devices > Make a test call. Record a message, hear the playback, read the summary, and fix mic, speaker or camera issues.