Hi Kevin, thanks for the link.

Do you know of any way that I can copy and paste data, for example from an excel spreadsheet or other table format, into my DataGridView and it will paste into the correct cells so its layout remains the same, eg Column A will be filled with all relevant data etc etc...is there a property on the datagridview which would allow this?