I’m so glad you asked the question. I occasionally need to do similar steps and never thought about there being a shortcut to do it. I’ve generally fiddled with turning on filters or such to move through the column data, but this is so
much better. This is the great thing about this list!
Robin
toggle quoted messageShow quoted text
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Shan Noyes
Sent: Tuesday, September 1, 2020 3:33 PM
To: main@jfw.groups.io
Subject: Re: Using excel with Jaws question
Importance: High
Excellent!!!!
I just tried it and it is great… I work in computer security and end up trolling through server logs etc and when looking at transactions and wanting to jump to the next IP address and their transactions I was using the old down arrow
approach and it drove me insane.
This little trick is exactly what I was looking for when I sent my email this morning.
Just to let you all know the control spacebar for selecting the column also works with the control shift backslash item.
Thanks again and have a good evening.
Just about done for the day here.
-------------------------------------------------------------
WARNING, this email originated from outside of SaskTel.
Do not click links or open attachments unless you trust the sender and believe the contents are safe.
--------------------------------------------------------------
Thanks for finding my typo error!
Yes, this is quite the nice trick, and can come in handy sometimes.
Chris was close. He wrote backspace, but he should have written back-slash. I just did it for the first time and got it working with both a column of numbers and with a column of two-letter state abbreviations.
to summarize,
1, hit control shift down arrow.; this selects all the contents of the column from where you are to the next blank cell in the column.
2. Now hit Control Shift backslash Excel move focus to the next different value. Note that the cells below this are still selected.
Really cool trick, Chris. Thank you for sharing I’m sure I will find this valuable.
I have the keystroke that you are needing.
Ok, hold down the control and shift. Do not let go of theese 2 keys. Now while holding down these keys, hit down arrow, do not hold down the down arrow, just press it. wait a second, then hit the backspace key. The backspace key is normally
above the enter key.
Each time you press the backspace key, it will jump to the next different value in the column.
I have tested this and it does work.
What I’m trying to do is say I have a column of information. That is thousand of lines long. I can sort it and when viewing the first item in the sorted column I want to jump the focus down to the next sorted value in the column. I have
no idea what it is or what where it will show up.
e.g. say it is a list of ip addresses from a server log. I am on the first ip, I don’t know how many times this ip shows up before it changes to the next ip address.
Hopefully that explains what I’m wanting to do.
Thanks
-------------------------------------------------------------
WARNING, this email originated from outside of SaskTel.
Do not click links or open attachments unless you trust the sender and believe the contents are safe.
--------------------------------------------------------------
If you remember what that sell value was, after you sort it, could you then do a find with control F and type in that value? Or copy that sells value to your clipboard and then do your control F and paste the
amount in the find field.
Hi folks:
I would like to know if there is a key board command when one is in excel to due the following
- You have a column of information that is thousand of lines in length. This column is sorted.
- Is there a key command that one can issue that will jump the focus down the column to where the information that the focus was on before issuing the command changes.
Thanks have a good and safe day everyone
Shan Noyes
Technical Analyst – Systems Security
GIAC
W: 306 777-4830
C: 306 533-1440
NOTICE: This confidential e-mail message is only for the intended recipients. If you are not the intended recipient, be advised that disclosing, copying, distributing, or any other use of this message, is strictly prohibited. In such case,
please destroy this message and notify the sender.
NOTICE: This confidential e-mail message is only for the intended recipients. If you are not the intended recipient, be advised that disclosing, copying, distributing, or any other use of this message, is strictly prohibited. In such case,
please destroy this message and notify the sender.
This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the
intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether
electronic or hard copy.
This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of
any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its
use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.
The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are
offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.
127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to
DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.
NOTICE: This confidential e-mail message is only for the intended recipients. If you are not the intended recipient, be advised that disclosing, copying, distributing, or any other use of this message, is strictly prohibited. In such case,
please destroy this message and notify the sender.
|