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.
Sometimes it is more convenient to use the icon Group Page Layout Book view modes tabs View of the application ribbon.
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.
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.
It 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.
To switch to normal mode, there is an icon in the status bar.
It 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.
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular