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

Data Analysis

  • Excel Frequency Function Example
  • Example of COUNTIFS with variable table column in Excel
  • Get column index in Excel Table
  • Reverse List in Excel
  • How to Create One and Two Variable Data Tables in Excel

References

  • Perform case-sensitive Lookup in Excel
  • Left Lookup in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to get last column number in range in Excel
  • Extract all partial matches in Excel

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation allow uppercase only
  • Prevent invalid data entering in specific cells
  • Excel Data validation number multiple 100
  • Excel Data validation require unique number

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 Print 
  • Multiple Copies 
  • Change Page Orientation
  • Adjust Page Margins
  • Use Scaling to Fit Sheet on One Page

Print a Worksheet

To print a worksheet in Excel, execute the following steps.

1. On the File tab, click Print.

2. To preview the other pages that will be printed, click ‘Next Page’ or ‘Previous Page’ at the bottom of the window.

3. To print the worksheet, click the big Print button.

Worked Example:   How to Break Worksheets into Pages in Excel

What to Print

Instead of printing the entire worksheet, you can also only print the current selection.

1. First, select the range of cells you want to print.

2. Next, under Settings, select Print Selection.

3. To print the selection, click the big Print button.

Note: you can also print the active sheets (first select the sheets by holding down CTRL and clicking the sheet tabs) or print the entire workbook. Use the boxes next to Pages (see first screenshot) to only print a few pages of your document. For example, 2 to 2 only prints the second page.

Print Multiple Copies of Worksheet

To print multiple copies, execute the following steps.

Worked Example:   Print Headers and Footers in Excel

1. Use the arrows next to the Copies box.

2. If one copy contains multiple pages, you can switch between Collated and Uncollated. For example, if you print 6 copies, Collated prints the entire first copy, then the entire second copy, etc. Uncollated prints 6 copies of page 1, 6 copies of page 2, etc.

Change Worksheet Orientation Before Printing

You can switch between Portrait Orientation (more rows but fewer columns) and Landscape Orientation (more columns but fewer rows).

Adjust Page Margins

To adjust the page margins, execute the following steps.

1. Select one of the predefined margins (Normal, Wide or Narrow) from the Margins drop-down list.

2. Or click the ‘Show Margins’ icon at the bottom right of the window. Now you can drag the lines to manually change the page margins.

Worked Example:   How to set or clear a print area in Excel Worksheet

Scale Excel worksheet on one page

If you want to fit more data on one page, you can fit the sheet on one page. To achieve this, execute the following steps.

1. Select ‘Fit Sheet on One Page’ from the Scaling drop-down list.


Important! you can also shrink the printout to one page wide or one page high. Click Custom Scaling Options to manually enter a scaling percentage or to fit the printout to a specific number of pages wide and tall. Be careful, Excel doesn’t warn you when your printout becomes unreadable.

Post navigation

Previous Post:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Identify Duplicate Values vs Remove Duplicates in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Display the current date in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to get Weekdays, Working days between Two Dates in Excel
  • Get first day of previous month in Excel
  • Convert Unix time stamp to Excel date

Grouping

  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Convert column number to letter in Excel
  • Basic error trapping example in Excel
  • Creating and Opening an existing file in Excel
  • How to fill cell ranges with random number from fixed set of options in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning