Excel Formulae: Letters In Sequence : A, B, C.....

I would like to create a column with letters from alphabet in a sequence.

If I write A and in cell below I put B then highlight the two cells and drag down I get a repetition of A and B.

How do I get the following alphabet letters ie. C,D, E etc.?

If you type the first letter into first cell (say A1), then below:

=CHAR(CODE(LEFT(A1,1))+1)

copy down ...

note once you get beyond Z you will get odd results, do you plan to go beyond Z and if so what should succeed Z ... if it is AA you can revert to an ADDRESS approach.

 

For example:

Say first letter was always A and was to start in A1:

=SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),2),"$1","")

copy down as far as required --

27th entry would become AA, 28th AB etc...

-->

T8ZU3RT4ER6Z

How to count the number of worksheets used in an MS Excel file

Assuming I have a number of workbooks with a large number of worksheets filled out (not by me) in each workbook. Do you know how to count the number of worksheets used ?

Well you wouldn't be interested in manually counting by clicking each worksheet ?
Yes there is a way! A much easier than using the VB code;

Here we go;
We use Excel in built formula:

=COUNTA('*'!A1)+1

... where assuming A1 in each sheet is non-blank.

Example:

1. Suppose I have an xls file with 100 sheets:
2. I choose cell B2 and place my formula in it.







3. Press the followin gkeys: Ctrl+Shift+Enter

4. You get the answer as 100 in the cell B2