Worksheet Toolbar


This is the worksheet toolbar. It can be placed top,left,right or bottom of the worksheet.

Button Actions

document-open.jpg Open File: Opens a csv file.
filesave-2.jpg Save File: Saves the current file
addline.jpg Add a new row: Add a new row at the end of the file.
insert_table_row.jpg Insert a row: Insert a new row at current position
delete_table_row.jpg Delete row: Delete the current row.
go-top.jpg Jump to top row
go-first.jpg Jump to first column
go-last.jpg Jump to last column
go-bottom.jpg Jump to last row
fill.jpg Fill column Fill column with value of cell above.
When filling, if you choose to not overwrite, then only empty cells will be filled.
increment.jpg Increment: Increment column cells from cell above.
When incrementing, if you choose to not overwrite, then the increment will stop at the first cell containing data.
clipboard_24.jpg
Special Copy: This will copy a single row of data to the clipboard and format it suitable for use in other applications.

Two formats are available. List and Tabulated By default List is used.
To tabulate data, hold down CTRL key when clicking the Copy button.

How to copy. The data copied will be from the current cell to the end of the row. Or from the start of the row to the current cell, if the SHIFT key is held down when clicking the Copy button.

Example to copy as List
1. place the cursor in the row you want to copy, in the column you want to start copying from.
2. Click the Copy button.
The row is copied and formatted from the current column to the last column.

Example formatted as List
FirstName: John
Surname: Hunt
BuriedBy: Joshua Brookes Chaplain
Relationship: son
MotherFirst: Mary
MotherSurname: Hunt
Source: LDS Film 2356998
Parish: Manchester
Church: Cathedral
Register: Burials 1792-1800

How to copy as Tabulated
1. place the cursor in the row you want to copy, in the column you want to start copying from.
2. Hold down CTRL and Click the Copy button.
The row is copied and formatted from the current column to the last column.

To copy Tabulated and from first column to current column, Hold down CTRL and SHIFT when clicking the Copy button.

Example formatted as Tabulated
First,Surname,BuriedBy,Relationship,MotherFirst,MotherSurname
John,Hunt,Joshua Brookes Chaplain,son,Mary,Hunt
clippaste_24.jpg  
file_lock_on_24.jpg Lock/Unlock Data: Lock or unlock the worksheet edit mode. Prevents accidental editing when viewing data.
find_replace_24.jpg Find and Replace: Open Find & Replace dialog. Do not confuse this with the Search Filter at the bottom right of the worksheet
help2_24.jpg Help: Show help