Silly+trick+for+repeating+data+on+Excel

Maybe you know this, but when you want the data from the cell directly above to copy down you can just hit " and Ctl at the same time. This is handy when you are manipulating data or are trying to streamline data. That way, if you are going line by line and you are using the keyboard you dont lose time by using the mouse.

Another way to write data down a column fast is to type the information in a few of the rows. Next simply click the corner of the cell and drag it down. Excel will notice the pattern of the data, whether it is increasing time or money and fill in the cells which you've selected with the same pattern as the first few cells that you mannually typed in.