Hi everyone, new (ish) to Microsoft Excel and I’m having some trouble with the Autofill tool. I have an old schedule that I’d like to update the dates on, without having to manually input each date. I read online that you could autofill while skipping certain cells by pressing ctrl (cmd for me bc ios), but when I do that, the shortcut Autofill icon disappears. When I search for Autofill, I can’t find the option of Fill w/o Formatting. I can always go back and individually correct each cell color and date, but I’m sure there has to be some ways to cut down on time, I just don’t know where to look.  The dates in the photo were the ones I tried messing around with, but as you can see I’m unable to keep the original cell colors. 

​Hi everyone, new (ish) to Microsoft Excel and I’m having some trouble with the Autofill tool. I have an old schedule that I’d like to update the dates on, without having to manually input each date. I read online that you could autofill while skipping certain cells by pressing ctrl (cmd for me bc ios), but when I do that, the shortcut Autofill icon disappears. When I search for Autofill, I can’t find the option of Fill w/o Formatting. I can always go back and individually correct each cell color and date, but I’m sure there has to be some ways to cut down on time, I just don’t know where to look.  The dates in the photo were the ones I tried messing around with, but as you can see I’m unable to keep the original cell colors.    Read More

​