Excel Temporary View: How to Create and Use It Effectively

Have you ever needed to look at your Excel data in a different way but didn’t want to mess up your original layout? That’s where Excel’s temporary view comes in handy. It allows you to change the view of your data without changing the data itself. In just a few clicks, you can create a new perspective that might help you see things differently.

Step by Step Tutorial: Creating a Temporary View in Excel

Sometimes, you need to look at your data from a different angle, but you’re afraid of messing up the original setup. Don’t worry; Excel’s temporary view feature is here to save the day. Here’s how to do it:

Step 1: Open Your Excel Workbook

Open the Excel workbook that contains the data you want to view temporarily.

When you open the workbook, make sure you’re on the worksheet that you want to create a temporary view for. If not, just click on the tab at the bottom to switch to the correct sheet.

Step 2: Go to the View Tab

Click on the "View" tab in the Excel ribbon.

The View tab is where you’ll find all sorts of tools to change how you see your data. It’s like putting on a new pair of glasses that lets you see everything in a different light.

Step 3: Create a New Window

In the Window group, click on "New Window."

This creates a new instance of the same worksheet. It’s like having a clone of your data that you can mess around with without affecting the original.

Step 4: Arrange the Windows

Click on "Arrange All" in the Window group and choose your preferred layout.

You might want to see your data side-by-side, stacked, or in another layout. This step lets you arrange your original and temporary views so you can compare them easily.

Step 5: Make Changes in the New Window

Make any changes or adjustments in the new window without worrying about altering your original data.

This is where the fun begins. Sort, filter, or format to your heart’s content. The original data stays the same while you explore different views in the new window.

After completing these steps, you’ll have a new window with a different view of your data. This temporary view is great for comparison, analysis, or just getting a fresh perspective. And the best part? Your original data remains untouched.

Tips for a Smooth Experience with Temporary Views in Excel

  • Always remember to close the temporary view window when you’re done. This will prevent any confusion between the original and the altered view.
  • If you make changes in the temporary view that you want to keep, make sure to copy and paste them into the original worksheet.
  • Use the "Switch Windows" button in the View tab to easily toggle between the original and temporary views.
  • Don’t forget to save your workbook before creating a temporary view, just in case you make any accidental changes.
  • Experiment with different types of views like freezing panes or splitting the screen to see what works best for your data.

Frequently Asked Questions

What is a temporary view in Excel?

A temporary view in Excel is a way to look at your data in a new window without altering the original layout or data. It’s like a sandbox for your data.

Can I save the temporary view?

No, the temporary view is not meant to be saved. It’s meant for temporary analysis or comparison. If you want to keep any changes, you need to manually copy them to the original worksheet.

Will creating a temporary view affect my original data?

No, creating a temporary view will not affect your original data. It’s a safe way to play around with different views without worrying about data integrity.

Can I print from the temporary view?

Yes, you can print from the temporary view just like you would from the original worksheet. Just make sure you’re in the correct window when you hit print.

How many temporary views can I create?

You can create as many temporary views as you need. Each new window will have its own view settings, but remember, it can get confusing if you have too many open.


  1. Open your Excel workbook.
  2. Click on the "View" tab.
  3. Create a new window for a temporary view.
  4. Arrange the windows to your liking.
  5. Make changes in the new window without affecting the original data.


Excel’s temporary view feature is a powerful tool for anyone who needs to analyze data from different angles without risking the integrity of their original data. It opens up a world of possibilities for data comparison, analysis, and presentation. Whether you’re a data analyst, a student, or just someone who loves to keep their data organized, mastering the temporary view in Excel can significantly enhance your productivity and give you insights that might have been hidden in the original format. So go ahead, give it a try, and see how it transforms your Excel experience!