CSV category¶
Exits separated value view mode. | |
Switches to CSV (comma-separated) mode. | |
Switches to TSV (tab-separated) mode. | |
Switches to user-defined DSV (delimiter-separated) mode. | |
Shows the document as the specified separated value mode (multiple items). | |
Toggles cell selection mode in CSV documents. | |
Temporarily shows the current CSV document without quotation marks or escape characters. | |
Shows or hides the column header. | |
Uses one-based numbering for the column header. | |
Uses alphabetical characters for the column header. | |
Uses zero-based numbering for the column header. | |
Freezes or unfreezes panes above and to the left of the current cell. | |
Freezes panes above and to the left of the current cell. | |
Unfreezes panes. | |
Freezes the first line as headings. | |
Freezes the first two lines as headings. | |
Freezes the first three lines as headings. | |
Freezes the first four lines as headings. | |
Unfreezes row headings. | |
Freezes the first column as row headings. | |
Freezes the first two columns as row headings. | |
Freezes the first three columns as row headings. | |
Freezes the first four columns as row headings. | |
Toggles the option to make column headings read-only. | |
Shows a pop-up menu to set headings. | |
Converts the current separated value document or fixed width column document to the specified separated value document (multiple items). | |
Converts the current separated value document to fixed-width columns using the current separator positions. | |
Shows or hides the CSV Converter. | |
Adjusts all separator positions in the CSV document. | |
Adjusts separator positions in visible lines only in a CSV document. | |
Hides the selected columns or the current column. | |
Unhides the selected columns or the current column. | |
Resets the width of the selected columns in a CSV document. | |
Aligns text in the selected columns, or the current column, to the left. | |
Centers text in the selected columns, or the current column. | |
Aligns text in the selected columns, or the current column, to the right. | |
Selects the current column (excluding headings) in vertical selection mode. | |
Selects the current column with headings in vertical selection mode. | |
Inserts a new column to the left of the current column in a separated value document. | |
Inserts a new column to the right of the current column in a separated value document. | |
Adds a new column to the right of the last column in a separated value document. | |
Duplicates the selected columns in a CSV document. | |
Moves or copies selected columns, or the current column, to the specified position in a CSV document. | |
Moves, copies, deletes, or sorts columns in the CSV document. | |
Combines selected columns in a CSV document. | |
Splits the selected columns in a CSV document. | |
Makes the number of columns the same in a CSV document. | |
Removes unnecessary double quotes in a CSV document. | |
Removes embedded newline characters in CSV documents. | |
Encloses all cells in a CSV document in double quotes. | |
Combines vertically adjacent duplicate cells in a CSV document. | |
Automatically fills values in the entire column of a CSV document. | |
Swaps rows and columns in the CSV document. | |
Creates a pivot table in the CSV document. | |
Converts columns into rows by unpivoting the CSV data. | |
Joins two CSV documents. | |
Extracts specified columns from the current CSV document. | |
Automatically detects and adds separators in Normal mode to prepare for conversion to fixed-width columns. | |
Adds or removes a separator at the cursor position (or the position pointed to on the ruler) in Normal mode to prepare for conversion to fixed-width columns. | |
Removes all separators in Normal mode. | |
Shows a pop-up menu for working with columns and separators. | |
Edits the current cell in a CSV document. | |
Clears the contents of the selection in the CSV document. | |
Jumps to the next cell in the CSV document. | |
Jumps to the previous cell in the CSV document. | |
Jumps to the cell above in the CSV document. | |
Jumps to the cell below in the CSV document. | |
Moves to the right edge of the current data region. | |
Moves to the left edge of the current data region. | |
Moves to the top edge of the current data region. | |
Moves to the bottom edge of the current data region. | |
Extends the selection to the right edge of the current data region. | |
Extends the selection to the left edge of the current data region. | |
Extends the selection to the top edge of the current data region. | |
Extends the selection to the bottom edge of the current data region. | |
Selects the cell at the cursor in CSV, TSV, or DSV mode. | |
Jumps to the next cell in CSV, TSV, or DSV mode. | |
Jumps to the previous cell in CSV, TSV, or DSV mode. | |
Shows a pop-up menu to select a CSV mode. |