tip 107 how to use excel custom lists
Post on 08-Jul-2015
202 Views
Preview:
DESCRIPTION
TRANSCRIPT
How to Create & Use Excel Custom Lists
In All Versions of Excel
(2010, 2007, 2003)
Copyright 2011 The Company Rocks LLC
Steps to Follow
1. Type list in contiguous cells
2. Select list and use F7 key to check
spelling
3. Open “Edit Custom Lists” dialog box
• Varies by Excel Version
– see screen illustrations
4. Click Import
Copyright 2011 The Company Rocks LLC
In Excel 2010
O File Tab on Ribbon
O Options
O Advanced Tab
O Scroll down to end
Copyright 2011 The Company Rocks LLC
In Excel 2007
O Office Button
O Excel Options
O Popular Tab
Copyright 2011 The Company Rocks LLC
In Excel 2003
O Tools Menu
O Options
O Custom Lists Tab
Copyright 2011 The Company Rocks LLC
How to Use Custom ListsTo quickly ensure accuracy & consistency
Copyright 2011 The Company Rocks LLC
AutoFill Series of Labels
Copyright 2011 The Company Rocks LLC
Sort Using Custom List
Copyright 2011 The Company Rocks LLC
Learn More MS Office Tips
Copyright 2011 The Company Rocks LLC
Contact Information
Copyright 2011 The Company Rocks LLC
top related