![Excel 2010 Tutorial 8 – Absolute Reference $](http://computerrepairspot.com/wp-content/uploads/2013/02/02132c84b50.jpg-150x112.jpg)
www.schoolfreeware.com The AutoFill has problems placing information into rows from data that is in columns (or placing data from columns into rows). The absolute reference $ must be used to remedy this problem. Within this tutorial, the absolute reference $ is used with the INDEX function. For users who do not have keyboard that allows for the dollar sign $, F4 (Windows) Command T (Mac) can be used to add the dollar sign to the cells.