Excel-1 is a guide to advanced features and tricks in Microsoft Excel. Here you'll find practical tips, instructions, and illustrations about working with ranges, Auto Fill, custom lists, Flash Fill, and modern formulas such as TEXTSPLIT and SEQUENCE.
📚 Goal: Help you use Excel more efficiently every day—suitable for both beginners and advanced users!
- Ranges in Excel
- AutoFit
- Auto Fill
- Custom Auto Fill List
- Flash Fill
- TEXTSPLIT Function
- SEQUENCE Function
- Screenshots
- Requirements
- Author
A range in Excel is a group of two or more cells.
To fill a range:
- Select a cell with a value or formula.
- Grab the small square in the bottom right corner and drag it.
📝 Tip: When you drag, Excel automatically recognizes patterns (formulas/numbers/dates) and extends them.
To move a range:
- Select the range, click its border, and drag it to a new location.
To insert/delete rows or columns:
- Right-click the row/column header and choose Insert/Delete.
To change column width:
- Drag the right edge of the header.
- Double-click the edge to auto fit to the longest content.
Initial column width.
AutoFit to the longest entry.
To automatically fit column width to its content, double-click the right edge of the column header.
Example of auto-filling formulas, times, and dates.
Auto Fill options for dates.
Result of filling months.
You can create your own list for quick auto-filling.
- File → Options → Advanced → General → Edit Custom Lists.
Add your own list here.
Effect: type e.g. "London" in a cell, drag, and the list will fill automatically.
ℹ️ Note: Custom lists are stored in the system registry and can be used in other workbooks.
Creating emails from a pattern.
- Type an example result next to your data.
- Select the cell and press CTRL + E (Flash Fill shortcut).
Flash Fill in action.
Splitting one cell into several.
Final result—press CTRL+E in each column.
⚠️ Remember: Flash Fill results do not update automatically if source data changes. For dynamic results, use formulas!
Instead of Flash Fill, you can use this formula:
=TEXTSPLIT(text, column_separator)
- Available only in Excel 365/2021!
- Fills multiple cells at once (spilling).
This function generates a sequence of numbers:
=SEQUENCE(rows, columns, start, step)
- Only in Excel 365/2021!
- Fills multiple cells at once.
You can find all screenshots in the /Screenshots folder.
- Microsoft Excel (recommended: 2021/365 for modern formulas)
- Windows OS (for custom lists)
Project and documentation by Kuba27x
Repository: Kuba27x/Excel-1