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.
Download Practice Files
You may download the following Excel workbook, PDF, and doc file for better understanding and practice yourself.
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.
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.
- How to Make Excel Easier on the Eyes (12 Quick Tips)
- How to Make Excel Spreadsheet Colorful (6 Simple Tricks)
- Excel VBA to Open Workbook in Background (2 Useful Examples)
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.
- At present, open the PDF in your PDF reader.
- 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 which we’ve used before.
Now, we’ll link this Excel sheet to a doc file. Follow the steps below carefully.
- 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 looks like a web page also. 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.
- 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.
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.
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.
- How to Remove Background Color in Excel (5 Ways)
- How Do I Change the Default Background Color in Excel
- [Fixed!] Background Color Not Changing in Excel (6 Solutions)
- How to Change Background Color Based on Value in Excel
- How to Make Picture Background Transparent in Excel (2 Methods)
- How to Remove Background in Excel (2 Practical Cases)