auto fill excel or google spreadsheet dates

Tired of typing in all the dates in the left column in your spreadsheet? Well type no more! Posting this here so more people will see this helpful tip.

Most of us maintain spreadsheets for our kittehs. You can populate all the dates in the left column automatically, so you do not have to type in all the dates. This is real easy and anyone can do it for their spreadsheet. I found a short online tutorial for it. The first 90 seconds of the tutorial shows you how.

https://support.office.com/en-us/article/fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db

The tutorial is for excel, but this applies to our google sheets as well - for the auto populate feature. Some excel features are not found in google sheets. As you see in the tutorial, it is not just for dates. You can do other sequences - numbered rows, days of the week, etc.

I have been doing this in excel and google sheets for years.

 

Thanks!

 

That is cool!!!

Thanks so much!!

 

Excel.....yummy. When I figured out the and/if formula my life was complete. No one knows this but I run enormous spreadsheets to pretend gamble.
I can do a copy/paste formula if anyone wants it.

 

Pretend gamble........ have you tried it in casino?

 

No casino for me. I used to handicap horses, strictly numbers only. About 30 years ago I lost a bucket of $$$ in one night and the math said I had to go back the next night. I did, won 10 races in a row and never went back. Now it's more an OCD math thing and besides that there's no hiding anything in this house and I prefer it that way. Cynthia gets on the computer and gets pop up ads for snowblowers or big hammers so she knows I'm not looking at something else.