How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Headers: How to Add Them to Every Printed PageTo add a header that repeats on every printed page in Excel for Microsoft 365 on Windows, choose Insert > Header &…
- Add a Header in Excel on Every Printed PageTo add a header that repeats on every printed page in Excel for Microsoft 365 on Windows, open Page Layout > Page…
- How to Remove Page Break View in Excel: Normal ViewTo remove Page Break Preview in Excel for Microsoft 365 on Windows, select View > Normal. If you have already returned to…
- Remove Page Break Lines in Excel: Steps for Every SheetTo hide page break lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced, find Display options for…
- Remove Page Break Numbers in ExcelTo remove the large page-break numbers in Excel, switch from Page Break Preview to View > Normal. The numbers are only an…
- How to Remove a Horizontal Page Break in Excel QuicklyTo remove a manual horizontal page break in Excel for Microsoft 365 on Windows, select the row immediately below the break, then…
- Remove Page Break Gridlines in Excel: Quick StepsTo remove page-break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then open File > Options >…
- Page Break in an Excel Cell: What Excel Really AllowsExcel cannot place a print page break inside a cell: a page break separates printed worksheet pages at a row or column…
- Page Break in Excel Shortcut: Insert and Adjust BreaksIn Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should divide, then press Alt,…
- Remove a Hard Page Break in Excel: Step-by-StepTo remove a hard (manual) page break in Excel for Microsoft 365 on Windows, select the cell below a horizontal break or…
- How to Insert a Vertical Page Break in Excel for PrintingTo insert a vertical page break in Excel for Microsoft 365 on Windows, select the entire column immediately to the right of…
- How to Hide Page Break Lines in Excel on a WorksheetTo hide page break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then choose File > Options…
- How to Insert a Page Break in Excel for Better PrintingTo insert a manual page break in Excel for Microsoft 365 on Windows, select the row below or the column to the…
- Excel Page Break Button Locked? Common Causes and FixesIn Excel for Microsoft 365 on Windows, the Page Break command is usually unavailable because Excel is editing a cell, multiple worksheet…
- How to Change Page Breaks in ExcelTo change a page break in Excel for Microsoft 365 on Windows, open the worksheet, choose View > Page Break Preview, and…
- Excel Page Break Based on Cell Value: How to Set ItExcel cannot create a page break directly from a cell value with a worksheet formula or built-in conditional rule. In Microsoft 365…
- Can You Add a Page Break in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, select the row below or the column to the right of where you want…
- Excel Insert Page Break Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a page break. First select a…
- Excel: Insert a Page Break Every X RowsTo insert a page break every X rows in Excel for Microsoft 365 on Windows, use a short VBA macro: it can…
- Print Gridlines in Excel Without Data on a Blank SheetTo print gridlines without data in Excel for Microsoft 365 on Windows, select a blank range, set it as the print area,…
- Create a Table in Excel: Steps, Formatting, and FixesTo create a table in Excel, select a cell in your data, press Ctrl+T on Windows, confirm the range and whether it…
- How to Create a Table in Excel With the Keyboard ShortcutTo create a table quickly in Excel for Microsoft 365 on Windows, click a cell inside your data and press Ctrl+T. Check…
- Add a Checkbox in Excel: The Fastest Keyboard ShortcutTo add a checkbox quickly in Excel for Microsoft 365 on Windows, select the cell or range, then click Insert > Checkbox.…
- Calculate Age in Excel Using an ID Number with a Birth DateIf an ID number begins with a date of birth, you can extract its year, month, and day into helper columns, turn…
- Calculate Age in Excel From a Birth Date, Step by StepTo calculate someone’s age in completed years in Excel, put their birth date in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another cell. For…
- Add Checkbox in Excel: Steps to Insert and Link OneTo add a checkbox in Excel for Microsoft 365 on Windows, select the cell or range where you want it, then choose…
- Calculate Age in Excel From a Date of Birth Step by StepTo calculate someone’s age in completed years, enter their date of birth in B2 and use =DATEDIF(B2,TODAY(),"Y") in another cell. Excel updates…
- Calculate Age in Excel From Two Dates: Exact YearsTo calculate someone’s age in completed years from a birth date and a second date, enter the birth date in A2 and…
- Calculate Age in Excel From a Date of BirthTo calculate someone’s age in completed years in Excel, enter their date of birth in A2 and use =DATEDIF(A2,TODAY(),"Y") in B2. Excel…
- How to Calculate Age in Excel From a Date of BirthTo calculate age in completed years in Excel, put the date of birth in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another cell. Excel…