Looking for ways to know how to make Excel look like an application? Then, this is the right place for you. Microsoft Excel is known worldwide for its versatility. It can be used for different purposes including making the worksheets look like an application. Here, you will find 4 detailed steps to make Excel look like an application.
Download Practice Workbook
4 Steps to Make Excel Look Like an Application
We can make Excel look like an application by going through some simple steps. Follow the steps given below to do it on your own.
Step-01: Creating Dataset in Different Sheets
In the beginning, we will create datasets in different sheets in Excel. Go through the steps given below to make your own dataset.
- First, open a new Excel File.
- Additionally, add two other sheets named Sheet1 and Sheet2.
- Then, insert your data in Sheet1.
- Now, press ENTER.
- Then, go to Sheet2 and insert your data.
- After that, change the sheet name as Student Info following the steps given above.
- Now, go to Sheet3 and insert your data.
- Similarly, change the sheet name as Mark Sheet following the steps given above.
Read More: How to Make Excel Look Like a Page (with Easy Steps)
Step-02: Inserting and Naming Rectangular Box
Now, we will add and give names to Rectangular Boxes in Excel to make Excel look like an application. Follow the steps given below to do it on your own.
- In the beginning, select row 2.
- Then, go to the Home tab >> click on Cells.
- After that, click on Format >> select Row Height.
- Now, the Row Height box will open.
- Next, set 45 as Row height.
- Then, click on OK.
- Now, you can see that the row height of Row 2 has changed.
- After that, change the row height of Row 2 of the Student Info sheet.
- Similarly, change the row height of Row 2 of the sheet named Mark Sheet.
- Then, go to the sheet named as Home.
- Afterward, go to the Insert tab >> click on Illustrations >> click on Shapes >> select Rectangle.
- Now, add a Rectangle shape in the Home sheet and Right-click.
- Next, select Edit Text.
- Then, type Home as text in the Rectangle.
- After that, set 16 as Font Size.
- Next, click on Bold to bold the text.
- Now, set Middle Align and Center as the text Alignment.
- Next, select the rectangle again.
- Then, click on Fill Color >> select Blue, Accent 1, Darker 50%.
- Similarly, add 2 more rectangles and name as Student Info and Mark Sheet following the same steps given above.
- After that, go to the Home tab >> click on Editing >> click on Find & Select >> select Select Objects.
- Then, select the 3 Rectangles.
- Next, go to the Home tab >> click on the Copy button.
- Now, go to the Student Info sheet.
- After that, select Cell B2.
- Next, click on the Paste Button.
- Then, go to the Mark Sheet sheet.
- After that, select Cell B2.
- Again, click on the Paste Button.
- Afterward, go to the Home sheet.
- Next, select the rectangle named as Home and place it a little lower than the other rectangles.
- Then, go to the Student Info sheet.
- Now, select the rectangle named as Student Info and place it a little lower than the other rectangles.
- Finally, go to the Mark Sheet sheet.
- Similarly, select the rectangle named as Mark Sheet and place it a little lower than the other rectangles.
Similar Readings
- How to Make Excel Easier on the Eyes (12 Quick Tips)
- How to Make Excel Look Pretty (16 Easy Formats)
- How to Remove Background Color in Excel (5 Ways)
Step-03: Creating Link Between Sheets to Make Excel Look Like an Application
Here, we will show you how to Create Links between sheets to make Excel look like an Application. By creating links between the sheets, we can go from one sheet to another with just one click in Excel. Go through the steps below to do it on your own dataset.
- First, in the Home sheet select the rectangle named as Home.
- After that, Right-click on the rectangle.
- Then, click on Link >> select Insert Link.
- Now, the Insert Hyperlink box will appear.
- Next, click on Place in this Document option >> select Home.
- Then, click on OK.
- After that, select the rectangle named as Student Info.
- Now, Right-click on the rectangle.
- Similarly, click on Link >> select Insert Link.
- Again, the Insert Hyperlink box will appear.
- Next, click on Place in this Document option >> select Student Info.
- Then, click on OK.
- Then, select the rectangle named Mark Sheet.
- Now, Right-click on the rectangle.
- Again, click on Link >> select Insert Link.
- After that, the Insert Hyperlink box will appear.
- Next, click on Place in this Document option >> select Mark Sheet.
- Then, click on OK.
- Now, go to the Student Info sheet.
- Then, create links between the sheets following the same steps given above.
- Next, go to the Mark Sheet sheet.
- Finally, create links between the sheets following the same steps given above.
Step-04: Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application
In the final step, we will show you how to hide Headings, Formula Bar, Ribbon, and Sheet tabs to make Excel look like an application. Follow the steps given below to do it on your own.
- In the beginning, go to the Home sheet.
- Then, go to the View tab >> turn off Formula Bar, Gridlines, and Headings.
- Now, the Home sheet will look like the image given below.
- After that, go to the Student Info sheet.
- Then, go to the View tab >> turn off Gridlines, Headings.
- Now, the Student Info sheet will look like the image given below.
- Next, go to the Mark Sheet sheet.
- Again, go to the View tab >> turn off Gridlines, Headings.
- Then, the Mark Sheet sheet will look like the image given below.
- Now, click on the File tab.
- After that, select Options.
- Now, the Excel Options box will appear.
- Then, go to the Advanced option.
- Next, turn off the Show sheet tabs option.
- Finally, you will get your desired Excel workbook which looks like an application.
Read More: How to Change Worksheet Tab Color in Excel (5 Handy Methods)
Conclusion
So, in this article, you will find detailed steps to make Excel look like an application. Use any of these ways to accomplish the result in this regard. I hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!
A good tip to finish this off is to select the column after the last populated column of your sheet, then Ctrl+Shift+Right to select all columns, then right click and hide those columns. Do the same with the rows below your data.
The only thing I’d like to work out now is how to get it sort of centre aligned in the screen, and hide the Formula bar and Ribbon (I know this can be done, but only on the local machine, and then it’s missing for every other spreadsheet you use in Excel too).
Hi EDD,
Thanks for your comment. Hiding the Formula bar and Ribbon are typically done on a per-workbook basis and aren’t usually carried over to other workbooks you open. However, when you hide Formula Bar and Ribbon from any specific worksheet of your workbook, they’ll be removed from all the other worksheets of that workbook.
You can follow a manual process to align the range in the center of the screen. To center align all the elements on the screen, select the whole range and press Ctrl + X to cut the total range. Here, for the Home page, we will cut cell range B1:H12.
Then, press Ctrl + V to paste it in the center of your screen.
Similarly, you have to cut and paste all the elements to the center and align them on the screen manually.
We hope this will solve your problem. Please let us know if you face any further problems.
Regards,
Arin Islam,
ExcelDemy