Catalog

How To Return To Normal View in Excel (Step-by-Step)

October 11, 2023 7.7K views

What is Normal View in Excel and how to return to Normal View in Excel?  In Microsoft Excel, the term "Return to Normal View" usually refers to exiting a specialized view or mode and returning to the standard/default view of the spreadsheet. However, this process can be confusing for some users. If you find yourself wondering how to return to a normal view in Excel, this article is your ultimate guide to achieving that.

1. What is a Normal View in Excel?

Default View of Microsoft Excel


In Microsoft Excel, "Normal View" is one of the three primary views you can use to work on your spreadsheets. The three main views in Excel are:

Normal View, Page Break Preview, Page Layout icon


  • Normal View

  • Page Layout View

  • Page Break Preview

In this article, we will talk about “Normal View” in Excel. Normal View is the default view and is designed for general editing and formatting of your Excel worksheet. In Normal View, you can see the worksheet's data, headers, and footers, but it doesn't display page breaks, margins, or other elements related to printing. It's the view most commonly used for data entry, calculations, and formatting.

2. How to Return to Normal View in Excel?

However, in some situations, Excel may require you to switch from the normal view to another view in order to perform specific tasks. For example, the header view, the page layout view, and the print preview view. So here comes the question. How to Return to a Normal View in Excel after you have done the tasks in another view ? Luckily this article will answer the question for you.

Follow the step-by-step tutorial of return to normal view in Excel with images below:

STEP 1: Open the Excel workbook that you want to return to normal view. Example, Page Break Preview.

Page break preview image


STEP 2: Click the View tab.

View tab on the ribbon


STEP 3: In the Workbook Views group, click the Normal button. The view will return to the Normal View in Excel.

Normal Button in the workbook Views group


Is it easier and simpler than you think? Here is my comment about my experience using this method:

  • I found this method to be the easiest and most straightforward way to return to normal view in Excel. It only takes a few clicks and you're back to the default view.

Additional tip:

  • You can use the same way to switch from “normal view” to another view.

  • You can use “normal view” to format cells in your worksheet.

  • You can use “normal view” to print your worksheet.

3. Best Free Alternative to Microsoft Office - WPS Office

Still looking for a free and powerful alternative to Microsoft Office?

Try WPS Office,  its main functions are word processing, spreadsheeting, presentation, and PDF editing. It is an alternative to Microsoft Word, Excel, PowerPoint, and Adobe Acrobat.  WPS Office has all the features you need to create and manage complex spreadsheets. You can also learn advanced usage of other functions online. The most important thing is WPS Office FREE TO DOWNLOAD AND USE! ! !

In addition to being free, WPS office also has several advantages over Microsoft Excel, including:

  • Multiple functions: WPS Office can do many things, like word processing, spreadsheeting, presentation, and PDF editing.

  • Learn advanced usage online: You can learn how to use all of WPS Office's features online.

  • Compatible with Microsoft Excel: WPS Excel can open, edit, and save Microsoft Excel files.

  • User-friendly interface: WPS Excel is easy to learn and use because it has a similar interface to Microsoft Excel.

  • Regularly updated: WPS Office is updated with new features and bug fixes regularly.

How to download WPS Excel:

WPS official Page


  • Download and Install:

Once you've selected the correct version, click on the download link. The installer file will be downloaded to your device. Run the installer and follow the on-screen instructions to install WPS Office, including WPS Excel.

Installer file


 Open WPS Excel:

After the installation is complete, you can launch WPS Office from your applications or programs list. Within WPS Office, you'll find WPS Excel for all your spreadsheet needs.

WPS office applicant


Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

4. FAQs:

Q: How do I go back to the normal view in Excel header?

  • To close the header and footer, you must switch from Page Layout view to Normal view. On the View tab, in the Workbook Views group, click Normal.

Q: What are the system requirements for WPS Office?

  • The system requirements for WPS Office are very low. You can run WPS Office on a computer with Windows XP or later, or macOS 10.10 or later. You also need at least 100MB of free disk space and 512MB of RAM.

Q: Is WPS Office compatible with other office suites?

  • Yes, WPS Office is compatible with other office suites, such as Microsoft Office and Google Sheets. You can import and export files from other office suites, so you can easily share your documents with others.

Q: Is WPS Office safe to use?

  • Yes, WPS Office is safe to use. It has been scanned by multiple antivirus and anti-malware programs and has been found to be clean. WPS Office is also open-source, so you can review the code yourself to ensure that it is safe.

Q: How do I get help with WPS Office?

  • WPS Office offers a variety of resources to help you get help. You can visit the WPS Office website for online tutorials, forums, and a knowledge base. You can also contact WPS Office support for help.

5. Summary

Now that you've learned how to return to Normal View in Excel, you can apply this knowledge to adjust the view as needed.You have also learned about WPS Office, a free and open-source office suite that includes a word processor, spreadsheet, presentation, and PDF reader. WPS Office has all the features you need to create and manage complex spreadsheets. It is compatible with Microsoft Excel files, has a user-friendly interface, and is regularly updated with new features and bug fixes

Try WPS Office today and see for yourself why it's a great alternative to Microsoft Excel.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.