Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Insert and Customize Sparklines in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Remove Duplicates Example in Excel
  • How to create Checklist in Excel

References

  • How to use Excel VLOOKUP Function
  • How to get address of named range in Excel
  • Create hyperlink with VLOOKUP in Excel
  • To count total rows in a range in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation with conditional list
  • Excel Data validation allow uppercase only
  • Excel Data validation date in next 30 days
  • Excel Data validation number multiple 100

Tag: Print

Print Page Numbers in Excel

by

This example teaches you how to print page numbers in Excel. 1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view. 2. Click Add footer. The Header & Footer Tools contextual tab activates. 3. On the Design tab, in the Header & Footer Elements group, click Page Number to …

Continue Reading

How to ‘Center on Page’ Print in Excel

by

To center a range of cells on a printed page in Excel automatically, execute the following steps. 1. On the File tab, click Print. 2. Click ‘Custom Margins’ from the Margins drop-down list. 3. Next, check horizontally and vertically. 4. Click OK.

Continue Reading

How to Break Worksheets into Pages in Excel

by

Insert a page break in Excel to specify where a new page will begin in the printed copy. To insert a horizontal page break, execute the following steps. 1. Select the first row of the new page. 2. On the Page Layout tab, in the Page Setup group, click Breaks. 3. Click Insert Page Break. Excel displays …

Continue Reading

Print Headers and Footers in Excel

by

This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel. 1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view. 2. Click Add header. The Header & Footer Tools contextual tab activates. 3. On the Design …

Continue Reading

Print Titles in Excel Worksheets

by

You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read. To print titles, execute the following steps. 1. On the Page Layout tab, in the Page Setup group, click Print Titles. The Page Setup dialog box appears. 2. To repeat row 1 at …

Continue Reading

Print Gridlines and Headings in Excel

by

Print gridlines (the horizontal and vertical lines on your worksheet) and row/column headers (1, 2, 3 etc. and A, B, C etc.) to make your printed copy easier to read. To print gridlines and headings in Excel, execute the following steps. 1. On the Page Layout tab, in the Sheet Options group, check Print under Gridlines and check Print …

Continue Reading

Print Excel Sheet In Landscape Or Portrait

by

Excel can fit three more columns of information on the page in landscape mode than it can in portrait mode. By default, paper orientation is mostly portrait. This article shows how to change paper orientation in Excel before printing a worksheet or workbook. Print a worksheet in landscape or portrait orientation Steps to change page …

Continue Reading

How to choose page/paper size in Excel before Printing

by

How do you know which paper size when you want to print in Excel? |  Selecting a Paper Size Working excel files is one thing, knowing what paper size to print completed work is another. In most cases, you’ll use the standard 8.5-x-11-inch letter-sized paper to print your worksheets. However, if you find that you …

Continue Reading

How to make excel worksheets print on one page?

by

Excel obviously allows you to print your worksheets to a printer. Sometimes a worksheet will fit on a single page, but other times it will flow to another page. These steps teaches you how to print a worksheet and how to change some important print settings in Excel such as: Print a Worksheet What to …

Continue Reading

How to set or clear a print area in Excel Worksheet

by

Quick Tips On How To Set Multiple Print Areas in Excel A print area is one or more ranges of cells that you designate to print when you don’t want to print the entire worksheet. If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Check If Two Dates are same month in Excel
  • Convert Unix time stamp to Excel date
  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • Custom weekday abbreviation in Excel
  • Convert Excel time to decimal seconds

Grouping

  • Group numbers at uneven intervals in Excel
  • Group numbers with VLOOKUP in Excel
  • Map inputs to arbitrary values in Excel
  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Basic numeric sort formula in Excel
  • How to generate random number between two numbers in Excel
  • Excel Operators
  • How to Delete Cells, Row and Rows in Excel
  • How to get Excel workbook path only
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning