How to Activate Focus Cell Before Microsoft added Focus Cell to Excel, I would click the row number or column letter to ensure I was reading or adding data to the correct cell.

If you find entering data into spreadsheets to be mind-numbing drudgery, then you probably don't know about these cool, time-saving tricks that make Excel 2010 do the heavy lifting for you.

Simply convert the input range to a table and Excel will control data input as above – simply press Tab to move from cell to cell, within the table range.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.