Microsoft Excel: A Turorial
DR7 Help
 Site News
 Cooking with Sloan
 Search Form Guide
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 Archive Intro
 Table Descriptions
 Schema Browser
 Web Browsers
 Data Publications
 SkyServer Sites
 Contact Help Desk

Entering Data In an Excel Chart

When you open Excel, you will see a blank spreadsheet table as shown below:

To enter data, simply click on any cell and enter the values. Be sure to label your columns so you know what they represent. The first row of the table is usually dedicated to labels.

The diagram below shows a table containing the object ID, ra, dec, u, g, r, i, and z values for a group of stars:

You can also cut and paste data into the table from another source such as a web page. First, select the data you want by highlighting it. Copy the data to the clipboard by using Ctrl-c or by selecting copy under the Edit menu. In the spreadsheet, click on the cell where you want the top left entry of the data you copied to be placed. Paste the data by either using Ctrl-v or by selecting paste under the Edit menu.

If you want to paste Object IDs from SkyServer into Excel, read this workaround to learn how to paste them properly.