Click anywhere and type. There are no cells to enter or leave: a value is the text between two delimiters, a row is a line, and what you type goes into the file exactly as you type it.

- A **comma** (or the file’s delimiter) ends a value and starts the next one.
- `Enter` starts a new row.
- `Tab` types a tab character, which in a tab-separated file is the delimiter. To move from one value to the next, use `Ctrl` + `Alt` + `→``⌥`  `⌘`  `→` and `Ctrl` + `Alt` + `←``⌥`  `⌘`  `←`.

While you type in a column that is lined up on its decimal point, its **@** or its colon, it stays lined up, even when what you have typed so far isn’t a number or an address yet. See [Numbers, dates and other values](/content/help/reading/values-by-type/index.html#when-a-column-isnt-lined-up).

## Quotes

A value that contains the delimiter, a quote or a line break goes between double quotes: """Paris, France""". Typing `"` at the start of a value types the closing quote too, so that a half-written value never swallows the rest of the line. Inside quotes, a quote is written twice: `"the ""best"" one`.

You don’t need to do this for the operations of the Table, Rows, Columns and Cells menus: a value they change gets its quotes when it needs them, and keeps the ones it had.

## A new file

A new file, or a file that opens empty, takes its delimiter and header row from what you type or paste into it: paste a few rows separated by semicolons and it becomes a semicolon-separated file, with or without a header, as it would if you had opened it. As soon as you pick a delimiter or switch the header row by hand, your choice stays. See [Delimiter and header row](/content/help/files/delimiter-and-header/index.html).

## Copy and paste

`Ctrl` + `C``⌘`  `C` and `Ctrl` + `X``⌘`  `X` with nothing selected take the whole line, and `Ctrl` + `V``⌘`  `V` pastes it as a line. With several cursors, each copies its own selection; pasting as many lines as there are cursors puts one line at each, so a column copied from the [column bar](/content/help/editing/selecting-columns-and-rows/index.html#whole-columns) pastes back value by value.

To copy whole rows, select them on the line numbers: see [Selecting columns and rows](/content/help/editing/selecting-columns-and-rows/index.html#whole-rows).

## A table from a spreadsheet

Cells copied from Excel, Google Sheets or LibreOffice, or a table copied from Word or a web page, reach the clipboard separated by tabs. Pasted into a file with another delimiter, they become rows of the file: each tab becomes the file’s delimiter, and a value that needs quotes in the file gets them (`"Smith, John"` in a comma-separated file). Everything else goes in exactly as it was copied: numbers, dates and spaces are not changed.

A message says how many rows and columns went in. Its **Paste as Is** button puts the text back as it came, tabs and all, and `Ctrl` + `Z``⌘`  `Z` takes the whole paste away in one step.

This only happens when what you paste looks like a table: a tab between values, and the same number of values on every row. A single value, rows of different lengths, or anything pasted into a tab-separated file goes in as it is. So does a table pasted into a [new, empty file](/content/help/editing/typing/index.html#a-new-file): it becomes the file, tab-separated, as if you had opened it.

### A table without tabs

Some programs copy a table with no tabs in its text, a line for each cell, and the table only in the formatted copy that goes with it. When the text you paste with `Ctrl` + `V``⌘`  `V` has no tabs and what was copied is a table and nothing else, Trusty CSV reads the table instead, in any file, also a tab-separated or a new one, with the same message and **Paste as Is**. A cell’s text is what you saw: line breaks where it had them, spaces as they showed. A cell that spans several columns gives its value and then empty values; one that spans several rows, empty values in the rows below. A page with a table and text around it isn’t a table: its text goes in as it is. Edit › Paste pastes text only.
