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

Cut/copy/paste data

Use basic clipboard operations

To cut, copy and paste data in the current spreadsheet make use of the right-click menu or use the corresponding icons at the top toolbar,

  • Cut - select data and use the Cut option from the right-click menu to delete the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same spreadsheet.

  • Copy - select data and either use the Copy Copy icon icon at the top toolbar or right-click and select the Copy option from the menu to send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same spreadsheet.

  • Paste - select a place and either use the Paste Paste icon icon at the top toolbar or right-click and select the Paste option to insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same spreadsheet.

To copy or paste data from/into another spreadsheet or some other program use the following key combinations:

  • Ctrl+X key combination for cutting;
  • Ctrl+C key combination for copying;
  • Ctrl+V key combination for pasting.

Note: instead of cutting and pasting data within the same worksheet you can select the necessary cell/range of cells, hover the mouse cursor over the selection border so that it turns into the Arrow icon icon and drag and drop the selection to the necessary position.

Use Auto Fill option

To quickly fill multiple cells with the same data use the Auto Fill option:

  1. select a cell/range of cells containing the necessary data,
  2. move the mouse cursor over the fill handle in the right lower corner of the cell. The cursor will turn into the black cross:

    Auto Fill

  3. drag the handle over the adjacent cells you want to fill with the selected data.

Note: if you need to create a series of numbers (such as 1, 2, 3, 4...; 2, 4, 6, 8... etc.) or dates, you can enter at least two starting values and quickly extend the series selecting these cells and dragging the fill handle.

Fill cells in the column with text values

If a column in your spreadsheet contains some text values, you can easily replace any value within this column or fill the next blank cell selecting one of already existing text values.

Right-click the necessary cell and choose the Select from drop-down list option in the contextual menu.

Select from drop-down list

Select one of the available text values to replace the current one or fill an empty cell.

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.