Re: Opening Outlook attachments
Lisle, Ted (CHFS DMS)
I thought that was a sequential thing--January February, Etc.
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of Bob Hicks
Sent: Friday, June 23, 2017 1:22 PM
Subject: Re: Opening Outlook attachments
Yes, that is hoe it used to work for me on Excel 2007 at home and work. At home I have Excel 2016 and here at work I have Excel 2013. Auto fill does not work on either version of Excel now.
Here at work on Excel 2013 I have a column with the words “office” or “lunch” in it. Even though lunch repeats 10 times and office repeats 20 times, it doesn’t auto fill. I Googled the steps to enxure that auto fill is turned on, but no dope? I must be overlooking something, but I cannot find it. Crap! Auto fill is on by default as I remember it.
Thanks for trying.
Have a great day!
For me autofill works regardlss of how many words there are. The only time where I have to type more before it kicks in is if two separate phrases start the same way. Here are some examples:
If I type “Scotia Bank Visa” once and then start typing it again I most likely only have to type “Sc” before the autofill kicks in.
If I now want to type “Scotia Bank Line of Credit”, I will get the autofill for “Scotia Bank Visa” while I type “Scotia Bank”, only after I press the space bar and type the “L” for the word “Line” will the autofill end and I can finish typing “Line of Credit”.
Now having typed both phrases, autofill will not kick in when I type “Scotia Bank”, it will only kick in and fill the rest of the words if I type “V” or “L” after Scotia Bank and the spacebar. In the case of “Scotia Bank Visa” it will only complete the “isa” of “Visa”, in the case of “Line of Credit” it will autofill “ine of credit” after I type the “L”.
I hope this makes sense.
Tnx. What about having 2 or 3 different words in the same column? I am trying for auto fill whenever I duplicate the same word in the same column.
Have a great day!
Can’t you just press Control + S in a protected document to unprotect it? You will be prompted to allow saving or something like that. Should work in Excel too, I think.
If you want to fill cells with the same info, in your example, type “Lunch” in the first cell. Then, press Control + G to open the “Go to Cell” dialogue box and type in the last cell you want. Press Shift + enter and that range will be selected. If the cells you wish to fill with “lunch” are below the cell you are in, press Control + D to fill down. If the cells are to the right, press Control + R to fill right.