20+ Excel Table tricks to turbo charge your data

Excel Table Trick # 13. Get a new navigation system inside table

Normally when you press a Tab key it moves to the right. Same is the case in table. However, once you reach the last column of the table press the tab key again and it will go the next row. Similarly once you reach the last cell of last row, pressing tab key again will insert a new row in the table.

Excel Table Trick # 14. Drag and drop table easily without worrying about change in cell reference

With normal data ranges even you can move them easily by selecting and dragging-dropping them. However, if formula is dependent on such ranges then most probably it will break. However, with tables you do not have to worry if you have to move tables within worksheet anywhere if you are using structured references.

To move data simply move to the edge of table at the right or bottom of table and pointer will turn into four-point cursor click and hold to drag the table and move to other place. And if you have not noticed you don’t have to select the table first to move it. Saved you a shortcut key even 😀

Following animation makes it clear.

Notice that formula to sum the yearly sales is:

=SUM(SalesTable[[Sales]])

Now even if you move the table within worksheet anywhere or even to another worksheet altogether this formula won’t break. The reason is that structure is worksheet and cell address independent. We have named the table in the formula and particular column now wherever this table is formula will work without a hitch.