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

Data Analysis

  • How to calculate average last N values in a table in Excel
  • Subtotal function in Excel
  • How to Create Gantt Chart in Excel
  • How to create a Histogram in Excel
  • Move chart to a separate worksheet in Excel

References

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel INDIRECT Function
  • Extract all partial matches in Excel
  • Perform case-sensitive Lookup in Excel
  • Count rows with at least n matching values

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation must contain specific text
  • Excel Data validation must begin with
  • Excel Data validation don’t exceed total
  • Excel Data validation with conditional list

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

  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel

Date Time

  • Get date from day number in Excel
  • Get last weekday in month in Excel
  • How to calculate future date say 6 months ahead in Excel
  • Get day from date in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • How to randomly assign data to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to get random value from list or table in Excel
  • How to count total columns in range in Excel
  • Advanced Number Formats in Excel
  • Split Cell Content Using Text to Columns in Excel
  • How to generate random number between two numbers in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning