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.

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.

Now, the sheet looks like the one below.

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.

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

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.

• 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.

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

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

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

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

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

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

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.

• 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.

• This will look like the one below.

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.

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.

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

• 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.

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

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

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).

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.

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

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

• 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.

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

At this position, the sheet looks like that.

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

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

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

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

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.

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

What is ExcelDemy?

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

Welcome to my profile! I'm thrilled to have you here. As a dedicated Naval Architecture and Marine Engineering graduate from the prestigious Bangladesh University of Engineering & Technology, I am deeply immersed in the realm of research and analysis. My current focus revolves around Microsoft Excel, where I engage in extensive work and conduct insightful research. Through this platform, I share articles that shed light on the vast possibilities of Excel. I'm also an avid reader and passionate traveler, constantly seeking knowledge and implementing it effectively in my work. Join me on this exciting journey as we explore Excel and optimize our productivity together.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF