Guidelines for Creating a List on a Worksheet Microsoft Excel has a number of automatic features that make it easy to manage and analyze data in a list. To take full advantage of these features, enter rows and columns in a list according to the following guidelines. List Size and Location ... This helps Microsoft Excel automatically select your list when you sort, filter, or insert automatic subtotals. ai For bestanbsp;...