| Spreadsheet Toolbar |
| See Also |
You can customize the buttons that appear on the spreadsheet toolbar using the Customize Toolbar menu item (under the Tools menu). You can toggle whether to display the spreadsheet toolbar by right clicking on the background of any current toolbar and selecting the Spreadsheet item on the shortcut menu.
If the spreadsheet toolbar is set to be floating, then the toolbar will only appear in a pop-up window, when a spreadsheet window has the current focus.
An active spreadsheet toolbar is available for displaying the active sheet. The active sheet can be changed by selecting a new spreadsheet from the drop down list of currently open spreadsheets.
| Creates a new spreadsheet |
| Loads data from GenStat into a spreadsheet |
| Import Data from Excel file using Excel Import Wizard |
| Create a new spreadsheet from the Clipboard |
 | Adds data from GenStat into a spreadsheet |
 | Inserts a row at the current cursor position |
 | Inserts a column at the current cursor position |
 | Deletes the current row |
 | Deletes the current column |
 | Insert columns from Clipboard |
 | Insert rows from Clipboard |
 | Deletes the selected rows |
 | Delete pointer in spreadsheet |
 | Delete restricted rows |
 | Protects the current column (i.e. read only) |
 | Duplicates the current column |
 | Converts the current column to a factor |
 | Converts the current column to a text |
 | Converts the current column to a variate |
 | Toggle current cell with temporarily missing attribute |
 | Copy column names to the Clipboard |
 | Paste column names from the Clipboard |
 | Set default column width so all text is displayed |
 | Left justify text in a column |
 | Centre justify text in a column |
 | Right justify text in a column |
 | Specify a date format for a column |
 | Decrease decimal places in a column |
 | Increase decimal places in a column |
 | Split a text column into new columns |
 | Combine text columns into a new column |
 | Move/Copy columns between spreadsheets |
 | Reorder columns |
 | Promote first row of spreadsheet to be the column names |
 | Compare columns |
| Promote first row to column names |
 | Display column summary in output |
 | Change base date for a date column |
 | Copy spreadsheet as tabbed text to the Clipboard |
 | Copy spreadsheet inRTF format to the Clipboard |
 | Paste text to spreadsheet using the paste special options |
 | Bookmark cells by value |
 | Add BookMark Comment to Current Cell |
 | Column attributes/format |
 | Edit factor levels and labels |
 | Edit factor levels |
 | Edit factor labels |
 | Reorder factor levels |
 | Create a new factor as a product of other factors |
 | Change factor display |
 | Copy factor levels to Clipboard |
 | Paste factor levels from Clipboard |
 | Set factor reference level |
 | Remove unused factor levels from columns |
| Remove Unused Factor Levels |
| Change Factor Reference Level |
 | Display Spreadsheet properties |
 | Edit Spreadsheet title |
 | Analyse spreadsheet using associated directives |
 | Compare two spreadsheets |
 | Duplicate spreadsheet |
 | Resize a spreadsheet |
 | Copy spreadsheet filename to Clipboard |
 | Freeze/Unfreeze columns |
 | Set selected range |
 | Fill a column with a numerical sequence |
 | Fill groups with a numerical sequence |
 | Use Date/Time sequence to fill a column |
 | Calculate a summary for a spreadsheet |
 | Recode a columns values |
 | Recalculate columns |
 | Code column to groups |
 | Generate a random subset of rows |
| Change a date columns base date (1600<->1900) |
 | Calculate row summaries |
 | Display summary statistics for selected cells |
 | Filter/Restrict spreadsheet using an expression |
 | Filter/Restrict spreadsheet using factor levels |
 | Filter/Restrict spreadsheet using units by value |
 | Filter/Restrict spreadsheet using current cell's value |
 | Remove filter on spreadsheet rows |
 | Reverse current restriction/filter |
 | Subset restriction/filter to server |
 | Combine with existing or form new restriction excluding selected rows |
| Exclude selected rows from filter |
 | Save restriction or apply saved restriction |
 | Include only selected rows in filter |
 | Filter/Restrict to duplicated rows |
 | Appends data to the spreadsheet |
 | Merges data into the spreadsheet |
 | Stack columns in a spreadsheet |
 | Unstack columns in a spreadsheet |
 | Creates a new transposed spreadsheet |
 | Split/Subset spreadsheet |
 | Expand a spreadsheet |
 | Rename sheet tab in book |
 | Move sheet to new book |
 | Delete sheet from book |
 | Copy/Move sheets to book |
 | Reorder sheets in book |
 | Split sheets from book |
 | Save book (all sheets) to Excel file |
 | Add a blank sheet to the current book |
 | Update spreadsheet data to the server |
 | Fast update of spreadsheet data to the server and close |
| Subset Filter to Server |
 | Update changed data in a book to the GenStat Server |
 | Update all sheets of a book to the GenStat Server |
 | Run analysis using data from spreadsheet |
 | Create a graph using data from spreadsheet |
 | Sort the rows in a spreadsheet |
 | Duplicates the current row |
 | Set/Clear active sheet |
 | Add spreadsheet as a new worksheet in an Excel file |
 | Create a pointer in a spreadsheet |
| Add bookmark note/comment to current cell |
| Set selected range |
| Calculate summary statistics for selected cells. |