Building an excel spreadsheet

Building an excel spreadsheet.

1. Start Excel and create a new workbook.
2. Enter data as shown in Figure below, sizing columns as necessary, and then save your file, naming it School Supplies.

1. Merge and center cells A1 through H1. Format the school name as Title style.
2. Merge and center cells A2 through H2. Format the label as Heading 1 style.
3. Bold the labels in row 4 and right align the labels above numeric values.
4. Format the Cost/Unit values as Currency with 2 decimal places. Your spreadsheet should look like Figure below.

Building an excel spreadsheet

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.