Powered by

AVS Document Editor
This page is available in EnglishFrançaisDeutschItalianoEspañol
AVS Document Editor
Download
AVS Document Editor
Current Version:  4.2.3.302
Release Date:  12/27/2016
File Size:
125.17 MB

View Settings and Navigation Tools

To help you view and select cells in a large spreadsheet Spreadsheet Editor offers several tools: adjustable bars, scrollbars, sheet navigation buttons, sheet tabs and zoom.

Adjust the View Settings

To adjust default view settings and set the most convenient mode to work with the spreadsheet, click the View Settings View Settings icon icon at the upper right corner of the top toolbar and select which interface elements you want to be hidden or shown. You can select the following options from the View Settings drop-down list:

  • View Compact Toolbar - enables a compact toolbar mode that provides access to basic features. To view the default toolbar click this option once again.
  • Hide Title Bar - hides the topmost bar where the spreadsheet name and the Go to Documents option are displayed. To show the hidden Title Bar click this option once again.
  • Hide Formula Bar - hides the bar situated below the top toolbar and used to enter and review the formula and its content. To show the hidden Formula Bar click this option once again.
  • Hide Headings - hides the column heading at the top and row heading at the left of the worksheet. To show the hidden Headings click this option once again.
  • Hide Gridlines - hides the lines that appear around the cells. To show the hidden Gridlines click this option once again.
  • 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. 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.

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 restore its original width move the border to the left.

Use the Navigation Tools

To navigate through your spreadsheet, use the following tools:

The Scrollbars (on the bottom or right side) are used to scroll up/down and left/right the current sheet. To navigate a spreadsheet using the scrollbars:

  • click the up/down or right/left arrows on the scrollbars;
  • drag the scroll box;
  • click any area to the left/right or above/below the scroll box on the scrollbar.

You can also use the mouse scroll wheel to scroll your spreadsheet up or down.

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.

  • click the Scroll to First Sheet Scroll to First Sheet button button to scroll the sheet list to the first sheet tab of the current spreadsheet;
  • click the Scroll Sheet List Left Scroll Sheet List Left button to scroll the sheet list of the current spreadsheet to the left;
  • click the Scroll Sheet List Right Scroll Sheet List Right button to scroll the sheet list of the current spreadsheet to the right;
  • click the Scroll to Last Sheet Scroll to Last Sheet button to scroll the sheet list to the last sheet tab of the current spreadsheet.

To activate an appropriate sheet click its Sheet Tab at the bottom next to the Sheet Navigation buttons.

The Zoom buttons are situated in the lower right corner and are used to zoom in and out the current sheet. 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 or use the Zoom In Zoom In button or Zoom Out Zoom Out button buttons. Zoom settings are also available in the View Settings View Settings icon drop-down list.

Download AVS Document Editor Current Version:  4.2.3.302File Size: 125.17 MB

Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.

AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.