Work & learning

Documents, job hunting, study and time management

Documents & work5

Excel dates showing as numbers: check formatting before changing values

If a date appears as a number such as 40729, inspect a copy and apply a date display to a known example. Separate narrow columns, imported text and different workbook date systems from a simple format problem.

Read article

Remove a blank Word page by checking paragraphs and breaks

Show formatting marks before repeatedly pressing Delete. Distinguish empty paragraphs, manual page breaks, the required final paragraph and section breaks, then inspect the final document and PDF.

Read article

Excel Freeze Panes: keep headings and several columns visible

Select the cell below the rows and to the right of the columns you want to keep, then choose View → Freeze Panes → Freeze Panes. B2 keeps row 1 and column A visible; C3 keeps the first two rows and columns. Check both scrolling directions before returning to work.

Read article

Fit Excel printing to one page: what to check when text gets too small

To put the whole table on one sheet, set both Width and Height to 1 page in Page Layout. For a long table, that may make text too small. If you only need to keep columns together, use Width: 1 page and Height: Automatic, after checking the print area and orientation.

Read article

Find and remove duplicate values in Excel while keeping the original

To find duplicates without deleting them, highlight them with Conditional Formatting first. To remove them, copy the original and select the comparison columns in Remove Duplicates. A repeated name and a matching combination of several fields are different things, so start by deciding what counts as a duplicate.

Read article