How do I skip to a letter in an alphabetically sorted list?
I have createad a database and alphabetically sorted the items - is there a
shortcut or a quick way to jump to a particular letter rather than scrolling down the whole thing to find 'r' etc? |
How do I skip to a letter in an alphabetically sorted list?
Hi,
Could Ctrl F be of any help ...??? Cheers Carim |
How do I skip to a letter in an alphabetically sorted list?
Hi
You could "cheat" Insert a column before your list of items. Lets assume you inserted a new column A In cells A1 enter =LEFT(B1) Double click on the fill handle (the small black cross that you see when you hover over the bottom right of the cell) and this will copy the formula down the column for you. Place your cursor in cell A1 and DataFilterAutofilter Use the dropdown to select the letter you want, and you will see a filtered list of only the items beginning with that letter. -- Regards Roger Govier "rosy_pie" wrote in message ... I have createad a database and alphabetically sorted the items - is there a shortcut or a quick way to jump to a particular letter rather than scrolling down the whole thing to find 'r' etc? |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com