The appearance of any Microsoft document, such as an Excel workbook, is determined by a Theme (also known as document Theme) — a combination of colors, fonts, and effects. Themes help to create creative and professional-looking documents without a professional designer.
Although Excel is used for calculating and presenting data, sometimes it is necessary to show the underlying formulas. Like Microsoft Word, Excel lets you use the Equation Editor to insert a beautifully designed math equation as a graphical object:
The Shape Format tab (the Format tab of the Drawing Tools toolbar in Excel 2016) provides plenty of options for customizing a shape outline, background, and text settings. Also, you can change spacing and size for multiple shapes at once.
Every time you add, move, or resize shapes, it's not easy to align them by default. Excel proposes features for arranging and aligning shapes:
A margin is a space between the page content and the edge of the page. Excel offers three predefined sets of margins: Normal (used by default), Wide, and Narrow :
Odd and even pages may have different headers and footers on printing Excel spreadsheets like different pages in Word documents.
The Excel AutoComplete feature allows you to automate entering the same text into multiple cells. With AutoComplete, you enter the first few letters of a text entry into a cell, and Excel automatically completes the entry based on other entries that have already been in the current column:
Excel has a useful Data Validation feature to display messages and prevent incorrect cell entry. This feature works fine with manual data typing. However, validation messages will not be displayed if invalid data is entered into a cell by copying or filling; a formula in a cell evaluates to an invalid result; a macro enters invalid data into a cell; etc.