Working with data

You can perform basic actions with data, as well as:

• Enter data.
• Change data number format.
• Use data validation.
• Insert link.
• Insert current date and time.
• Filter, sort data.
• Find and replace data.
• Remove duplicates.
• Delete data.

You can perform various actions with data.

Find data

You can quickly find data in a document using the Find pane.

Open the Find pane and find data

1. Press Ctrl+F (Cmd+F). The Find pane will open.
2. Enter the desired text in the Find field.
3. If necessary, configure additional Parameters.
4. To go to a match in the text, click on the match in the pane.
5. To go to the next or previous match, click the or buttons.

You can also use the Find tool in the sidebar.

If the file has names for ranges, you can search for them using the Name manager tool in the sidebar.

Copy data

You can copy data from selected cells to the clipboard.

Copy cell data

1. Select the cells containing the data.
2. Press Ctrl+C (Cmd+C).

You can also use the Copy tool in the context menu.