Need some Excel help

August 5th, 2016

This should be something pretty simple, but I barely use Excel and I don’t know what to look for @ Google.
I want to do the same thing as show in the picture below:

View post on imgur.com


In short:
I want to display the dates under each other in each separate cell. Of course I could type it all manually, but lets say you have the write down
the dates for an entire year, it’s really stupid to write all the days manually, that would be 365 cells.
So I’d like to know if there is a way to do this automatically.
I know how to automate the date in 1 single cell, but I can’t for example select x amount of cells and put in a date range and the cells get filled up automatically.
Hopefully someone understands what I’m trying to say.
I’d like to do that in Excel 2016.
Thanks.
Answer #1
Write the first cell with the correct date. Select it and drag the bottom right cell to autocomplete and fill as many cells you want.
This is what i am describing
https://support.office.com/en-za/article/Fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db#bmaboutfillhandle
Here i made a video so you can watch the steps
http://s767.photobucket.com/user//media/15-275H6_zpsbhlvbog6.gif.html
Answer #2
Write the first cell with the correct date. Select itand drag the bottom right of the second cell to autocomplete and fill as many cells you want.
This is what i am describing
https://support.office.com/en-za/article/Fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db#bmaboutfillhandle
Here i made a video so you can watch the steps
http://s767.photobucket.com/user//media/15-275H6_zpsbhlvbog6.gif.html

LOL!
It’s really that easy.
I actually tried what you showed in gif, but instead of copying the content of the cell, I just selected the cells (so without the content being copied)
That was a good explanation. I only missed the last part, thank you!
Answer #3
Np. Glad you figured it out.

 

| Sitemap |