Review in Excel 2016 2013 2010 2007 2003

Equations in Excel

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:

How to create different headers and footers on odd and even pages

Odd and even pages may have different headers and footers on printing Excel spreadsheets like different pages in Word documents.

Adding watermarks to workbook

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:

Adding a header and footer to the worksheet

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.

Select special types of cells

While working in Excel, you may need to find certain types of cells in your worksheets. For example, cells that contain comments, formulas, or only formulas with errors. See how to select all the embedded charts on the worksheet and how to select a large data range in one click in Excel.

Find and replace in Excel

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.

Viewing a worksheet in multiple windows

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.

Making a spreadsheet very hidden

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.

View spreadsheets side by side

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.

How to freeze columns and rows

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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more