The GenStat Spreadsheet

Introduction

• Guide to using the spreadsheet
• Guide to multi-paged books
• Understanding factors within a spreadsheet
• Using GenStat with Excel

How To...

• Create a new spreadsheet
• Load data from files
• Add data to a spreadsheet
• Import or export data
• Import data from Excel
• Rearrange spreadsheet columns
• Resize rows and columns in the spreadsheet
• Select data or cells
• Transfer data between windows and spreadsheets
• Save data from a spreadsheet
• Set an active spreadsheet

Menus

• About Spread Menu
• New Menu
• Column Menu
• Factor Menu
• Calculate Menu
• Delete Menu
• Insert Menu
• Select Menu
• Restrict/Filter Menu
• Manipulate Menu
• Sheet Menu
• Book Menu
• Add Menu
• Update Menu

Tools

• Right-click menu commands (Spreadsheet)
• Right-click menu commands (Books)
• Spreadsheet toolbar
• Active spreadsheet toolbar
• Spreadsheet Options

Navigation and Shortcut Keys

• Spreadsheet Cursor Keys
• Window Navigation Shortcuts
• Control Key Shortcuts
• Function Key Shortcuts
• Spreadsheet Navigation and Shortcuts

File Versions and Limits

• GenStat Spreadsheet File Formats
• Supported Data Formats
• Spreadsheet Limits