if i select a cell then i want row containing that cell selected

  • Thread starter Thread starter Guest
  • Start date Start date
Do a Data > Filter > Autofilter on the key col,
filter out that certain value, then copy the filtered rows,
and paste special as values/formats elsewhere as required
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Add ^ to a row of cells containing letters 3
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Excel Conditional Formatting 1
Drag without incrementing 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
IF cells(row,column) contain "this word" ??? Then return text 1
Excel Typed text appears in wrong cell 0

Back
Top