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:

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.