Print, Share & Protect
Protect Certain Cells in Excel (lock some, leave the rest open)
Protect only certain cells in Excel — formulas or headings — while everything else stays editable: unlock all, lock the few, protect the sheet.
Category: Print, Share & Protect
Print, Share & Protect
Protect a Sheet in Excel: stop accidental edits in 3 clicks
Protect a sheet in Excel so cells cannot be changed, allow specific cells to stay editable, choose what users may still do, and unprotect.
Print, Share & Protect
How to Print Gridlines in Excel (and why they sometimes won’t)
Print gridlines in Excel with one tick box, print them for part of a sheet, use borders when gridlines won't print, and fix the greyed-out option.
Print, Share & Protect
How to Insert a Page Break in Excel (and remove or see them)
Insert a manual page break in Excel so each section prints on its own page, see where breaks fall with Page Break Preview, move them, and remove them.
Print, Share & Protect
How to Add a Header in Excel (printed header, not the heading row)
Add a header in Excel that prints at the top of every page: title, date, file name, page numbers, a logo — and the difference from a heading row.
Print, Share & Protect
How to Print Labels from Excel (with Word mail merge)
Print address labels from an Excel list using Word's mail merge: set up the sheet, pick the label size, map the columns, preview and print.
Print, Share & Protect
Print the Header Row on Every Page in Excel
Repeat the heading row on every printed page in Excel with Print Titles, repeat a column too, and add page numbers in the footer.
Print, Share & Protect
Set a Print Area in Excel: print only the part you want
Set a print area in Excel so only your table prints, fit it on one page, repeat the heading row, and clear the area when done.
Print, Share & Protect
Password Protect an Excel File: so it cannot be opened
Password protect an Excel file so nobody can open it without the password, set a separate edit password, and remove the password later.
11 tutorials · Page 1 of 2
