Renaming a Spreadsheet

Renaming a Spreadsheet

Google also lets you change the name of any spreadsheet you've saved. To rename a spreadsheet, follow these steps:


Select File, Rename.


When prompted, enter a new name for the spreadsheet.


Click the OK button.

The current spreadsheet is now assigned the new name.

Exporting a Google Spreadsheet to Excel Format

By default, all the spreadsheets you work with in Google Spreadsheets are stored on Google's servers. You can, however, download files from Google to your computer's hard drive to work with in Excel. In essence, you're exporting your Google spreadsheet to an XLS-format Excel file.

To export the current spreadsheet, follow these steps:


Select File, Download as .XLS.


When the File Download dialog box appears, as shown in Figure 13, click the Save button.

Figure 13. Downloading a Google Spreadsheets file.


When the Save As dialog box appears, as shown in Figure 14, select a location for the downloaded file, rename it if you like, and then click the Save button.

Figure 14. Saving a spreadsheet file in XLS format.

The Google Spreadsheets file is saved in XLS format on your hard disk. You can now open that file with Excel, and work on it as you would with any Excel spreadsheet. Know, however, that whatever changes you make to the file from within Excel affect only the downloaded file, not the copy of the spreadsheet that still resides on the Google Spreadsheets site. If you later want to reimport the Excel file to Google Spreadsheets, select File, Upload New Version to upload the changed spreadsheet from your PC to Google's servers.


You can also export a Google spreadsheet as a CSV-format file by selecting File, Download as .CSV. You can then import the CSV-format file into Excel or any other spreadsheet program. (Excel will not directly open CSV-format files, however; you'll have to use the import function from within Excel.)

Deleting a Spreadsheet

Spreadsheets you create with Google Spreadsheets are saved on Google's servers indefinitelyunless you choose to manually delete a file. To delete a file, follow these steps:


Be certain you want to delete a file before you attempt this operation. The delete action cannot be undone.


Open the spreadsheet you want to delete.


Select File, Delete.


When asked if you really want to delete the file, as shown in Figure 15, click OK.

Figure 15. Google prompts you before you delete a spreadsheet.

That's it. The selected file is now deleted from Google's servers.

Section 5. Entering and Editing Data

Entering data into a Google spreadsheet can be as simple as selecting a cell and starting typingdepending on the type of data you wish to enter. Google Spreadsheets lets you enter four different types of data, as detailed in Table 4.

Table 4. Types of Google Spreadsheets Data

Type of Data



Numbers can be in a variety of formats, including currency and percent formats. All numbers can be manipulated mathematically.


Text can contain both alphabetic and numerical characters. Text cannot be manipulated mathematically.


Dates are specially formatted numbers.


Formulas tell Google Spreadsheets how to make calculations using data in other cells.

All data can be formatted in a variety of styles. Formatting and styles are discussed in later lessons.