One powerful Excel feature is Macro, little scripts and recordings you can create to make the program perform different actions automatically. While no other spreadsheet program has this type of feature, it is complex and can pose difficulty for beginners.
Unique Features of Excel _ With over 400 functions, Excel is more or less the most comprehensive spreadsheet option when it comes to pure calculations. It also has strong visualization abilities, including conditional formatting, Pivot Tables, SmartArt, graphs, and charts. Home and business users alike can create powerful spreadsheets and reports to track data and inform their decisions.
The other tool in this section is Merge and Center. There are instances when you may want to combine several cells and have them act as one long cell. For example, you might want a header for an entire table to be clear and easy to read. Select all the cells you want combined, click Merge, and then type your header and format it. Though the default setting for headers is centered text, simply click the drop_down arrow to select different merging and unmerging options.
B. These are print options. You can change the margin for printing, whether you want a vertical or horizontal print alignment, which cells in your sheet you want to print, where youd like page breaks, and whether it has a background (to place your company name, for example). You can also start giving each page a heading using the Print Titles button, and the order to print each section.