How to Make Excel Look Like an Application (with Easy Steps)

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.

Creating Dataset in Different Sheets to Make Excel Look Like an Application

  • Additionally, add two other sheets named Sheet1 and Sheet2.

  • Then, insert your data in Sheet1.

Creating Dataset in Different Sheets to Make Excel Look Like an Application

  • After that, click on the sheet name.
  • Next, type Home as the sheet name.

  • Now, press ENTER.

Creating Dataset in Different Sheets to Make Excel Look Like an Application

  • Then, go to Sheet2 and insert your data.

  • After that, change the sheet name as Student Info following the steps given above.

Creating Dataset in Different Sheets to Make Excel Look Like an Application

  • Now, go to Sheet3 and insert your data.

  • Similarly, change the sheet name as Mark Sheet following the steps given above.

Creating Dataset in Different Sheets to Make Excel Look Like an Application

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.

Inserting and Naming Rectangular Box to Make Excel Look Like an Application

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

Inserting and Naming Rectangular Box

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

Inserting and Naming Rectangular Box

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

Inserting and Naming Rectangular Box

  • Now, add a Rectangle shape in the Home sheet and Right-click.

  • Next, select Edit Text.

Inserting and Naming Rectangular Box

  • Then, type Home as text in the Rectangle.

  • After that, set 16 as Font Size.
  • Next, click on Bold to bold the text.

Inserting and Naming Rectangular Box

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

Inserting and Naming Rectangular Box to Make Excel Look Like an Application

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

Inserting and Naming Rectangular Box to Make Excel Look Like an Application

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

Inserting and Naming Rectangular Box

  • Next, click on the Paste Button.

  • Then, go to the Mark Sheet sheet.
  • After that, select Cell B2.

Inserting and Naming Rectangular Box

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

Inserting and Naming Rectangular Box

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

Inserting and Naming Rectangular Box


Similar Readings


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.

Creating Link Between Sheets to Make Excel Look Like an Application

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

Creating Link Between Sheets to Make Excel Look Like an Application

  • After that, select the rectangle named as Student Info.
  • Now, Right-click on the rectangle.

  • Similarly, click on Link >> select Insert Link.

Creating Link Between Sheets to Make Excel Look Like an Application

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

Creating Link Between Sheets to Make Excel Look Like an Application

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

Creating Link Between Sheets to Make Excel Look Like an Application

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

Creating Link Between Sheets to Make Excel Look Like an Application


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.

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application

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

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application

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

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application

  • Then, the Mark Sheet sheet will look like the image given below.

  • Now, click on the File tab.

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application

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

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look Like an Application

  • Finally, you will get your desired Excel workbook which looks like an application.

Hiding Headings, Formula Bar, Ribbon and Sheet Tabs to Make Excel Look 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!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo