• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Quick Formatting and Printing in Excel

0 Comments

Quick Formatting and Printing in Excel. Formatting and printing tables and reports using Excel is a common task in office work, but it often takes a lot of time. Why? Because we usually check the product after pressing the print command, and then have to fix formatting errors many times afterward. UniTrain shares 3 basic steps to help you format and print effectively as follows:

STEP 1: Select the data range to print and adjust the header to be repeated quick Formatting

Select Print Titles in [Ribbon] Page Layout\Print Titles

Quick Formatting and Printing in Excel

Quick Formatting and Printing in Excel

In the Sheet tab:

Select the area to print in the Print Area section. For example, in the image, it is A2:M74.
Select the header range to repeat in the Rows to repeat at top section. For example, in the image, it is $2:$7.
Additionally, you can also select columns to repeat when printing a spreadsheet with a wide horizontal dimension similarly.

Quick Formatting and Printing in Excel

Quick Formatting and Printing in Excel

STEP 2: Adjust the paper size

In the Page tab: Adjust the size and dimensions of the paper according to the following common parameters:

– Select the paper size in the Paper Size section: A4
– Choose the paper dimension in the Orientation section: Portrait or Landscape
– Adjust to fit the paper size in the Scaling section: Fit to 1 page(s) so that the columns/information fields are compact and fit the horizontal dimension of the printing paper.

Quick Formatting 3STEP 3: Number the pages to make it easy for readers to understand the information

In the Header/Footer tab: Select the page number in the Header/Footer section.

Quick Formatting 4The result is a printed table with a repeated header, page numbering, and appropriate alignment on one sheet of paper to make it easy for readers to understand the information.

Quick Formatting 5

9
67 Views
How to extract real addresses from Hyperlinks in ExcelPrevHow to extract real addresses from Hyperlinks in ExcelMarch 28, 2023
10 ways to use Paste feature in ExcelMarch 28, 202310 ways to use Paste feature in ExcelNext

Leave a Reply Cancel reply

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

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $11.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.