Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,471
There are 999 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     HTML/XHTML/DHTML/CSS :

Add a search feild into a excel document!

Thread title: Add a search feild into a excel document!
Closed Thread    
    Thread tools Search this thread Display Modes  
05-15-2008, 10:39 AM
#1
SuboHost is offline SuboHost
Status: I love this place
Join date: Jan 2007
Location:
Expertise:
Software:
 
Posts: 503
iTrader: 3 / 100%
 

SuboHost is on a distinguished road

  Old  Add a search feild into a excel document!

Hi at work im making a basic excel documnet and i need to include a search feild in the actual document (non of the staff no how to turn a computer on so trying ot explain how to use the excel search is just to much of a pain)

if anyone oculd help or point me in the right direction that would be great :P

05-15-2008, 10:43 AM
#2
Jeff Andersen is offline Jeff Andersen
Status: Superstar
Join date: Apr 2005
Location:
Expertise:
Software:
 
Posts: 4,449
iTrader: 10 / 100%
 

Jeff Andersen is on a distinguished road

  Old

So you're searching for just one cell's contents?
Ctrl+F then type the contents if so.

But if you're looking for sorting and querying, it really should be in a solution like Microsoft Access where reports and queries are easily customizable. Where you can't really do this with Excel.

Regards,
Jeff

05-15-2008, 11:03 AM
#3
Liam is offline Liam
Liam's Avatar
Status: Member
Join date: Dec 2007
Location: Liverpool, UK
Expertise:
Software:
 
Posts: 287
iTrader: 0 / 0%
 

Liam is on a distinguished road

Send a message via MSN to Liam

  Old

yeah, you will need to export your excel doc into access and use some SQL to sort it out.

05-15-2008, 01:21 PM
#4
SuboHost is offline SuboHost
Status: I love this place
Join date: Jan 2007
Location:
Expertise:
Software:
 
Posts: 503
iTrader: 3 / 100%
 

SuboHost is on a distinguished road

  Old

ok do you no how to add a search bar to the toolbar of excel that woluld do i just need people ot be able to search the documnet easely with no nolege of excel

thanks

05-15-2008, 02:55 PM
#5
Jeff Andersen is offline Jeff Andersen
Status: Superstar
Join date: Apr 2005
Location:
Expertise:
Software:
 
Posts: 4,449
iTrader: 10 / 100%
 

Jeff Andersen is on a distinguished road

  Old

Just teach them Ctrl+F, there's no 'Search bar' tool bar for Excel.

Closed Thread    


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed