Question description:
This user has given permission to use the problem statement for this
blog.
I must have done something to mess up my autofill. I want to have a column of dates (ex. September 20, 2018 through November 30, 2018). When I use the fill handle, the date increases by a year not a day. How do I fix this?
Solved by D. D. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/08/2018 - 11:03
hello..
User
04/08/2018 - 11:03
hello.
Excelchat Expert
04/08/2018 - 11:03
how can i help you today..??
User
04/08/2018 - 11:04
I must have done something to mess up my autofill. I want to have a column of dates (ex. September 20, 2018 through November 30, 2018). When I use the fill handle, the date increases by a year not a day. How do I fix this?
Excelchat Expert
04/08/2018 - 11:04
hold on..
User
04/08/2018 - 11:04
Okay
Excelchat Expert
04/08/2018 - 11:06
[Uploaded an Excel file]
Excelchat Expert
04/08/2018 - 11:06
select fill..
Excelchat Expert
04/08/2018 - 11:06
[Uploaded an Excel file]
Excelchat Expert
04/08/2018 - 11:06
click series..
Excelchat Expert
04/08/2018 - 11:06
[Uploaded an Excel file]
Excelchat Expert
04/08/2018 - 11:06
select day..
User
04/08/2018 - 11:07
Select fill from where?
Excelchat Expert
04/08/2018 - 11:08
first you need to select area you want to fill..
Excelchat Expert
04/08/2018 - 11:08
and click Home>Fill>Series..
Excelchat Expert
04/08/2018 - 11:08
there you can choose day..
Excelchat Expert
04/08/2018 - 11:09
download screen capture I upload in here..
User
04/08/2018 - 11:10
I've done that, and it says step value 1, stop value is empty.
Excelchat Expert
04/08/2018 - 11:10
[Uploaded an Excel file]
Excelchat Expert
04/08/2018 - 11:10
this is the first step..
User
04/08/2018 - 11:10
I'm not sure how to capture the screen image on my MAC
Excelchat Expert
04/08/2018 - 11:12
if you move you mouse top right corner, you will see download sign..
Excelchat Expert
04/08/2018 - 11:12
once it downloaded.. you can double click.. you will see the image..
User
04/08/2018 - 11:15
Sorry, don't see a download sign.
Excelchat Expert
04/08/2018 - 11:15
if you move you mouse on top right corner..download this file sign should be appear..
Excelchat Expert
04/08/2018 - 11:16
ok..
Excelchat Expert
04/08/2018 - 11:16
let's tackle one by one..
Excelchat Expert
04/08/2018 - 11:16
do you want to fill date...right..??
Excelchat Expert
04/08/2018 - 11:17
please follow my instruction..
Excelchat Expert
04/08/2018 - 11:17
are you ready...??
User
04/08/2018 - 11:17
yes
Excelchat Expert
04/08/2018 - 11:17
ok..
Excelchat Expert
04/08/2018 - 11:18
first write down date on C2..
Excelchat Expert
04/08/2018 - 11:18
9/20/2018
Excelchat Expert
04/08/2018 - 11:18
any date..
User
04/08/2018 - 11:18
ok
Excelchat Expert
04/08/2018 - 11:18
if you done.. let me know
User
04/08/2018 - 11:19
done
Excelchat Expert
04/08/2018 - 11:19
select area C2: C61
Excelchat Expert
04/08/2018 - 11:20
let me know if you selected area..
User
04/08/2018 - 11:21
Alright. when in C column, I do not have a problem with the autofill. it is just a problem in the A column.
User
04/08/2018 - 11:21
I suppose I can delete the column and replace it...
Excelchat Expert
04/08/2018 - 11:21
yes..
Excelchat Expert
04/08/2018 - 11:21
there are option in fill menu..
Excelchat Expert
04/08/2018 - 11:21
you can change date, week, month, year...
User
04/08/2018 - 11:22
Alright. Thank you for your assistance.
Excelchat Expert
04/08/2018 - 11:22
glad to help you out..
User
04/08/2018 - 11:22
have a good day.
Excelchat Expert
04/08/2018 - 11:22
do you have any other questions..??
Excelchat Expert
04/08/2018 - 11:23
have a good weekend..
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
