• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Paginated View in Excel 2010
Next →
← Prev

Paginated View in Excel 2010

By Dinesh Thakur

The same documents may look completely different on a computer screen and when printed. This problem is especially relevant when working with Excel because, as already noted, the workspace is not paginated by default. Therefore, when entering data into cells of a worksheet, it is not always easy to predict how the data will be presented and grouped in printed form. Nevertheless, this problem is easily fixed, and there are several ways to fix it. Here we will describe the most simple and effective one. It is about switching to the pagination mode of the work area. It is enough to click on a special icon on the status bar – the central one of the three icons to the left of the scale selection switch.

Paginated Tabs in Excel 2010Sometimes it is more convenient to use the icon Group Page Layout Book view modes tabs View of the application ribbon.

Page Layout Mode

However, no matter how the transition to the mode of preliminary pagination of the document into pages is carried out.

In this case, the Excel working window resembles a text editor window (such as Word). However, unlike the editor, pagination is done both horizontally and vertically. All pages that do not contain an active cell are inactive. They are highlighted in colour and contain a special inscription, which disappears when activating any of the cells on the page.

pagination mode

As in the Word editor, in Excel, in the paginated document display mode, there are vertical and horizontal rulers at the boundaries of the work area.

ruler in page layoutIt is very convenient because it allows you to correlate the elements in the working document with the dimensions of the printed sheet more accurately. However, if there is a need or desire to remove the ruler from the screen, deselect the Ruler option in the Show group tabs on the Ribbon View tab. The working window in the paginated display mode but without the ruler.

To return to the normal mode used by the system by default, click on the Normal icon in the Book View Modes group of the Ribbon View tab.

Disable Rular Line

To switch to normal mode, there is an icon in the status bar.

normal mode in status bar iconIt is placed first on the left in three icons located near the display scale switch. For this and two other icons of the workbook view modes available, the View mode shortcuts option must be checked in the status bar context menu.

You’ll also like:

  1. BackStage View in Excel 2010
  2. Working with Excel 2010
  3. Excel 2010 Components
  4. Zoom IN/OUT in Excel 2010
  5. Special Symbols in Excel 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.