3/31/2023 0 Comments Excel for mac autofill offRange("A1:A2").AutoFill Destination:=Range("A1:A12"), Type:=xlFillMonths Select the Type as xlFillMonths as shown below. Step 6: Now here comes the moment, when we will select the time of autofill we need. We can select any range but selecting the same range makes it easy to implement. Step 5: Now select the range where we will need to autofill the names of months till Dec. Step 4: Now select the function we need to perform which is “ Autofill”, allowing the Destination to get selected as shown below. Step 3: Select the range of the cells which we need to drag or extent for autofill.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |