Button: New

The New button creates a new blank document using your default template.
The File | New command in the menu opens the New dialog, which will provide you with template options.
Open
The Open button brings up the dialog box for you to choose a document to be opened. The illustration is for
Excel 2000 on Windows 98, but it is very similar in other versions.
Recently opened files are listed at the end of the File menu. So, by using the
Menu can have quicker access to the documents you worked on recently.
Save
The Save button keeps the current document back to the place it came from. If the document has never been
If saved before, you will see a dialog box where you can choose a folder and file name.
You may have problems if you are editing an old document for a new purpose and don't want to lose it.
old. You should use the command in the menu, File | Save As to have the dialog box that
needs to be saved under a different file name. Otherwise, it will overwrite the old document.
Email
The Email button allows you to send the current worksheet or the entire workbook to another person.
by email.
Button: Print
It will print all the rows and columns that it thinks contain data.
Sometimes Excel gets confused if data has been deleted or if blank cells have been formatted. Always make a
Preliminary view, before printing a spreadsheet.
Suggestion: Use File | Print to open the Print dialog, where you can choose to print only
a part of the sheet or the workbook.
Button: Print Preview
Show how your document will look when printed. It should always have this view before
print. Through careful verification before actually printing, errors can be avoided and
save a lot of paper and time. It is especially important to have a preview of the sheets
calculation, because they are often too wide to fit on a single sheet.

Button: Spelling

It checks the spelling of your text but will not do so in the formulas. Excel does not correct your grammar.

Buttons:
Cut. Copy, and Paste
The Cut, Copy, and Paste buttons work as usual.
Cut removes the selected text and sends it to the Clipboard.
Copy places a copy of the selected text in the Clipboard.
Paste places a copy of what was in the Clipboard at the point where the cursor is located. (Go to the
tiny clipboard in the drawing of the Paste Button?)
When you want to paste a range of cells that you have cut or copied, just select the cell where you want it to go.
find it at the top left of the pasted data and paste it there.
When you paste data in Excel, it remains on the Clipboard only until you execute a command.
different rather than until I copy something new. So you will be able to paste the data several times.
followed in different places, but once I do something different, the data is deleted from the Clipboard.
Button: Copy Format
With the paintbrush icon, Format Painter, the format from one cell is copied to another.
How it works: First, select the cell with the format you want to use. Click on the button.
Copy Format. The mouse pointer changes to the shape of the Copy Format brush. Click on the cell that
You want it to have the same format. The mouse pointer changes back and you are done.
Format Paint can be applied to more than one site if you double-click the button. The mouse pointer
It will retain the Format Painter until I click the button again.
Copy Format only works with complete cells. It is not possible to use it to format only.
to a part of the text of a cell.
Copy Format will use the first format it finds. For example, if the text in the cell uses 2
different colors, Copy Format will use the first of the two colors used in the cell from which it is
copying.
Botones: Deshacer y Rehacer
The Undo button allows you to reverse an action you have just taken. Cancel allows you to change your mind.
and execute that action all over again.
Excel can only track 16 actions. Previously, in Excel 97, it was only possible to undo the last action.
No fun, at all!
The list of actions provides the existing cell reference for some of them. There is only one list for
Undo, which covers all the sheets of the workbook. Cell references do not include the name of
the spreadsheet. It’s easy to get confused!
Button: Hyperlink
The Hyperlink button opens a dialog to create a hyperlink in the spreadsheet.
When viewing a spreadsheet on the computer, clicking on its link opens the resource in the
URL used for it. This can be a webpage, another spreadsheet, a Word document, or
a sound file.
Button: AutoSum
AutoSum will intelligently sum the numbers in the column above or in the row to the left of the
active cell. Once you leave the cell with the formula, you will see the total instead of the formula.
Button: Paste Function
The button with the Paste function allows you to select one of the functions that Excel already knows and paste it.
inside a formula. For most functions, you will then see a new dialog where you can
enter each of the numbers that the function needs. You can even select a cell or range of
cells instead of writing the existing numbers.
Using dialogues will mean that you won't need to remember where all the parentheses and commas go.
the function. Very convenient!!
In Excel 2002/2003, the Paste Function button is on the left of the Formula bar.
Buttons: Order
The Ascending Order and Descending Order buttons will arrange the selected cells in a
column in numerical or alphabetical order.
If you have selected cells in rows and sort, the rows will be arranged based on what is in the first
cell of each row. To sort in a different column you must use the Sort dialog from the menu
commands, Data | Sort...
Be careful when ordering in a spreadsheet. You may have your data mixed up if you do not select.
all the cells that should remain together.
In Word, these buttons are in the Tables and Borders toolbar.
Button: Graphic Assistant
The Graph Assistant button opens an assistant that helps you convert your data into graphs.
 Button: Drawing
The Drawing button opens a drawing toolbar. This toolbar can be moved and parked in
any edge of the window, just like the other toolbars. Or it can be allowed to float like
a palette.
These tools are used to create graphics while remaining in a MS Office application.
The tools create vector drawings that use shapes instead of individual points.
These lessons do not use the Drawing bar to a great extent. There is only one measure of how much you can do.
one in a single course! (If you are interested, ask the Office Assistant or use Help to learn more.)
Control: Zoom
The Zoom control shows what size sheet the spreadsheet is being displayed in. By clicking on the
The arrow to the right of the control opens the list of options. The Zoom in Excel has a list of options.
shorter than that of Word.
Excel does not include the 'Full Page' option, but adds the 'Selection' option.
Button: Help
The Help button opens either a Help window or the Office Assistant dialog.
The Office Assistant can use any number of 'actors' to make its advice more
diverted.
To disconnect the Office Assistant, you first need to open it and then click on the Options button.
in the yellow dialogue that appears. The Office Assistant dialogue appears. In the options label,
check the box to use Office Assistant.

Button: Arrow
If you see a double arrow at the end of a toolbar in a Microsoft Office application
2000 there are more buttons assigned to the bar than it can display. You can make a
click on the arrows to open a menu that lists the other buttons.
The downward pointing arrow is always at the end of the toolbar. It opens a menu with a
Add/Remove command to modify which buttons are displayed on the toolbar
Format Bar
Control: Source
The Source control lists the current sources. All other installed sources are available in a list.
that is downloaded. The list shows the name of the font using it, except in Excel 97. It can have
any idea of what your text will look like even before you have applied that font.
Font Size
The Font Size controls the available list of points in a drop-down list. You can also type in
a size..
Botones: Negrita, Cursiva, Subrayado
The Bold, Italic, and Underline buttons apply their style to the selected text, bold, italic,
underlined.
Buttons: Align
The align buttons align the selected text or the text in the selected cells to the margin.
the left, to the center or to the right.
Button:
Merge and Center
The Merge and Center button will take the selected cells and create a single cell with all of them.
The content of the cell in the upper left will be centered in the new merged cell.
Everything that was in any other cell of the merged ones has been lost.
Buttons: Number Formats
The numbers you will often work with need different formats. Currency, Percentage and
Thousands are predefined formats for numbers.
Currency applies the format in the selection as money. The default adjustment for currency comes from the
Regional settings that are made in the Windows Control Panel. There you can change the format for
defect to pounds or rubles or any other currency that is usually used.
Percentage applies to the selected cell(s) a percentage, rounded to have no decimals.
Thousands applies to the selected cell(s) as a general number with commas separating every 3.
digits to the left of the decimal point and show only 2 digits to the right.
You can see a button for Euros. The button applies the symbol for amounts in Euros.
Other formats are available in the Format dialog: Format | Cells... | Number
Whatever format you use, the number in the cell does not change. The calculations
they will use the existing number and not the rounded one.
Buttons: Decimals
You can change the number of decimal places shown to the right of the decimal point in your
numbers using the Increase Decimal and Decrease Decimal buttons. The value in the cell, actually
It doesn't change. When the decimals are reduced, the values are rounded but displayed.
again when the number of places displayed increases.
If this cell is used in a calculation, the existing number is used instead of the rounded one.
Same number, with different formats
Example 1 -
large number
Example 2 -
number with decimals
General
3456789
1.6287
Currency
3,456,789.00
$ 1,63
Percentage
345678900%
163%
Coma
3,456,789.00
1.63
Increase of decimals from the original
3456789.0
1.62870
Decrease of decimals from the original
3456789
1,629
Buttons: Indents
You can have a text with indentation and another without it in a cell or text box with the buttons, Increase
Indent and Decrease Indent.
Button: Borders
You can add borders to the sides of your cells, or you can outline a cell or a range of cells.
cells. The arrow to the right of the button opens a palette of common options. There is a dialogue for even more
Format | Cells... | Borders
Button: Fill Color
A fill is the background color of a cell or text box. The Fill button shows the color that
it has been used last time. By clicking the button, that color is applied to any currently selected cell.
selected.
To change the colors, click on the down arrow next to the button. A color palette appears.
Just click on the color you want to use, or click on No Fill to remove one.
Button: Font Color
The Font Color is used to give color to the text in a cell or text box. The Font Color button
shows the last used color. By clicking the button, that color is applied to any text that
has been selected.
To change the colors, click on the downward arrow next to the button. A palette appears.
colors. Just click on the color you want to use, or click on Automatic, to use the colors by
defect.
Button: Arrow
If you see a double arrow at the end of a toolbar in a Microsoft Office application it is
there are more buttons assigned to the bar than it can display. You can click on the
arrows, to open a menu that lists the other buttons.
The arrow pointing down is always at the end of the toolbar. It opens a menu with a
Add/Remove command to modify which buttons are displayed on the toolbar