ok tricky to explain but ill try … i am presuming you require the same date in all 700 cells if so you can do this
step 1 … say you are starting in cell A1 and going down to cell A700 … click on cell A1
step 2 … just above the cell (there will be a box showing the cell your in and it will say A1) click there … this will highlight the A1 in that box … click again and now your cursor is beside the Ai … now enter : a700 now hit enter … this will now select A1 to A700 in your excel sheet
step 3 … now hit f2 you will now have entered cell A1 and all other cells are still selected.
step 4 … now do Ctrl : this adds the date to the first cell (dont hit enter after you do this)
step 5 … Finally press Ctrl and Enter … this will fill all 700 cells with the date
Here is a link to the best online site for Excel … I love excel and learned so much from this site