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:
Odd and even pages may have different headers and footers on printing Excel spreadsheets like different pages in Word documents.
A watermark is an image (or text) that appears on each printed page. Watermark can be used to add a company logo, an image, identifying marks, etc., to the printed pages. Excel doesn't have a command to add the text as a watermark, but it is possible to add a picture in the page header or footer:
Headers and footers are widely used in Microsoft Word documents, but you should know that Excel also has headers and footers.
The header shows the information at the top of every printed page. The footer shows the information at the bottom of every printed page. By default, new workbooks do not have headers or footers.
You can instantly find and edit data and text without manually combing through printed or handwritten pages while working with documents or spreadsheets on your computer or laptop. Word provides a convenient "find and replace" feature that allows you to use wildcards.
When working with multiple tables and large amounts of data, when designing or analyzing charts or diagrams, you may need to view two or more parts of the worksheet simultaneously.
Using the Hide command, you can hide the data and formulas from "inquisitive minds." But some of them still can use the Unhide command. Nevertheless, you can completely hide the Excel spreadsheet so that some VBA programming will be needed to unhide it.
Sometimes it is necessary to compare two Excel worksheets. E.g., compare balance sheets for different periods of time. You can do it by comparing spreadsheets side by side in two automatically linked windows.
You can freeze your column and row labels so that you can view them no matter how far you scroll down or to the right in your worksheet.