#1   Report Post  
Old November 2nd 05, 05:50 PM
Jenn
 
Posts: n/a
Default spreadsheet

I'm still learning on Excel. I'm making a spreadsheet, and I have all of the
alphabet, i want to be able to use Auto Filter and press on A and get all the
A's Is it possible to only have the alphabet in the auto filter, so if i need
to use F all i have to do is press F and all the F's will show up?


  #2   Report Post  
Old November 2nd 05, 06:49 PM
Gary''s Student
 
Posts: n/a
Default spreadsheet

Say you have a column of words or phrases with a label on top of the column,
for example column A In cell B2 enter =left(A2) and copy down. Column B
will now contain the first letter of column A

Select column B and pull-down Data FIlter Autofilter.
--
Gary's Student


"Jenn" wrote:

I'm still learning on Excel. I'm making a spreadsheet, and I have all of the
alphabet, i want to be able to use Auto Filter and press on A and get all the
A's Is it possible to only have the alphabet in the auto filter, so if i need
to use F all i have to do is press F and all the F's will show up?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Returning values in another spreadsheet lrbest4x4xfar Excel Worksheet Functions 1 October 14th 05 02:52 PM
Hyperlinking to Excel 2000 with a linked spreadsheet LDPitsy1970 Excel Discussion (Misc queries) 0 October 12th 05 02:31 PM
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM
Spreadsheet Dilemma msbates2004 Excel Discussion (Misc queries) 1 May 27th 05 02:55 AM
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 01:37 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017