AVS4YOU >> AVS Document Editor >> Manage sheets

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

Manage sheets

By default a newly created spreadsheet has a single sheet. The most simple way to add a new one is to click the Plus button button located to the right of the Sheet Navigation buttons in the left lower corner.

Another way to add a new sheet is to:

  1. right-click the sheet tab after which you wish to insert a new one,
  2. select the Insert option from the right-click menu.

A new sheet will be inserted after the selected one.

To activate the necessary sheet use the sheet tabs in the left lower corner of each spreadsheet.

Note: if you have a lot of sheets to find the necessary one make use of the Sheet Navigation buttons situated in the left lower corner.

To delete an unnecessary sheet:

  1. right-click the sheet tab you wish to delete,
  2. select the Delete option from the right-click menu.

The selected sheet will be deleted from the current spreadsheet.

To rename an existing sheet:

  1. right-click the sheet tab you wish to rename,
  2. select the Rename option from the right-click menu,
  3. enter the Sheet Name in the dialog box and click OK.

The selected sheet name will be changed.

To copy an existing sheet:

  1. right-click the sheet tab you wish to copy,
  2. select the Copy option from the right-click menu,
  3. select the sheet before which you wish to insert the copied one or use the Copy to end option to insert the copied sheet after all the existing ones,
  4. click the OK button to confirm your choice.

The selected sheet will be copied and inserted in the selected place.

To move an existing sheet:

  1. right-click the sheet tab you wish to move,
  2. select the Move option from the right-click menu,
  3. select the sheet before which you wish to insert the selected one or use the Move to end option to move the selected sheet after all the existing ones,
  4. click the OK button to confirm your choice.

Or simply drag the necessary sheet tab and drop it to a new location. The selected sheet will be moved.

If you have a lot of sheets, you can hide some of them you don't need for the moment to facilitate the work. To do that,

  1. right-click the sheet tab you wish to hide,
  2. select the Hide option from the right-click menu,

To display the hidden sheet tab, right-click any sheet tab, open the Hidden list and select the sheet tab you wish to display.

To differentiate the sheets you can assign different colors to the sheet tabs. To do that,

  1. right-click the sheet tab you wish to color,
  2. select the Tab Color option from the right-click menu,
  3. select any color in the available palettes

    Palette

    • Theme Colors - the colors that correspond to the selected color scheme of the spreadsheet.
    • Standard Colors - the default colors set.
    • Custom Color - click this caption if there is no needed color in the available palettes. Select the necessary colors range moving the vertical color slider and set the specific color dragging the color picker within the large square color field. Once you select a color with the color picker, the appropriate RGB and sRGB color values will be displayed in the fields on the right. You can also specify a color on the base of the RGB color model entering the necessary numeric values into the R, G, B (red, green, blue) fields or enter the sRGB hexadecimal code into the field marked with the # sign. The selected color appears in the New preview box. If the object was previously filled with any custom color, this color is displayed in the Current box so you can compare the original and modified colors. When the color is specified, click the Add button:

      Palette - Custom Color

      The custom color will be applied to the selected tab and added to the Custom color palette.

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.