|
21- What’s on the Ribbon?
Copy
(Cut), and Paste:
You
can copy (or cut) the contents of a cell and then paste the contents to a
different cell. To copy: select the cell you want to copy contents from, click
the copy button (found under the Home tab in the Clipboard section,
select the cell you want to paste to, and finally click the paste button. Note:
To perform this operation quicker use the hot key sequence Cntrl-c to
invoke the copy (use Cntrl-x to invoke a cut)
and then Cntrl-v to invoke a paste
Copy/Paste
with AutoFill :
To
copy the contents of a cell to neighboring cells (along a row, column, or block
of cells) use the AutoFill feature, which is the square located at
the bottom right corner of the active cell. For example, to copy the number
22 in cell A1 (see left figure) to the cells in A2:A4, first
click on the cell to activate it. Move your cursor over the AutoFill square so
that your mouse pointer turns into a thin cross. Click down on the square with
the left mouse button and drag your mouse to A4 (see middle figure).
Release you’re
the left mouse button and you will see the result of the copy/paste in A2:A4 (see right figure).
Home
Ribbon :
The
Home ribbon is the first place to start because it contains commands related to
editing the content of a cell and the worksheet.
Text
Formatting:
Format
text values using the commands in the Font Section such as the font
type, font size, color, bold, italics, etc. Use the All Borders button to
change the border attributes of blocks of cells.
Position
values in a cell both horizontally and vertically. If the text you type in a
cell is longer than the width of the cell use the Wrap Text button to
fit the text by adjusting the size and shape of the cell. If you would like to
merge text in adjacent cells, then highlight all the cells and then press the Merge
and Center button.
Number
Formatting :
Format
number values as you would like them to be displayed using the Number section.
You can determine the number of digits to be displayed after the decimal place
as well.
22- Making your way around the Ribbon
The ribbon consists of:
·
Home
tab: allows you to do:
-
Formatting-
alignments- numbering formats- ability to work with cells-editing the data.
·
Insert
tab: allows you to work with:
- Pivot tables and other tabular formats - graphical illustrations - access charting options – linking - putting different texts in headers.
·
Page
layout: let you:
- how your data will be printing.
·
Formulas:
this make it easy to:
- access functions and applications - create your own functions.
·
Data:
here you have the ability to:
-
Look
at the sort and filter and a different commands to access your data sheet.
·
Review
: allows you to:
- do your proofing in the excel environment – work with spell checker - ability to share the information - commenting feature – work with track changes – protecting your worksheet.
·
View:
lets you :
- Work with other windows - change the view to see all of the page - easy and quick back to normal view. 23- Customizing the Ribbon
Add a command to
the Quick Access Toolbar:
You can add a command to the Quick Access Toolbar from
a list of commands in the Program Name Options dialog box, where Program
Name is the name of the program you are in.
1)
Click the Microsoft Office Button
2)
Click Customize.
§
Use the Quick Access Toolbar
1)
Click Customize Quick Access Toolbar
In the list, click More Commands.
2)
In the Program Name Options dialog box,
in the Choose commands from list
3)
In the list of commands in the selected category,
click the command that you want to add to the Quick Access Toolbar, and then
click Add.
4)
After you finish adding any other command that you
want, click OK.
The Quick Access Toolbar can be located in one of two
places:
*
Upper-left corner next to the Microsoft Office Button
*
Below the Ribbon If you don’t want the Quick Access Toolbar to be
displayed in its current location, you can move it to the other location. If
you find that the default location next to the Microsoft Office Button
1.
Click Customize Quick Access Toolbar.
2.
In the list, click Show Below the Ribbon.
Minimizing the Excel 2007 Ribbon:
Microsoft
provides the ability to minimize the ribbon if you are short on screen space.
3.
Right-click
on any of the boxes in the ribbon.
4.
Select Minimize the Ribbon.
24- Customizing the Microsoft Office Button
Excel 2007 offers a wide range of customizable options
that allow you to make Excel work the best for you. To access these customizable
options:
§
Click the Office Button
§
Click Excel Options
ocular:
Proofing:
Save:
Advanced:
Customize:
Back To Top Back To Excel Index Page (Open Exercise file)
|
