![]() ![]() Switch to the File tab of the top toolbar, go to the Advanced Settings section, choose the necessary Default Zoom Value from the list, and click the Apply button. The set scaling is maintained for all files during the current session. The Zoom settings are also available on the View tab. To change the currently selected zoom value that is displayed in percent, click it and select one of the available zoom options from the list (50% / 75% / 100% / 125% / 150% / 175% / 200% / 300% / 400% / 500%) or use the Zoom in or Zoom out buttons. The Zoom buttons are situated in the lower right corner and are used to zoom in and out of the current sheet. The list of sheets also displays the sheet status,Ĭlick the appropriate Sheet Tab next to button. ![]() The Sheet Navigation buttons are situated in the left lower corner and are used to scroll the sheet list to the right/left and navigate among the sheet tabs.īutton on the status bar to open the list of all sheets and to select the sheet you need. You can also use the mouse scroll wheel to scroll your spreadsheet up or down. click any area to the left/right or above/below the scroll box on the scrollbar.use the combination of the Shift key and the mouse Scroll wheel to move horizontally.scroll the mouse wheel to move vertically.click the up/down or right/left arrows on the scrollbars.To navigate a spreadsheet using the scrollbars: The Scrollbars (at the bottom or on the right side) are used to scroll up/down and left/right the current sheet. Use the Tab key on your keyboard to move to the cell to the right of the selected one. ![]() To navigate through your spreadsheet, use the following tools: To restore its original width, move the border to the left. ![]() You can also change the size of the opened Comments or Chat panel using the simple drag-and-drop: move the mouse cursor over the left sidebar border so that it turns into the bidirectional arrow and drag the border to the right to extend the sidebar width. To minimize the right sidebar, click the icon once again. To expand it, select any object (e.g., image, chart, shape) and click the icon of the currently activated tab on the right. The right sidebar is minimized by default. Right Panel - when disabled, hides the right panel where Settings are located.Left Panel - when disabled, hides the left panel where Search, Comments, etc.If you disable it, the status bar will appear in two lines. Combine Sheet and Status Bars - displays all sheet navigation tools and status bar in a single line.Always Show Toolbar - when this option is disabled, the top toolbar that contains commands will be hidden while tab names remain visible.Īlternatively, you can just double-click any tab to hide the top toolbar or display it again.Show Zeros - allows “0” to be visible when entered in a cell.To show the hidden Gridlines, click this option once again. Gridlines - when disabled, hides the lines around the cells.To show the hidden Headings, click this option once again. Headings - when disabled, hides the column heading at the top and row heading on the left side of the worksheet.Dragging formula bar bottom line to expand it toggles Formula Bar height to show one row. To show the hidden Formula Bar, click this option once again. Formula Bar - when disabled, hides the bar below the top toolbar which is used to enter and review the formulas and their contents.To unfreeze the panes, just click this option once again or right-click anywhere within the worksheet and select the Unfreeze Panes option from the menu. Freeze Panes - freezes all the rows above the active cell and all the columns to the left of the active cell so that they remain visible when you scroll the spreadsheet to the right or down.Interface Theme - choose one of the available interface themes from the drop-down menu: Same as system, Light, Classic Light, Dark, Contrast Dark.Zoom - to set the required zoom value from 50% to 500% from the drop-down list.To learn more about sheet views, please read the following article. To adjust default view settings and to set the most convenient mode to work with the spreadsheet, go to the View tab. To help you view and select cells in large spreadsheets, the Spreadsheet Editor offers several tools: adjustable bars, scrollbars, sheet navigation buttons, sheet tabs and zoom. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |