Forum Discussion
Autofill excell
İ want to autofill columns like this first columns =ba bo bu Second =ca co cu third =da do du So All consonats +a,o,u up to =za zo zu Can you help me for this is this possible
I don't think there is an easy way to generate the consonants of the alphabet, so I would simply list them.
If you have Microsoft 365 or Office 2021, enter this formula in a cell:
={"b";"c";"d";"f";"g";"h";"j";"k";"l";"m";"n";"p";"q";"r";"s";"t";"v";"w";"x";"y";"z"}&{"a","o","u"}
It will automatically spill to 21 rows and 3 columns.
If you have an older version, select a range of 21 rows by 3 columns, for example A1:C21, enter the formula mentioned above and confirm it by pressing Ctrl+Shift+Enter.
The only it was request columns, not rows. We have to exchange an order in formula.
Thanks, I hadn't noticed that.