Sample Excel report designing:
Here i have explained about simple report creation and designing
Enter columns names under each columns a..z as mentioned below.
=> Align data in the columns to appear in center, left,right
If you dont see the format options, click on home page as shown below.
Now the excel options are visible as shown below
I have entered some data below the columns
=>Now select the columns which you want to align. when you select column, the columns gets highlighted and then click on align center button
Now the studentId column looks center aligned. see the image below.
=>Now do the same for all the columns in the sheet. and the report looks as below.
=>Now i am creating the header line for the report
=>Select the rows in the top from cell A to E. and then click on Merge & Center
Now the top row which i selected for heading is merged and i have filled a sample school name and address in 2 rows.
now click on fill color and fill some different color for header lines
and for the data columns
My final report looks like this.
Hope the report creation steps are simple and useful
