Do Not Write Anything In Column AA
Do not write anything in the cells in column AA because they serve as a the right-side border of the data area. So this column must be left blank, unless you know the effect. You can write anything in cells after column AA, i.e. column AB onwards.
No Blank Cells In SRC Column
Make sure there are no blank cells in the cells below the column title SRC, between the rows of data. This column will serve as the left-side border of the data area. If there is a blank cell under the column title SRC, Excel will most likely use the blank cell to segregate the data area. This will affect the results of data manipulation using Filtering and PivotTable functions.
No Blank Cells Between Items In Column Titles
Make sure there are no blank cells in between column titles in row 4. This row will serve as the top-side border of the data area. If there is blank cell separating column titles, Excel will be confused as to the area of your data. This will affect the results of data manipulation using Filtering and Pivot Table.
No comments:
Post a Comment