Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Monday, June 22, 2015 – Permalink – Choose List CriteriaSet values
To create a named range, select the list: Hit Ctrl+F3. Enter the name and hit OK (or Enter), or Type the name in the Name Box on the left side of the Formula bar and hit the Enter key, or Go to Insert>Name. If the list selected includes a label/title, choose Create, otherwise choose Define, type the name and hit Enter).Also Contextures.com: Data Validation -Create Dependent Lists See all Topics excel Labels: Customize, Formulas, General, Lists, Reference, Tips, Tutorials <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
|