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

Data Analysis

  • How to create dynamic reference table name in Excel
  • Understanding Pivot Tables in Excel
  • Remove Duplicates Example in Excel
  • How To Insert and Customize Sparklines in Excel
  • Example of COUNTIFS with variable table column in Excel

References

  • Basic INDEX MATCH approximate in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Extract data with helper column in Excel
  • How to get first row number in range in Excel
  • Offset in Excel

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday only
  • Excel Data validation exists in list

Tag: Print

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

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 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

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

  • How to use Excel NOT Function
  • Complete List of Excel Logical Functions, References and Examples
  • How to use Excel XOR Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function

Date Time

  • Display the current date and time in Excel
  • Get work hours between dates custom schedule in Excel
  • How to get same date next month or previous month in Excel
  • Add decimal hours to time in Excel
  • List holidays between two dates in Excel

Grouping

  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel
  • Map inputs to arbitrary values in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to generate random number between two numbers in Excel
  • Spell Check in Excel
  • How to Create Calendar in Excel
  • With vs Without Array Formula in Excel
  • Freeze and Unfreeze Panes in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning