-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
آموزش Excel 2000-EN
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Aligning Text
[h=3]Aligning Text
You’ve probably noticed by now that Excel, like Word, left-aligns text (labels) by default.
However, Excel, by default, right-aligns numbers (values). This makes data easier to
read. Below, see examples of text (labels) aligned right, left, and centered.
Use the buttons of the Formatting toolbar to align text and numbers:
Basic text alignment can be reviewed in Office 2000 and Word 2000 lessons.
[h=3]Aligning Text
You’ve probably noticed by now that Excel, like Word, left-aligns text (labels) by default.
However, Excel, by default, right-aligns numbers (values). This makes data easier to
read. Below, see examples of text (labels) aligned right, left, and centered.
Use the buttons of the Formatting toolbar to align text and numbers:
Basic text alignment can be reviewed in Office 2000 and Word 2000 lessons.
[h=2]Aligning Text
[h=3]Another Alignment Option: Merge and Center
In Excel, you have another alignment option available to you: merge and center.
When you merge a cell, you are selecting more than one cell and creating one
large cell. You can center the contents of a cell across the new merged cell
Merge and center is helpful when creating worksheet titles.
[h=3]Another Alignment Option: Merge and Center
In Excel, you have another alignment option available to you: merge and center.
When you merge a cell, you are selecting more than one cell and creating one
large cell. You can center the contents of a cell across the new merged cell
Merge and center is helpful when creating worksheet titles.
[h=2]Aligning Text
[h=5]To Create a Title using Merge and Center:
Enter the title of the worksheet in the top left cell.
Select the first row of the worksheet (including the top left cell containing
the title of the worksheet). How many cells you select depends on how wide your label is
Click the Merge and Center button.
Excel only centers the text in the top left cell of the selection, so if the
title is in more than one row, merge and center each title row separately..
[h=5]To Create a Title using Merge and Center:
Enter the title of the worksheet in the top left cell.
Select the first row of the worksheet (including the top left cell containing
the title of the worksheet). How many cells you select depends on how wide your label is
Click the Merge and Center button.
Excel only centers the text in the top left cell of the selection, so if the
title is in more than one row, merge and center each title row separately..
[h=2]Aligning Text
[h=5]To Change Alignment using the Format Cells Dialog Box:
Select the range of cells you want to format.
Choose Format Cells from the menu bar or right-click and choose
Format Cells from the shortcut menu. The Format Cells dialog box opens
Click the Alignment tab.
Choose Horizontal, Vertical, Orientation, Merge, and wrap options.
Click OK.
Click next for a detailed explanation of the Format Cells dialog box Alignment tab.
[h=5]To Change Alignment using the Format Cells Dialog Box:
Select the range of cells you want to format.
Choose Format Cells from the menu bar or right-click and choose
Format Cells from the shortcut menu. The Format Cells dialog box opens
Click the Alignment tab.
Choose Horizontal, Vertical, Orientation, Merge, and wrap options.
Click OK.
Click next for a detailed explanation of the Format Cells dialog box Alignment tab.
[h=2]Aligning Text
[h=3]The Format Cells Dialog Box - Understanding the Alignment Tab
In the Alignment tab’s Text Alignment section, there are Horizontal and Vertical alignment options, as shown below:
The Horizontal section features a drop down box with left, center, and right alignment options.
It also features:
[h=5]General
The default alignment.
[h=5]Fill
"Fills" the cell with the current contents by repeating the contents for the width of the cell.
[h=5]Justify
Wraps the text in the cell and adjusts the spacing within each line so that all lines are as wide as the cell.
[h=5]Center Across Selection
Contents of the cell furthest to the left are centered across the selection
of cells. Similar to merge and center, except the cells are not merged
The Vertical section’s default is bottom. Top and Center are used to position the data close to the top or center of the cell.
[h=3]The Format Cells Dialog Box - Understanding the Alignment Tab
In the Alignment tab’s Text Alignment section, there are Horizontal and Vertical alignment options, as shown below:
The Horizontal section features a drop down box with left, center, and right alignment options.
It also features:
[h=5]General
The default alignment.
[h=5]Fill
"Fills" the cell with the current contents by repeating the contents for the width of the cell.
[h=5]Justify
Wraps the text in the cell and adjusts the spacing within each line so that all lines are as wide as the cell.
[h=5]Center Across Selection
Contents of the cell furthest to the left are centered across the selection
of cells. Similar to merge and center, except the cells are not merged
The Vertical section’s default is bottom. Top and Center are used to position the data close to the top or center of the cell.
[h=2]Aligning Text
[h=3]The Format Cells Dialog Box - Understanding the Alignment Tab
In the Orientation section of the Format Cells dialog box, you can orient text vertically or rotate text.
To rotate text to another orientation, use the Degrees spin box or click and drag the Text indicator.
To orient text vertically, click the box containing the vertical word Text.
[h=3]The Format Cells Dialog Box - Understanding the Alignment Tab
In the Orientation section of the Format Cells dialog box, you can orient text vertically or rotate text.
To rotate text to another orientation, use the Degrees spin box or click and drag the Text indicator.
To orient text vertically, click the box containing the vertical word Text.
[h=2]Aligning Text
[h=5]To Display a Vertical Title Across Several Cells:
Select the title and several cells below it.
Choose Format Cells from the menu bar
Click the Merge Cells check box to merge the cells.
Shrink to Fit shrinks the size of the font so it fits in the selected cells.
Wrap Text wraps the contents of a cell in case it’s too large for the cell boundaries.
[h=5]To Display a Vertical Title Across Several Cells:
Select the title and several cells below it.
Choose Format Cells from the menu bar
Click the Merge Cells check box to merge the cells.
Shrink to Fit shrinks the size of the font so it fits in the selected cells.
Wrap Text wraps the contents of a cell in case it’s too large for the cell boundaries.
[h=2]Fonts, Color, and Borders
[h=3]Fonts, Color, and Borders
Fonts, colors, and borders, as discussed in Word 2000, can enhance your
document and increase understanding by highlighting important information in an Excel worksheet
Important Terms:
Font is typeface.
Font color is applied to text.
A border is a line around a cell or group of cells.
[h=3]Fonts, Color, and Borders
Fonts, colors, and borders, as discussed in Word 2000, can enhance your
document and increase understanding by highlighting important information in an Excel worksheet
Important Terms:
Font is typeface.
Font color is applied to text.
A border is a line around a cell or group of cells.
[h=2]Fonts, Color, and Borders
[h=5]Selecting a Font Typeface:
Select some cells to change the typeface.
Click on the down arrow to the right of the Font Name list box. A drop-down list of available fonts appears.
Click on the font of your choice. The selection list closes and the new font is applied to the selected cells.
Remember, font choices vary depending on the software installed on your computer.
[h=5]Selecting a Font Typeface:
Select some cells to change the typeface.
Click on the down arrow to the right of the Font Name list box. A drop-down list of available fonts appears.
Click on the font of your choice. The selection list closes and the new font is applied to the selected cells.
Remember, font choices vary depending on the software installed on your computer.
[h=2]Fonts, Color, and Borders
[h=5]Selecting a Font Size:
Select some cells to change the font size.
Click on the down arrow to the right of the font size list box. A drop down list of available font sizes appears.
Click on the font size of your choice. The selection list closes and the new font size is applied to the selected cells.
[h=5]Selecting a Font Size:
Select some cells to change the font size.
Click on the down arrow to the right of the font size list box. A drop down list of available font sizes appears.
Click on the font size of your choice. The selection list closes and the new font size is applied to the selected cells.
[h=2]Fonts, Color, and Borders
[h=5]To Select a Font Style:
Select some cells.
Click on any of the following options on the Formatting toolbar.
Bold button (Ctrl + B).
Italics button (Ctrl + I).
Underline button (Ctrl + U).
The attribute (bold, italics, or underline) is applied to the font.
The Bold, Italics, and Underline buttons on the Formatting toolbar are
like toggle switches. Click once to turn it on, click again to turn it off.
[h=5]To Select a Font Style:
Select some cells.
Click on any of the following options on the Formatting toolbar.
Bold button (Ctrl + B).
Italics button (Ctrl + I).
Underline button (Ctrl + U).
The attribute (bold, italics, or underline) is applied to the font.
The Bold, Italics, and Underline buttons on the Formatting toolbar are
like toggle switches. Click once to turn it on, click again to turn it off.