When working with Excel, we often create lists with plain serial numbers. But did you know you can create stylish or structured number lists with just a simple formula? By combining the UNICHAR and ROW functions, you can replace standard numbers with creative bullet-style numbers.
Formulas Used
Here are three variations you can use in Excel:
=UNICHAR(ROW(A1)+9311)=UNICHAR(ROW(A1)+9331)=UNICHAR(ROW(A1)+9351)
Each of these formulas generates a different stylish numbering style based on Unicode characters.
How the Formula Works
ROW(A1)→ returns the row number (for A1, it’s 1; for A2, it’s 2, etc.).- Adding
9311,9331, or9351→ shifts the number into a range of Unicode characters that represent special bullet-style numbers. UNICHAR()→ converts the Unicode value into the actual symbol.
This means, instead of just 1, 2, 3… you’ll get ① ② ③ or ➀ ➁ ➂, depending on the formula you use.
| Style | Formula |
| ① | =UNICHAR(ROW(A1)+9311) |
| ⑴ | =UNICHAR(ROW(A1)+9331) |
| ⒈ | =UNICHAR(ROW(A1)+9351) |
Example: Grocery List
Here’s a sample grocery list with stylish numbering:
| Sr. No. | Grocery Item |
|---|---|
| ① | Rice |
| ② | Wheat Flour |
| ③ | Sugar |
| ④ | Salt |
| ⑤ | Cooking Oil |
| ⑥ | Milk |
| ⑦ | Eggs |
| ⑧ | Bread |
| ⑨ | Potatoes |
| ⑩ | Tomatoes |
Where to Use This Trick
✅ To-do lists
✅ Project task lists
✅ Reports & dashboards
✅ Checklists
✅ Study notes
This simple trick makes your data visually appealing and easier to read.
YouTube Video
Discover more from Quickinfoz
Subscribe to get the latest posts sent to your email.