excel 2013 print preview shows extra line

The list should be separated from any other data on the.The list should have no blank rows within it, and no completely.Each row in the list should contain the details for one record,.Each column in the list should contain one type of data,.In the first row of the list, each column should contain a short,.The data should be organized in rows and columns, withĮach row containing information about one record, such as a sales.Custom Views are not allowed in a workbook that has 1 or more Excel tablesīefore you create the formatted Excel Table, follow these guidelines.You can't group and copy or move multiple sheets, if any sheet contains an Excel table.Tables won't expand automatically on protected sheets, even if the cells below the table are unlocked.Structured references to table cells don't have an 'absolute' setting, so it's a bit trickier to copy them across a column.There are a few drawbacks to using named Excel tables though, so there might be situations where you prefer not to use them.

You won't have to readjust the range, if data is added or removed

An Excel Table makes an excellent source for a Pivot Table.

Show or hide the table's built-in Totals row, where formulas show a Sum, Average, Count, or other summary amounts.

Formulas use structured references to table cells, showing the column name.Formulas and formatting fill down automatically.Built-in styles make it easy to format the table's appearance, or change to a different look.The table range expands and shrinks automatically, when you add or remove rows of data.In the header row, drop down lists in the heading cells make it easy to sort and filter the data.

Excel 2013 print preview shows extra line