Need some Excel help
August 5th, 2016
I want to do the same thing as show in the picture below:
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.
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
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!
Np. Glad you figured it out.