I need help with formatting my Worksheet title, so that it will look like the fi

Question

I need help with formatting my Worksheet title, so that it will look like the first picture. I tried to merge all cells, but that did not work.

shown in Figure 9-2. In this job, you will create the Owner and CEO budget worksheet. You will create worksheets for the other three departments in later jobs. FIGURE 9.2 Owner and CEO Budget Worksheet Star River Resort 205 Riverview Drive Sutton, wV 26601 tal ar Budget Oner Percent of Anual Year to Date Budget ary Wages ges Treved Expenses Supples Equgment Miscalaneous Monthly lotal Budeet Expesdtures uining Returrig 2.40s 27/2 5050 .0 3910.0 142 033,350 00 202 10o 233,008 a 232,003.00 5/31/2 232,0200 00 12/31/2- 6,00000 1,050 001,962001,50000 2,000325504o 2.000 00 25,000.0026,0030 15.000 00 35 64,000.00 23,500 2409 09 13540.0 2,00 0 450 0 4550 03 225.00 17437 00 Total Expenditures Annual Sudget Balance ,77600214430 Percentage Remaining

Explanation / Answer

You have to merge all the cells of a single row, then merge cells of 2 nd row and so on till 5th row. Then For first 3 rows set the alignment of text to center i.e Alt then H then AC.
For 4th and 5th Row set the alignment to left i.e Alt then H then AL.

Here is the link for you to download the excel file which I have formatted for you.
https://drive.google.com/file/d/1zNKJkGTvTlL5rGDtgfFqkfi_iqOLhzAL/view?usp=sharing

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.