How to Format an Excel Spreadsheet
How to Format an Excel Spreadsheet
An Excel spreadsheet can be formatted in a variety of ways to perform a number of different tasks. Data can be organized and displayed to suit particular needs, and individual cells can be programmed to make specific calculations based on the data entered. Those calculations can then be inserted into graphical representations of the data, such as charts and graphs. This article provides examples on how to format an Excel spreadsheet to organize, calculate and analyze expenses.
Steps

Format the cells and text. Select cells A2 through E2. Click the Merge and Center button on the Alignment toolbar. Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 35%." Select cells A3 through A5. Press and hold the control key on the computer keyboard and select cells A6 through B9, A10, A11, A12, B12, A13 and B13. Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 50%." Select cells B3 through D3. Press and hold the control key on the computer keyboard and select cells B4 through D4, and B5 through D5. Continue to hold down the control button and select cells B10 through D10, and B11 through D11. Click the Fill Bucket in the Font formatting toolbar and select "White, background 1, Darker 50%." Click the Merge and Center button, and the right justify button in the Alignment menu on the toolbar. Select cells C6 through D6. Press and hold the control key and select cells C6 through D6, C7 through D7, C8 through D8, and C9 through D9. Click the Fill Bucket and select "White Background 1." With the cells still selected, click the Merge and Center button, and the right justify button in the Alignment menu on the toolbar. Shading and merged cells have been formatted.

Program the "Total" cell to add the totals for each category. Click in cell E13 and click the AutoSum button in the editing menu on the far right of the standard toolbar. Select cells E3 through E13 and select the Currency button ($) in the Number formatting menu on the standard toolbar. Numbers entered into the fields for each category will be displayed as a monetary value, and the total will appear at the bottom of the table. The expense tracking sheet has been formatted.

What's your reaction?

Comments

https://ugara.net/assets/images/user-avatar-s.jpg

0 comment

Write the first comment for this!