Lesson 7: Formatting Cells Show
/en/excel2016/modifying-columns-rows-and-cells/content/ IntroductionAll cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. Optional: Download our practice workbook. Watch the video below to learn more about formatting cells in Excel. To change the font size:
You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard. To change the font:By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet.
When creating a workbook in the workplace, you'll
want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial. To change the font color:
Select More Colors at the bottom of the menu to access additional color options. We've changed the font color to a bright pink. To use the Bold, Italic, and Underline commands:
You can also press Ctrl+B on your keyboard to make selected text bold, Ctrl+I to apply italics, and Ctrl+U to apply an underline. Cell borders and fill colorsCell borders and fill colors allow you to create clear and defined boundaries for different sections of your worksheet. Below, we'll add cell borders and fill color to our header cells to help distinguish them from the rest of the worksheet. To add a fill color:
To add a border:
You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu. Cell stylesInstead of formatting cells manually, you can use Excel's predesigned cell styles. Cell styles are a quick way to include professional formatting for different parts of your workbook, such as titles and headers. To apply a cell style:In our example, we'll apply a new cell style to our existing title and header cells.
Applying a cell style will
replace any existing cell formatting except for text alignment. You may not want to use cell styles if you've already added a lot of formatting to your workbook. Text alignmentBy default, any text entered into your worksheet will be aligned to the bottom-left of a cell, while any numbers will be aligned to the bottom-right. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read. Click the arrows in the slideshow below to learn more about the different text alignment options.
To change horizontal text alignment:In our example below, we'll modify the alignment of our title cell to create a more polished look and further distinguish it from the rest of the worksheet.
To change vertical text alignment:
You can apply both vertical and horizontal
alignment settings to any cell. Format PainterIf you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click the Format Painter, it will copy all of the formatting from the selected cell. You can then click and drag over any cells you want to paste the formatting to. Watch the video below to learn two different ways to use the Format Painter. Challenge!
/en/excel2016/understanding-number-formats/content/ What is a workbook in Excel quizlet?Workbook. An excel document which contains three worksheets by default but can have more than three. Worksheets. Excel's name for a computerized spreadsheet. A worksheet is identified by a tab at the bottom of the screen.
When you save a workbook as a template which of the following file name extensions does Excel apply?For an Excel file, the current default file extension is XLSX.
What is the difference between a workbook and a worksheet quizlet?What is the difference between a workbook and worksheet? A worksheet is a document divided into columns and rows, whereas a workbook is a single Excel file containing one or more worksheets.
What is workbook in data processing?A workbook consists of worksheets that are divided into rows and columns forming a matrix of cells. You may enter data or formulae into cells. The active cell is highlighted with a rectangular border, you can move the active cell by clicking on another cell with the mouse or by using the cursor keys (arrows).
|