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! |
Saturday, April 15, 2017 – Permalink – Custom ListsYour WayAt times, you will want to enter the same information repeatedly in a spreadsheet. It could be employee names, products or State names. Here is a way to produce the information when needed. Make a list of the items. Enter the data in, say, A1, B1, C1 etc. Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order. Select all of the cells. Go to Tools>Options and choose the Custom lists tab. Click Import. OK your way out. Now you can delete the entries on the spreadsheet. Choose any cell and type one of the items that are on your Custom List. Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell. As you pull, Excel will duplicate your list. (In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.) Also see: The First Shall Be Last by Dick Kusleika Sorting by Color by Chip Pearson See all Topics excel Labels: Customize, General, Lists, Reference, Tips, Tutorials <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
|