+ Reply to Thread
Results 1 to 6 of 6

Excel 2003 ctrl F feature doesn't work

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Seattle, WA, USA
    MS-Off Ver
    2013
    Posts
    19

    Cool Excel 2003 ctrl F feature doesn't work

    I'm currently using Excel 2003 (will be upgrading to 2013 in the near future) that seems to have an issues locating a specific job number in my spreadsheet.

    Allow me to explain:
    The worksheet has well over 1,000 rows of jobs that have been completed, of which the majority are hidden rows with the exception of a couple hundred for quick reference.

    Every now and again, I need to locate the date of a specific job that I know precedes the unhidden rows. I thought, simply hitting CTRL F, enter the job name, and voila, excel should automatically take me to that specified job so i may take note of that particular date. But this doesn't seem to be the case. So I thought, well, maybe if I unhide all of the hidden rows and then perform the search with the built-in search feature it should work. Think again, it doesn't. And to make matters worse, Excel 2003 oddly quits from being able to scroll with the wheel on the mouse. Now everything is frozen. Resulting only in loss in time and effort; not to mention that i now have to completely close out the worksheet, reopen it and continue from where i left off. This has been the case for some time now.
    If anyone has ever encountered this glitch and found a resolution, please inform me. Thank you!

    Also, note, I've made personal efforts to create a VBA search to alleviate my problem, but others in the community have advised against it, simply on the premises that the built-in search feature is, "as good as it gets."

    Am I only resolved to upgrading to excel 2013 in hopes that my problem will go away, or is there a sound solution?

    Please, let me know.

    Cris

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,931

    Re: Excel 2003 ctrl F feature doesn't work

    Hard to say what might be causing the problem I still have 2003 and have not come across that problem.

    Do you have titles fixed? maybe they cover too many rows?
    Does thos only happen in that file, or in other files too?

    Can you upload the WB?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-12-2015
    Location
    Seattle, WA, USA
    MS-Off Ver
    2013
    Posts
    19

    Re: Excel 2003 ctrl F feature doesn't work

    Hi FDibbins,

    Yes, i believe the titles are fixed, if i remember correctly.

    Since the WB is on the company server, I'll have to wait until tomorrow to send you it.

    Thank you for the reply,

    Cris

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,931

    Re: Excel 2003 ctrl F feature doesn't work

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  5. #5
    Registered User
    Join Date
    01-12-2015
    Location
    Seattle, WA, USA
    MS-Off Ver
    2013
    Posts
    19

    Re: Excel 2003 ctrl F feature doesn't work

    The solution to my problem was to unfreeze the top row.

    I guess having the top row frozen after unhiding multiple rows seems to cause a glitch in the scroll, that is until I unfreeze any frozen rows - Would have never guessed.


    Thank you,

    Cris

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,931

    Re: Excel 2003 ctrl F feature doesn't work

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. My Ctrl+D doesn't work, how can I reset?
    By mikenoble in forum Excel General
    Replies: 2
    Last Post: 09-19-2020, 11:50 PM
  2. Excel 2007 : Ctrl+1 doesn't work
    By aztek75 in forum Excel General
    Replies: 3
    Last Post: 09-06-2010, 06:31 AM
  3. [SOLVED] why doesn't ctrl+page down work?
    By Faith in forum Excel General
    Replies: 2
    Last Post: 05-21-2006, 10:45 AM
  4. [SOLVED] Why doesn't the automatic fill feature work in excel?
    By JenniferO in forum Excel General
    Replies: 4
    Last Post: 05-10-2006, 03:20 PM
  5. Replies: 1
    Last Post: 08-03-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1