How to save frequently used list and reuse it in future work in Excel?
Do you often use the same list of data in Excel and want an easier way to reuse it without manually re-entering it each time? This tutorial shows two simple methods to save a frequently used list and quickly reuse it in future worksheets:
Save a list and reuse it with Edit Custom List feature
Save and reuse your list with formatting using Kutools for Excel
Save a list and reuse it with Edit Custom List feature
You can use the Edit Custom List feature to save the frequently used list for next time using. Please do as follows.
1. Select the list, and then click File > Options.
2. In the Excel Options dialog box, click Advanced in the left pane, scroll down to the General section, and then click the Edit Custom Lists button. See screenshot:
3. In the Custom Lists dialog box, click the Import button to add the list values into the Custom lists box, and then click the OK button.
4. When it returns to the Excel Options dialog box, click the OK button.
5. To apply this list, enter the first value into a cell and drag the Fill Handle down the column to populate the rest of the list.
Save and reuse your list with formatting using Kutools for Excel
The Resource Library feature of Kutools for Excel allows you to easily save a frequently used list as an auto-text entry. This method not only saves the list but also preserves its cell formatting, enabling you to quickly reuse the list with consistent formatting whenever needed.
When first installing Kutools for Excel, the Navigation pane will be opened and located on the left side of Excel by default.
1. Shift to the Resource Library section by clicking the Resource Library button 
in the Navigation pane.
2. Save the frequently used list as an Auto Text entry:
button.
3. Quickly reuse the list in future work with just a few clicks:
The list, along with its cell formatting, will be instantly inserted into the column starting at the selected cell.
Click to know more about Kutools' Resource Library.
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
Related articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite ā Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license ā set up in minutes (MSI-ready)
- Works better together ā streamlined productivity across Office apps
- 30-day full-featured trial ā no registration, no credit card
- Best value ā save vs buying individual add-in