Contenido del Curso
Excel Essentials
Excel Essentials
Formatting Cells
Formatting cells in Microsoft Excel is fantastic for making your spreadsheets not only easier to read but also more professional.
In this chapter you'll learn how to adjust the rows and columns, format your cell backgrounds and borders, merge and center your cells as well as align and wrap your cell content to make your data more clear and accessible.
Open the Codefinity Excel workbook and navigate to the Section 2 worksheet to follow along with the video. Feel free to proceed with the previous one or download a new one if necessary:
Note
You can adjust the zoom level of the Excel workbook by holding down the
Ctrl
key and scrolling the mouse wheel up or down.
Now, let's get to work on the key aspects of cell formatting in Excel.
Key Points
- Row heights and Column widths can be adjusted by double clicking or dragging the boundaries. Alternatively, right-click the row or column, select Row Height or Column Width, and then enter the measurement you want;
- The Borders button, in the Font group on the Home tab, allows you to add borders to a selected range of cells;
- Add color to cells by using the Fill Color button, in the Home tab;
- Use the Merge & Center button in the Home tab to combine selected cells and center the content;
- The Wrap Text button in the Home tab wraps text within a cell to ensure all content is visible without widening the column;
- Adjust the vertical and horizontal alignment of cell content using the alignment options in the Home tab.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
¿Todo estuvo claro?
Elige tu plan
Formatting Cells
Formatting cells in Microsoft Excel is fantastic for making your spreadsheets not only easier to read but also more professional.
In this chapter you'll learn how to adjust the rows and columns, format your cell backgrounds and borders, merge and center your cells as well as align and wrap your cell content to make your data more clear and accessible.
Open the Codefinity Excel workbook and navigate to the Section 2 worksheet to follow along with the video. Feel free to proceed with the previous one or download a new one if necessary:
Note
You can adjust the zoom level of the Excel workbook by holding down the
Ctrl
key and scrolling the mouse wheel up or down.
Now, let's get to work on the key aspects of cell formatting in Excel.
Key Points
- Row heights and Column widths can be adjusted by double clicking or dragging the boundaries. Alternatively, right-click the row or column, select Row Height or Column Width, and then enter the measurement you want;
- The Borders button, in the Font group on the Home tab, allows you to add borders to a selected range of cells;
- Add color to cells by using the Fill Color button, in the Home tab;
- Use the Merge & Center button in the Home tab to combine selected cells and center the content;
- The Wrap Text button in the Home tab wraps text within a cell to ensure all content is visible without widening the column;
- Adjust the vertical and horizontal alignment of cell content using the alignment options in the Home tab.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
¿Todo estuvo claro?
Elige tu plan
Formatting Cells
Formatting cells in Microsoft Excel is fantastic for making your spreadsheets not only easier to read but also more professional.
In this chapter you'll learn how to adjust the rows and columns, format your cell backgrounds and borders, merge and center your cells as well as align and wrap your cell content to make your data more clear and accessible.
Open the Codefinity Excel workbook and navigate to the Section 2 worksheet to follow along with the video. Feel free to proceed with the previous one or download a new one if necessary:
Note
You can adjust the zoom level of the Excel workbook by holding down the
Ctrl
key and scrolling the mouse wheel up or down.
Now, let's get to work on the key aspects of cell formatting in Excel.
Key Points
- Row heights and Column widths can be adjusted by double clicking or dragging the boundaries. Alternatively, right-click the row or column, select Row Height or Column Width, and then enter the measurement you want;
- The Borders button, in the Font group on the Home tab, allows you to add borders to a selected range of cells;
- Add color to cells by using the Fill Color button, in the Home tab;
- Use the Merge & Center button in the Home tab to combine selected cells and center the content;
- The Wrap Text button in the Home tab wraps text within a cell to ensure all content is visible without widening the column;
- Adjust the vertical and horizontal alignment of cell content using the alignment options in the Home tab.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.
¿Todo estuvo claro?
Formatting cells in Microsoft Excel is fantastic for making your spreadsheets not only easier to read but also more professional.
In this chapter you'll learn how to adjust the rows and columns, format your cell backgrounds and borders, merge and center your cells as well as align and wrap your cell content to make your data more clear and accessible.
Open the Codefinity Excel workbook and navigate to the Section 2 worksheet to follow along with the video. Feel free to proceed with the previous one or download a new one if necessary:
Note
You can adjust the zoom level of the Excel workbook by holding down the
Ctrl
key and scrolling the mouse wheel up or down.
Now, let's get to work on the key aspects of cell formatting in Excel.
Key Points
- Row heights and Column widths can be adjusted by double clicking or dragging the boundaries. Alternatively, right-click the row or column, select Row Height or Column Width, and then enter the measurement you want;
- The Borders button, in the Font group on the Home tab, allows you to add borders to a selected range of cells;
- Add color to cells by using the Fill Color button, in the Home tab;
- Use the Merge & Center button in the Home tab to combine selected cells and center the content;
- The Wrap Text button in the Home tab wraps text within a cell to ensure all content is visible without widening the column;
- Adjust the vertical and horizontal alignment of cell content using the alignment options in the Home tab.
Tarea
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align.