Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...

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.

Fill in the formula field with "SUM (A:A)" and replace "A:A" with the indefinite range you want to total. For example, if you wanted to find the total of all the data in column C, you would enter ...