Microsoft Excel 2007: Cell Alignment and Row Formatting (Part 4)
Explore “Cell Alignment and Row Formatting” in this Microsoft Excel 2007 lesson. Part 4 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Change the alignment by clicking on one of these.
- Resize Row 1 to 100 pixels. If you have any questions, please ask.
- To align data vertically, select cells and click on “Alignment palette”
- Use the drop-down menu under “Vertical:”
- To alignment use the formatting menu, and selct which style you want. Select “vertical”
Contents
- Read the original document
- Change the alignment by clicking on one of these.
- Resize Row 1 to 100 pixels. If you have any questions, please ask.
- To align data vertically, select cells and click on “Alignment palette”
- Use the drop-down menu under “Vertical:”
- To alignment use the formatting menu, and selct which style you want. Select “vertical”
- The text is now centered vertically.
- Go to sheet 2, and type “Alphabet soup is very delicious!” is cell A1.
- Excel can enlarge a cell to fit a lot of data. Under “Text control,” click on “Wrap text.”
- The cell has enlarged enough to fit the data entered.
- Go to sheet 3, and type “Bread and Butter” is cell A1.
- Excel can also shrink data to fit a cell. Under “Text control,” click on “Shrink to fit.”
- The data fits into one cell.
- Add a new worksheet open it.
- Data can be rotated – click icon in alignment panel to get format dialog box.
- Data may be rotated under “Orientation.”
- The data is rotated at a 45 degree angle.
- Click undo until you have a blank worksheet.
- Cells can be merged to form one large cell – this is very helpful to create a title for the worksheet.
- Select Cells A1-J1, and click the “Merge and Center” button
- You can undo the cell merge by clicking on the “Merge and Center” button again.
- Add another worksheet, and start working in it.
- You may change the horizontal alignment of data by clicking on the indent buttons.
- Select the cell in which you wish to increase the indent, and click the “Increase Indent” button. Remembe
- Add a new worksheet. Rename it with your last name. Delete all other worksheets.
- These buttons format numbers.
- The “Currency Style” button adds a dollar sign and commas.
- The “Percent Style” button adds a percent sign.
- The “Comma Style” button adds commas to numbers greater than one thousand.
- Every click of the “Increase Decimal” button displays an additional decimal space.
- Now in cells A1-B4 type in a 4 digit number in each cell.
- To add a border around your cells, select the cells, then click on the “Borders” button and choose the “A
- Click on the “Fill Color” icon to select different colors.
- Click on the “Font Color” button to change the color of your data.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Change the alignment by clicking on one of these.
Excel automatically lines up text (letters) on the left side of a cell, and numbers on the right side of a cell. Change the alignment by clicking on one of these. Left alignment Center alignment Right alignment
Resize Row 1 to 100 pixels. If you have any questions, please ask.
Resize Row 1 to 100 pixels. If you have any questions, please ask. LET’S TRY: REMEMBER HOW TO?
To align data vertically, select cells and click on “Alignment palette”
To align data vertically, select cells and click on “Alignment palette”
Use the drop-down menu under “Vertical:”
Use the drop-down menu under “Vertical:”
To alignment use the formatting menu, and selct which style you want. Select “vertical”
To alignment use the formatting menu, and selct which style you want. Select “vertical” Also shortcut in toolbar at top
The text is now centered vertically.
The text is now centered vertically.
Go to sheet 2, and type “Alphabet soup is very delicious!” is cell A1.
Go to sheet 2, and type “Alphabet soup is very delicious!” is cell A1.
Excel can enlarge a cell to fit a lot of data. Under “Text control,” click on “Wrap text.”
Excel can enlarge a cell to fit a lot of data. Under “Text control,” click on “Wrap text.”
The cell has enlarged enough to fit the data entered.
The cell has enlarged enough to fit the data entered.
Go to sheet 3, and type “Bread and Butter” is cell A1.
Go to sheet 3, and type “Bread and Butter” is cell A1.
Excel can also shrink data to fit a cell. Under “Text control,” click on “Shrink to fit.”
Excel can also shrink data to fit a cell. Under “Text control,” click on “Shrink to fit.”
Excel can also shrink data to fit a cell. Under “Text control,” click on “Shrink to fit.”
Excel can also shrink data to fit a cell. Under “Text control,” click on “Shrink to fit.”
The data fits into one cell.
The data fits into one cell.
Add a new worksheet open it.
Add a new worksheet open it. Now type January in cell A1 and autofill across until L1. Next resize row 1 to 100 pixels. LET’S TRY: REMEMBER HOW TO?
Data can be rotated – click icon in alignment panel to get format dialog box.
Data can be rotated – click icon in alignment panel to get format dialog box.
Data may be rotated under “Orientation.”
Data may be rotated under “Orientation.”
The data is rotated at a 45 degree angle.
The data is rotated at a 45 degree angle.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Click undo until you have a blank worksheet.
Click undo until you have a blank worksheet. Type “Kirkpatrick Document Management System” in cell A1. Resize the font to size 36. LET’S TRY: REMEMBER HOW TO?
Cells can be merged to form one large cell – this is very helpful to create a title for the worksheet.
Cells can be merged to form one large cell – this is very helpful to create a title for the worksheet.
Select Cells A1-J1, and click the “Merge and Center” button
Select Cells A1-J1, and click the “Merge and Center” button Now you have one large cell that spans across the top of your sheet.
You can undo the cell merge by clicking on the “Merge and Center” button again.
You can undo the cell merge by clicking on the “Merge and Center” button again.
Add another worksheet, and start working in it.
Add another worksheet, and start working in it. In cells A1-B2 type Last Name, First Name, Your Last name and Your First Name. LET’S TRY: REMEMBER HOW TO?
You may change the horizontal alignment of data by clicking on the indent buttons.
You may change the horizontal alignment of data by clicking on the indent buttons. Select the cell in which you wish to increase the indent, and click the “Increase Indent” button. Remember, text is automatically aligned to the left, and numbers to the right.
Select the cell in which you wish to increase the indent, and click the “Increase Indent” button. Remembe
Select the cell in which you wish to increase the indent, and click the “Increase Indent” button. Remember, text is automatically aligned to the left, and numbers to the right.
Add a new worksheet. Rename it with your last name. Delete all other worksheets.
Add a new worksheet. Rename it with your last name. Delete all other worksheets. On the new worksheet, in cell A1, type a “1000000000” (one billion) LET’S TRY: REMEMBER HOW TO?
These buttons format numbers.
These buttons format numbers.
The “Currency Style” button adds a dollar sign and commas.
The “Currency Style” button adds a dollar sign and commas.
The “Percent Style” button adds a percent sign.
The “Percent Style” button adds a percent sign.
The “Comma Style” button adds commas to numbers greater than one thousand.
The “Comma Style” button adds commas to numbers greater than one thousand.
Every click of the “Increase Decimal” button displays an additional decimal space.
Every click of the “Increase Decimal” button displays an additional decimal space.
Now in cells A1-B4 type in a 4 digit number in each cell.
Now in cells A1-B4 type in a 4 digit number in each cell. LET’S TRY: REMEMBER HOW TO?
To add a border around your cells, select the cells, then click on the “Borders” button and choose the “A
To add a border around your cells, select the cells, then click on the “Borders” button and choose the “All Borders” style.
Click on the “Fill Color” icon to select different colors.
Click on the “Fill Color” icon to select different colors.
Click on the “Font Color” button to change the color of your data.
Click on the “Font Color” button to change the color of your data.
Review questions and answers
What are the key points about Change the alignment by clicking on one of these.?
Excel automatically lines up text (letters) on the left side of a cell, and numbers on the right side of a cell. Change the alignment by clicking on one of these. Left alignment Center alignment Right alignment
What are the key points about Resize Row 1 to 100 pixels. If you have any questions, please ask.?
Resize Row 1 to 100 pixels. If you have any questions, please ask. LET’S TRY: REMEMBER HOW TO?
What are the key points about To align data vertically, select cells and click on “Alignment palette”?
To align data vertically, select cells and click on “Alignment palette”
What are the key points about To alignment use the formatting menu, and selct which style you want. Select “vertical”?
To alignment use the formatting menu, and selct which style you want. Select “vertical” Also shortcut in toolbar at top
What are the key points about Go to sheet 2, and type “Alphabet soup is very delicious!” is cell A1.?
Go to sheet 2, and type “Alphabet soup is very delicious!” is cell A1.
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in To align data vertically, select cells and click on “Alignment palette” should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.