How to Make Excel Look Like a Page (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Need to learn how to make Excel look like a page? If you are looking for such unique tricks, you’ve come to the right place. Here, we will take you through four easy and convenient steps to making Excel look like a page.


How to Make Excel Look Like a Page: 4 Steps

Suppose we have a Region-wise Sales Report of a certain organization. The dataset contains weekly Sales Quantity and Profit of two different states: Texas and Florida.

How to Make Excel Look Like a Page

Now, we want to make this spreadsheet looks like a simple page. So, without further delay, let’s see the steps one by one.


Step-1: Remove Fill Color

In our first step, we’ll remove the fill colors of the cells to make it looks simple.

  • At first, click the Select All button.
  • Then, go to the Home tab.
  • After that, select the Fill Colour dropdown.
  • Lastly, choose No Fill from the options.

How to Make Excel Look Like a Page Removing Fill Color

Now, the sheet looks like the one below.

How to Make Excel Look Like a Page Removing Fill Color

Read More: How to Change Page Orientation in Excel


Step-2: Remove Borders to Make Excel Look Like a Page

To make it simpler, remove the borders also.

  • Again, click on the Select All button.
  • Secondly, go to the Home tab.
  • Thirdly, select the Apply Border dropdown.
  • Then, choose No Border from the list.

How to Make Excel Look Like a Page Removing Borders

In this instance, the Excel sheet looks like the below one.

How to Make Excel Look Like a Page Removing Borders

Now, it looks clean and similar to a page. To make it more accurate follow the next steps.

Read More: How to Change Orientation of Worksheet to Landscape in Excel


Step-3: Utilize Page Setup Option

In this situation, we’ll use the Page Setup option to format the page more attractively.

  • Firstly, press the Ctrl+P key on your keyboard.
  • It opens the Print feature of Excel.
  • Then, select Page Setup at the bottom of the window.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • By our previous form of action, the Page Setup dialog box opens.
  • Now, go to the Margins tab.
  • Then, check the box Horizontally under the section Center on page.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • Secondly, move to the Header/Footer tab.
  • After that, click on the Custom Header button.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • Instantly, the Header wizard will open.
  • At first, click on the Right section.
  • Then, select the Insert Page Number icon.
  • Next, click OK.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • Again, it returns us to the Page Setup dialog box.
  • Then, select the Custom Footer option.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • In this instance, the Footer wizard opens.
  • Now, select the Center section.
  • Then, click on the File Name icon.
  • Lastly, click OK.

How to Make Excel Look Like a Page Utilizing Page Setup Option

  • Again, it returns us to the Page Setup box.
  • Here, we can see the newly created Header and Footer.
  • Finally, click the OK button.

How to Make Excel Look Like a Page Utilizing Page Setup Option

The page looks like the one below in the Print Preview option. Hence, it contains the header and footer perfectly.

How to Make Excel Look Like a Page Utilizing Page Setup Option


Step-4: Convert to PDF to Make Excel Look Like a Page

  • At this moment, select Microsoft Print to PDF from the dropdown menu of Printer.
  • Then, click on the Print button.

How to Make Excel Look Like a Page Converting to PDF

  • It opens the Save Print Output As window.
  • Firstly, select your desired file path. In this case, we selected Desktop.
  • Secondly, give the File name accordingly.
  • Then, hit the Save button.

How to Make Excel Look Like a Page Converting to PDF

  • At present, open the PDF in your PDF reader.
  • This will look like the one below.

How to Make Excel Look Like a Page Converting to PDF


How to Make Excel Look Like a Word Document

Also, you can make your Excel sheet look like a Word document. Actually, you can link your sheet to a doc file.
Suppose you have the same dataset that we’ve used before.

How to Make Excel Look Like a Page Using Word

Now, we’ll link this Excel sheet to a doc file. Follow the steps below carefully.

📌 Steps

  • Initially, open the Microsoft Word application.
  • Secondly, move to the Insert tab.
  • Then, click on the Object dropdown on the ribbon.
  • After that, select Object from the choices.

How to Make Excel Look Like a Page Using Word

  • Suddenly, the Object dialog box opens.
  • Now, move to the Create from File tab.
  • Then, select the Browse option.

How to Make Excel Look Like a Page Using Word

  • In the Browse window, select Desktop as your defined file path.
  • Later, select the Excel file Making Excel Look Like a Page.
  • Next, click on Open.

How to Make Excel Look Like a Page Using Word

  • Again, it returns us to the Object dialog box.
  • At this point, check the box of Link to file.
  • Finally, click OK.

How to Make Excel Look Like a Page Using Word

Automatically, the data of sheet Word will come to the newly created doc file.

How to Make Excel Look Like a Page Using Word

Read More: How to Adjust Page Size for Printing in Excel


How to Make Excel Look Like a Web Page

Additionally, we can make our Excel sheet look like a web page. Here, we’ll use the same dataset as before (just without any kind of fill color and borders).

How to Make Excel Look Like a Page Using View Tab

Follow our steps below to be able to do the same.

📌 Steps

  • At first, go to the Developer tab.
  • Secondly, select the Insert drop-down of the Controls group on the ribbon.
  • Then, choose Button (Form Control) from the options.

Using Developer Option

  • Suddenly, the Assign Macro wizard opens.
  • Just, click on OK.

Using Developer Option

  • It will add a button to the sheet just like the one below.

Using Developer Option

  • Now, change the name of the button to Click Here. We’re doing it just to give it a look similar to a web page. We won’t assign any function to this button in this article.

Using Developer Option

  • Then, right-click on the Home tab.
  • After that, select Collapse the Ribbon.

Using Developer Option

At this position, the sheet looks like that.

Using Developer Option

  • Promptly, go to the View tab.
  • Secondly, uncheck the boxes of Formula Bar and Headings.

Using View Tab

  • Our previous action does the following effect on the sheet.
  • Now, the Formula Bar and Headings are hidden.

Using View Tab

  • At first, click on the Ribbon Display Options.
  • Then, select Auto-hide Ribbon from the choices.

Using Ribbon Display Options

  • Finally, the Excel sheet looks just like a web page.

Using Ribbon Display Options


Practice Section

For doing practice by yourself we have provided a practice section like below in the sheet Practice Section on the workbook. Please do it by yourself.

Practice Section


Download Practice Files

You may download the following Excel workbook, PDF, and doc file for better understanding and practice yourself.


Conclusion

This article provides easy and brief solutions to make Excel look like a page. Don’t forget to download the Practice file. Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website Exceldemy to explore more.


Related Articles


<< Go Back to Page Setup in Excel | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shahriar Abrar Rafid
Shahriar Abrar Rafid

Shahriar Abrar Rafid, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked with the ExcelDemy project for more than 1 year. He has written over 100+ articles for ExcelDemy. He is a professional visual content developer adept at crafting scripts, meticulously editing Excel files, and delivering insightful video tutorials for YouTube channels. His work and learning interests vary from Microsoft Office Suites and Excel to Data Analysis, VBA, and Video recording and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo