Insert Table converts the information typed in rows and columns into a structured table.  In Excel a table is a rectangular range of structured data. Each row in the table corresponds to a single record.  How do you know what makes up a table?  You simply click in a cell that has data and click CTRL+A and it will select the entire table.  You will notice that the table is surrounded by white empty cells.  Therefore, there can exist many tables in one sheet and Excel will recognize it by the white empty cells.

Selecting Parts of a Table:

When you move your mouse around in a table, you may notice that the pointer changes shapes. These shapes help you to select various parts of the table.

  • To Select an Entire Column:
    Move the mouse to the top of any cell in the header row and the mouse pointer changes to a down-pointing arrow. Click or CTRL+Spacebar to select the data in the table column . The header name is not chosen.
  • To Select an Entire Row:
    Move the mouse to the left of any cell in Column A of a row and the mouse pointer changes to a right-pointing arrow. Click or Shift+ Spacebar to select the entire table row.
  • To Select an Entire Table:
    Move the mouse to the upper-left part of the upper-left cell. When the mouse pointer turns into a diagonal arrow, Click to select entire table. You can also click CRTL+A.

Excel Remembers:

Excel remembers the format and formula so when you enter a new row within the table, it will apply that format or formula to that cell. This is also true for cell protection, data validation, conditional formatting, and so on. If a chart is applied to the table, the new information is automatically extended to the chart.

Removing Duplicate Rows in a Table:

When you choose the Remove Duplicate command from the Table Tools, Excel will delete a row ONLY if the content of every column is duplicated. In some situations, you may not care about matching some columns, so you would delselect those columns in the Remove Duplicates dialog box. When duplicate rows are found, the first row is kept and subsequent duplicate rows are deleted.

Filtered Data: 

When you copy data from a filtered table, only the visable data is copied. The hidden rows are not copied. When you paste the information, the paste act as Paste Values Only.  If you choose to the information with formulas, Relative Addressing goes into affect and you need to place Absolute in the formulas before you copy and paste.

 

 

Advertisements