Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

Importing & Printing

Importing & Printing

Importing Data

1. To import data into a spreadsheet select Data from the menu and click on Import External Data.



2. Locate the file you would like to download. In this example, we are importing a tab delimited text file called downloadable.txt. [ download this file to use while working with the tutorial ]



3. The Text Import Wizard will launch automatically. Make sure Delimited is checked and click Next.



4. Select Tab and click Next.



5. Click Finish.



6. Select where you would like to put the data. You can either put it in the existing worksheet at the specified cell or in a new worksheet.



7. Here is how the spreadsheet should appear when the data has been successfully imported.

Printing Spreadsheets

1. Select View from the menu and click on Page Break Preview.



2. Use the blue lines that appear on the spreadsheet to adjust the page edges for printing.

Watch the video

choose format/speed
dial-up | broadband

html transcript