The will always appear in the screen until you remove the panes. The first, Freeze Panes, will fix to the screen all the rows above and to the left of the active cell, B4 in this case, will be frozen.
This is very practical when you enter data but still want to see your titles located in the first rows and columns.Įnter the text from the image to the left in the appropriate cells in a worksheet.įrom the tab View, in the Window group of commands, press the Freeze Panes button. This option will "freeze" part of your worksheet. You can easily change the zoom on the screen.Īnother option to quickly change the zoom is to press on the CTRL key and move the mouse's scroll wheel. You can use this bar whether your in normal, page break preview or page layout views. You will also find a zoom scalebar at the bottom right of the window. There is also another way to access the zoom option. You can concentrate your view on a range of cells that you have previously selected. Returns the zoom to 100%, it's usual size. Select a zoom size and press the OK button. You can personalize the size if you wish. The zoom button allows you to have a better view by zooming in or out on a section of your worksheet.Ī new window will appear that will give you some zoom size option. You can concentrate on a few cells or have a view of your entire worksheet to see how each section is placed. You can zoom in or out of a section of your worksheet. But, you can hide it for a short time to have more space to work. You can edit a formula directly from the formula bar. The formula bar is used to view the formula inside the cell. But, it easier to work on a worksheet with the gridlines on. You can hide the gridlines if you want to see how your document will look on paper or the improve your documents presentation. You can create many views for your worksheet (zoom, starting location.) and quickly change from one view to another.įrom the Show/Hide section, you can decide to show or hide some of Excel's options like the ruler, the gridlines, the formula bar or the headings. You can see your worksheet as it would look on paper including the headers and the footers. You can arrange the width of the columns or the print size to match your need even before printing. This option will show your where the page breaks would be located if you ever decided to print your worksheet. This option will show your worksheet as you normaly see it when you open Excel.
0 kommentar(er)
