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 ...

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you!

Microsoft Excel's Formula by Example helps automate repetitive tasks in structured tables in Excel for the Web. The tool is similar to Flash Fill, though it generates dynamic formulas that update ...

Note: Excel 2010 users will find that this double-click trick works even if the adjacent columns are empty, as long as column headings connect the highlighted data to a distant column that can be ...

One Excel feature that will save you time is Autofill, which can generate a series of dates for your worksheets.

Tips If you use AutoFill to populate a date series but want to use the date formatting from another cell, use "Fill Series" to complete your data.

Learn how to create date lists in Excel using autofill, formulas, and advanced techniques. Save time and boost efficiency with these tips ...