# Excel

# Excel 365 Sequence Function

Everyone knows the trick to creating a sequence of number in Microsoft Excel. Start the sequence and then select it and drag down the column (or rows) creating the sequence of numbers.

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/8z8image.png) ](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/8z8image.png)[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/nkNimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/nkNimage.png)

However, in the Office 365 version of Microsoft Excel there is a new dynamic array formula

=SEQUENCE(rows, \[columns\], \[start\], \[step\])

##### Positive sequence 1 to 20 example

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/rrAimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/rrAimage.png)

##### Negative sequence 20 to 1 example

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/UGGimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/UGGimage.png)

##### Positive sequence 1 to 6 across columns

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/taQimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/taQimage.png)

##### Sequence of 20 days ascending

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/Z23image.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/Z23image.png)

##### Sequence of the months of the year

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/kJbimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/kJbimage.png)

##### Sequence of numbers across 10 rows and 5 columns starting at 0 and stepping by 3

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/63aimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/63aimage.png)

##### Last one - Sequence of numbers 1 to 20 with a prefix AND the number only shows if there is an item in the B column

="No. "&SEQUENCE(COUNTA(B:B))

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/YFbimage.png) ](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/YFbimage.png)[![mHLimage.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/mhlimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/mhlimage.png)

# Excel Autofill Letters from A to Z

This formula tip will let you fill a column with the letters A to Z.

Start by putting the letter A in a cell. I put the letter A in the cell A1 for the example below. Then in cell A2 I inserted the formula. Note I reference the cell A1. Then I simply copied the formula down to the A26 cel and viola I have the alphabet automagically.

=CHAR(CODE(A1)+1)

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/yjsimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/yjsimage.png)

# Excel Compact U.S. Calendar Template

[MyCalCreatorTemplate.xltx](https://bookstack.taylorhome.run/attachments/21)

I want to give credit to [David Seah](https://davidseah.com/pceo/cal) for the original idea for this compact calendar. I took David's calendar idea and modified a number of formulas especially the way the holidays are calculated as well as the addition of other features.