Views on a worksheet

Depending on what we want to acomplish it is possible to use several different views on the worksheet. These views make it easier to get into large tables or to adjust the appearance of the work environment in accordance with our own desires. In this way, Excel can be configured to resemble more like a data entry form or print preparation software. Personally, when preparing to print a document, I often use the Page Layout view, and in the text that follows, you will see and why!

Excel has three basic views of the data, such as: Normal view, Page Break Preview view, or table view that shows the way it will finaly look on printed pages (Page Layout). The first view is most commonly used, and is convenient for entering and processing data in tables. The second view is similar to the first, and adds page breaks in the form of broken lines that mark the end of some pages. The third view is ideal when preparing for printing, as it shows how the tables will be printed on the page with all the additional page adjustment elements. View the views by choosing the View toolbar, and then clicking on one of the icons in its beginning that indicate different views.

Additionaly, in the View ribbon you can also find several optional fields to determine whether a ruler, formula bar, headings or gridlines of the table will be displayed. Also, there are several options for zooming the table, or adjusting display screens. Zooming can also be done using a shortcut, holding down the CTRL key and rolling the mouse wheel forward or backward. In the lower right corner of the screen, there is a slider whose movement can adjust the display ratios (how much is the zoomed table we are working with). To the left of the slider are also shortcuts to different views, shown with three notiable icons, which we regularly access to the Normal, Page Layout or Page Break Preview view.

When we make the desired changes, we can record them as your own view (Custom View) by activating the option with the same name. It will open a dialog window that can be used to add, delete, or display existing views. In this way, it is possible to define more custom views and change them as needed.

You can also view the data in the worksheets with multiple windows. Using multiple windows gives us a better insight into large tables or an easier simultaneous viewing of the data contained in several worksheets. By positioning the View ribbon and selecting New Window option we create a new window looking at the worksheet. The Switch Windows option is used when we have multiple windows, it allows us to switch from one window to another, and Hide or Unhide can hide an active window or discover some of the hidden windows. Multiple windows works simultaneously to make data more difficult, so windows can be edited by selecting Arrange All. After activating this option, a dialog window opens, which offers us several ways to decorate the window: as tabs, horizontally, vertically, or in cascades. Also, we can choose whether to edit windows only for active workbook or all windows currently open.