The way you display information on a worksheet in Excel is easily customizable. You can apply extensive formatting to create what is basically a worksheet layout, known as a View. Use the following articles to learn how to create and save Views in Excel to easily apply them to any worksheet.

Tips, Tricks, and Answers

The following articles are available for the 'Views' topic. Click the article''s title (shown in bold) to see the associated article.

   Deleting a View
When you no longer need a view, you can get rid of it by deleting it. Deleting unnecessary views is a good idea because it decreases the complexity of your worksheets. This tip explains how to get rid of unwanted views.

   Turning Off Synchronous Scrolling
Synchronous scrolling can be a real help when you are working with worksheets that are similar in layout. If your worksheets are different, however, you'll need to turn off the scrolling feature, as discussed in this tip.

   Understanding Views
Need to display your worksheet in different ways? A quick way to do this is to create views, as described in this tip.

   Using Stored Views
After creating different views of your worksheet data, you can display those views by simply selecting which one you want to see. This tip explains how this works.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.