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.
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 :
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.
Usually, the data in Excel spreadsheets is presented in lists of rows, and each row represents a data record. Excel offers an easy way to work with this data type through a data entry form that Excel can automatically generate. This form of data works with a normal data range or a table.
Another way to highlight data in Excel, along with the use of colors, is to use borders. Borders and lines within borders are often used to group a range of similar cells or to delimit rows or columns. Excel offers 13 predefined border styles and tools to create your styles.
When working with data in Excel spreadsheets, it is sometimes necessary to split text lines into columns. Excel offers many different functions for working with text strings, but you don't have to use formulas for this task:
You can greatly reduce data-entry problems in your workbooks by making Excel check entries before entering them in specific cells. To do so, you need to define restrictions and data-validation rules for those cells.
Data imported into an Excel spreadsheet often contains extra spaces or strange (often unprintable) characters. There are two handy functions, TRIM and CLEAN, to cleanup such data: