+ Reply to Thread
Results 1 to 7 of 7

select entire row after using CTRL+F

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    Motru
    MS-Off Ver
    2019
    Posts
    11

    select entire row after using CTRL+F

    after finding cells that contain certain text using CTRL+F, how do I select the entire row that contains that cell ?

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,133

    Re: select entire row after using CTRL+F

    After the CTRL+f find the cell, click SHIFT+SPACE
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-04-2021
    Location
    Motru
    MS-Off Ver
    2019
    Posts
    11

    Re: select entire row after using CTRL+F

    Attachment 754287

    well . there are multiple rows . and this happens when I press shift space

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,133

    Re: select entire row after using CTRL+F

    That technique selects the entire row for whatever cells are selected. However, it will not work for a discontiguous selection.

    What are the steps you took to reach the condition in the image you attached?

    If you are selecting multiple cells that are discontiguous then you either have to do this manually or write a macro to do it.

  5. #5
    Registered User
    Join Date
    11-04-2021
    Location
    Motru
    MS-Off Ver
    2019
    Posts
    11

    Re: select entire row after using CTRL+F

    trying to select all cells that contain AUS . and yes there is a discontiguous selection.

    I ctrl+f for the (AUS) keyword . thats it . pressing shift backspace selects only a part of rows .

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,133

    Re: select entire row after using CTRL+F

    When I do that it only selects one cell. Nevertheless, there is no built-in solution that I am aware of.

  7. #7
    Registered User
    Join Date
    11-04-2021
    Location
    Motru
    MS-Off Ver
    2019
    Posts
    11

    Re: select entire row after using CTRL+F

    ok . I will select them one by one I think.
    thanks !

+ 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. CTRL+Spacebar not working to select entire column?
    By MetroBOS in forum Excel General
    Replies: 5
    Last Post: 04-29-2021, 09:16 AM
  2. [SOLVED] CTRL + A doesn't select all
    By KJC in forum Excel General
    Replies: 5
    Last Post: 09-17-2020, 12:02 PM
  3. Disable cut,copy,paste(including ctrl x, ctrl c n ctrl v)
    By Ramboexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2014, 01:00 AM
  4. Replies: 4
    Last Post: 09-11-2014, 07:40 PM
  5. Can't use ctrl-a (select all) in Find dialogue
    By John Fry in forum Excel General
    Replies: 4
    Last Post: 08-25-2011, 10:59 PM
  6. Select ALL (CTRL+A) VBA code
    By makku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2008, 07:52 AM
  7. A better CTRL A select
    By Ambrosia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2005, 10:57 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06618 seconds
  • Memory Usage 9,031KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1