As well as being able to view and bulk modify CSV files you can also manually edit individual cells. double clicking or pressing the Space key in a cell will place CSV Easy into an edit mode were you can alter the contents. Hitting Escape will cancel your edit and return will commit it.

Along with these you also have the standard windows Edit menu and some special extras

Standard Edit Menu

Undo, Cut, Copy and Paste do as expected with manipulating what is put on the clipboard and retrieved. Using these functions over a cell will alter the entire contents.

Revert History will go back in history one step. The equivalent of choosing the last drop down item from the History button. See the History section for more details.

Add, Clone and Delete Rows

Add Row will add a new blank row to the end of the data. Clone Row, will create a complete copy of the current row and add it to the end and Delete Row will remove the current row.

Paste Special

Append to Start	This pastes the clipboard contents in front of the current cell
Append to End	To the end of the current cell
Append to Start with Space	In front of the current cell with a space between the values
Append to End with Space	To the end of the current cell with a space between

Cell Editor

This will pop up the contents of the current cell in a larger, resizeable window. There you can edit the contents, with multiple lines if you wish.

Shifting

Shifting allows you to move sections of the current row left and right. This is especially useful for data that has loaded mis-aligned. There are four ways to shift as described below:

Right-Side Cells Left	Move cells to the right of the current cell one cell left
Left-Side Cells Right	Move cells to the left of the current cell one cell right
Right-Side Cells Right	Move cells to the right of the current cell one cell right
Left-Side Cells Left	Move cells to the left of the current cell one cell left

Splitting

If you have delimited data within a cell it can be very time consuming to split that data back out in to individual cells. Splitting provides an easy way to do so. Highlight a cell, navigate to the Split Cell menu and choose your marker (this will default to the open files delimiter). Now you have four options to choose from:

In Half to Left	Split the cell in two at the first marker, pasting the halves in the current cell and the adjacent one to the left
In Half to Right	The same as above, but pasted to the right
All to Left	Split the cell into all of its parts, pasting them from the current cell working to the left
All to Right	The same as above, but pasted to the right

Page last edited on 12/11/2009