charline-picon.com Excel Starter 2010 is a spreadsheet program designed for everyday tasks together as setting up a budget, maintaining an deal with list, or maintaining track of a perform of to-do items. Excel Starter is part of charline-picon.com Office Starter 2010, and comes pre-loaded on her computer.

You are watching: An excel file is called a

Excel Starter 2010 is very similar to charline-picon.com Excel 2010 in appearance. If girlfriend are brand-new to the Ribbon user interface or the Backstage view, Excel Starter gives you an chance to obtain accustomed come the brand-new interface prior to upgrading to Excel 2010.

Excel Starter different from the finish version that Excel in the it has display advertising, and it walk not charline-picon.com the progressed features that the finish version the Excel. If you uncover that you want much more features, you deserve to upgrade come Excel 2010 appropriate from Excel Starter 2010. Just click Purchase ~ above the Home tab top top the ribbon.

What carry out you desire to do?

Open Excel Starter and take a look at around

Open Excel Starter through the Windows begin button.

Click the Start switch

*
. If Excel Starter is no included among the perform of program you see, click All Programs, and also then click charline-picon.com Office Starter.

Click charline-picon.com Excel Starter 2010.

The Excel Starter startup display appears, and also a blank spreadsheet is displayed. In Excel Starter, a spreadsheet is dubbed a worksheet, and worksheets are stored in a record called a workbook. Workbooks deserve to have one or an ext worksheets in them.

*

1. Columns (labeled through letters) and also rows (labeled through numbers) make up the cells of her worksheet.

2. Click the File tab opens up the Backstage watch of her workbook, where you have the right to open and also save files, acquire information about the present workbook, and perform other work that perform not have to do with the content of the workbook, such as printing it or sending out a copy of that in e-mail.

3. Each tab in the ribbon displays regulates that are grouped through task. You"ll most likely spend most of your time utilizing the Home tab, as soon as you"re entering and also formatting data. Usage the Insert tab to include tables, charts, pictures, or other graphics to her worksheet. Use the Page Layout tab to readjust margins and layout, particularly for printing. Usage the Formulas tab to make calculations ~ above the data in her worksheet.

4. The pane follow me the side of the Excel Starter home window includes web links to assist and shortcuts to templates and also clip art, to offer you a head-start on creating workbooks for certain tasks, such as controlling a membership perform or tracking expenses. The pane also displays advertising and a link to acquisition a full-feature execution of Office.

top of web page

Create a new workbook

When you produce a workbook in charline-picon.com Excel Starter 2010, you can start from scrape or you can start native a template, where few of the occupational is currently done for you.

Click File, and also then click New.

*

If you want to begin with the indistinguishable of a blank grid, click Blank workbook.

*

If you desire a head-start top top a specific kind the workbook, pick one that the templates available on Office.com. Select from budgets, occasion planners, member lists, and also more.

*

Excel Starter opens the blank workbook or template, prepared for girlfriend to include your data.

peak of web page

Save a workbook

When you interrupt your work-related or quit, you have to save her worksheet, or friend will lose your work. Once you conserve your worksheet, Excel Starter create a paper called a workbook, which is save on computer on her computer.

Click the Save switch

*
on the Quick access Toolbar.

(Keyboard shortcut: press CTRL+S.)

If this workbook was already saved together a file, any type of changes girlfriend made are automatically saved in the workbook, and you can proceed working.

If this is a brand-new workbook the you have not yet saved, type a surname for it.

Click Save.

top of web page

Enter data

To occupational with data ~ above a worksheet, you first have to enter that data in the cell on the worksheet.

Click a cell, and then type data in the cell.

Press go into or TAB to move to the following cell.

Tip To go into data on a new line in a cell, enter a line break by pressing ALT+ENTER.

To enter a series of data, such together days, months, or steady numbers, kind the starting value in a cell, and also then in the next cell form a worth to establish a pattern.

For example, if you want the series 1, 2, 3, 4, 5..., type 1 and also 2 in the first two cells.

Select the cells the contain the beginning values, and also then traction the fill handle

*
throughout the selection that you want to fill.

Tip To fill in raising order, drag down or to the right. To to fill in to decrease order, drag up or to the left.

peak of page

Make that look right

You can layout text and also cells to make her worksheet watch the method you want.

To wrap message in a cell, select the cells that you desire to format, and then ~ above the Home tab, in the Alignment group, click Wrap Text.

*

To adjust column width and also row height to automatically fit the materials of a cell, select the columns or rows that you want to change, and then ~ above the Home tab, in the Cells group, click Format.

*

Under Cell Size, click AutoFit tower Width or AutoFit row Height.

Tip To quickly autofit all columns or rows in the worksheet, click the Select All button, and also then double-click any type of boundary in between two shaft or heat headings.

*

To readjust the font, select the cells the contain the data the you desire to format, and then top top the Home tab, in the Font group, click the style that you want.

*

To use number formatting, click the cabinet that has the numbers that you want to format, and also then on the Home tab, in the Number group, point to General, and then click the style that girlfriend want.

*

For more help through entering and also formatting data, see rapid start: style numbers in a worksheet.

peak of page

Copy, move, or delete data

You can use the Cut, Copy, and also Paste commands to move or copy rows, columns, and cells. To copy, press CTRL+C to use the Copy command. To move, press CTRL+X to use the Cut command.

Select the rows, columns, or cells you desire to copy, move, or delete.

To pick a heat or column, click the heat or shaft heading.

*

1. Row heading

2. Tower heading

To pick a cell, click the cell. To pick a variety of cells, click click and also drag, or click and use the arrow keys while holding down the shift key.

Press CTRL+C come copy or CTRL+X come cut.

If you desire to delete a row or column, pushing DELETE while the row or columns is selected gets rid of the contents, leave an empty heat or cell. Come delete a row or column, right-click the heat or column heading, and also then click Delete Row or Delete Column.

Note Excel screens an animated relocating border approximately cells that have actually been reduced or copied. To cancel a moving border, press ESC.

Position the cursor wherein you desire to copy or move the cells.

To copy or move a heat or column, click the heat or shaft header that complies with where you desire to insert the row or shaft you copied or cut.

To copy or relocate a cell, click the cell whereby you desire to dough the cell you copied or cut.

To copy or move a range of cells, click the upper-left cell of the dough area.

Paste the data in the new location.

For rows or columns, right-click the row or tower heading in ~ the brand-new location, and then click the Insert command.

For a cell or range of cells, press CTRL+V. The cells you duplicated or cut replace the cell at the new location.

For more information about copying and pasting cells, see move or copy cells and also cell contents

peak of web page

Change the order

When you sort details in a worksheet, you can see data the way you want and find worths quickly.

Select the data that you want to sort

Use the computer mouse or keyboard regulates to select a selection of data, such together A1:L5 (multiple rows and columns) or C1:C80 (a solitary column). The variety can incorporate titles the you developed to determine columns or rows.

To type with just two mouse clicks, click Sort & Filter, and then click one of two people of the Sort buttons.

*

Select a single cell in the pillar on i beg your pardon you desire to sort.

Click the top switch to execute an ascending kind (A to Z or the smallest number come largest).

Click the bottom button to execute a descending kind (Z come A or biggest number come smallest).

optimal of web page

Filter the end extra information

By filtering info in a worksheet, girlfriend can discover values quickly. You deserve to filter ~ above one or an ext columns the data. You manage not just what you desire to see, but likewise what you desire to exclude.

Select the data the you desire to filter

On the Home tab, in the Edit group, click Sort & Filter, and also then click Filter.

*

Click the arrowhead

*
in the pillar header to display screen a perform in i beg your pardon you have the right to make filter choices.

Note relying on the kind of data in the column, Excel Starter display screens either Number Filters or Text Filters in the list.

For an ext help v filtering, see fast start: Filter data by using an AutoFilter.

height of web page

Calculate data through formulas

Formulas space equations that can perform calculations, return information, manipulate the materials of various other cells, test conditions, and more. A formula constantly starts through an equal authorize (=).

Formula

Description

=5+2*3

Adds 5 come the product that 2 time 3.

=SQRT(A1)

Uses the SQRT duty to return the square root of the worth in A1.

=TODAY()

Returns the present date.

=IF(A1>0)

Tests the cabinet A1 to recognize if it has a value better than 0.

Select a cell and start typing

In a cell, form an equal authorize (=) to begin the formula.

Fill in the rest of the formula

Type a combination of numbers and operators; because that example, 3+7.

Use the mouse to choose other cells (inserting an operator between them). For example, select B1 and then form a plus sign (+), choose C1 and kind +, and then select D1.

Type a letter to choose from a list of worksheet functions. For example, keying "a" display screens all accessible functions that begin with the letter "a."

*

Complete the formula

To complete a formula that supplies a combination of numbers, cell references, and also operators, push ENTER.

To complete a formula that offers a function, to fill in the forced information because that the function and then press ENTER. Because that example, the ABS function requires one numeric value — this can be a number that you type, or a cell the you pick that includes a number.

peak of web page

Chart her data

A graph is a visual depiction of her data. By using aspects such as columns (in a shaft chart) or lines (in a line chart), a graph displays collection of numeric data in a graphical format.

*

The graphical style of a chart renders it simpler to understand large quantities of data and also the relationship between different collection of data. A graph can also show the large picture so that you have the right to analyze her data and look for vital trends.

Select the data the you want to chart.

*

Tip The data must be arranged in rows or columns, through row brand to the left and also column labels over the data — Excel instantly determines the best method to plot the data in the chart.

On the Insert tab, in the Charts group, click the chart form that you want to use, and also then click a chart subtype.

*

Tip To see all obtainable chart types, click

*
to launch the Insert Chart dialog box, and then click the arrows come scroll through the graph types.

*

When you rest the computer mouse pointer over any chart type, a ScreenTip display screens its name.

For much more information about any the the chart types, see available chart types.

peak of web page

Print

Before you publish a worksheet, it"s a good idea to preview it to make certain that it looks the method you want. When you preview a worksheet in Excel, it opens up in the charline-picon.com Office Backstage view. In this view, friend can change the page setup and layout before you print.

To print a portion of a worksheet, click the worksheet, and then pick the variety of data the you want to print. To print the entire worksheet, click the worksheet to activate it.

Click File, and then click Print.

Keyboard faster way You can additionally press CTRL+P.

Note The preview home window displays black and also white, nevertheless of even if it is your record includes color, unless you are using a press that have the right to print color.

Click Print.

*

height of web page

Share, using e-mail or the Web

Sometimes girlfriend will desire to share her workbook with others. If you space sharing the workbook through someone who additionally has Excel, you can send her workbook as an attachments to an e-mail message. The recipient deserve to open the workbook in Excel to work with it.

Note Using commands for sending e-mail attachments calls for that you have actually an e-mail program, together as home windows Mail, installed on your computer.

If her goal is because that the recipient to watch the workbook, quite than edit it, you have the right to send a snapshot of the workbook, as a PDF or XPS file.

Click the File tab, and then click Save & Send.

Click Send using E-mail

Do one of the following:

To send the workbook together an Excel file, click Send as Attachment.

To send the workbook as a snapshot, click Send as PDF or Send together XPS.

Your e-mail regime starts an e-mail article for you, through the specified kind of record attached. Compose your e-mail, and then send it.

An different to sending the workbook is to store it in home windows Live OneDrive. This way, you have actually a single copy of the workbook the is easily accessible to others. You can send people a connect to the workbook, where they have the right to view it, and even modify it in their Web web browser (if you give them permission).

Click the File tab, and then click Save & Send.

Click Save come Web.

Click Sign In, get in your windows Live ID and password, and also click OK.

If you usage Hotmail, Messenger, or Xbox Live, you currently have a windows Live ID. If you don"t have actually one, click Sign up because that a brand-new account to create a brand-new Windows Live ID.

Select a folder in OneDrive and also click Save As. Form a surname for your file and click Save.

The document is now saved top top OneDrive. In OneDrive, you have the right to give world permission to view and also edit the components of her folders. Once you desire to re-superstructure a workbook, girlfriend send a connect to it in e-mail.

For an ext information around storing your records in OneDrive, see save a file to OneDrive indigenous Office.

See more: Thread: Wondering How To Tell If A Pig Is Blind ? Thread: Wondering How To Tell If A Pig Is Blind

optimal of page

Get much more help

Office.com is consistently updated with new content, including how-to articles, videos, and training courses. If the bottom of the help Viewer claims Offline and also you are connected to the Internet, click Offline, and then click Show contents from Office.com.