moderated non-visual way to utilize grouping rows and columns in Excel?


Van Lant, Robin
 

Hi all,

I have a monster spreadsheet that has numerous columns I have to skip over.  I used to just hide them, but this is confusing to others who  also use the file.  They ask that I group the columns so I can hide and unhide them.  I’m trying to figure out if I can do this.  I know I can create the grouping by keyboard, but I’m trying to figure out how to know if some columns are already part of a group and how to hide/unhide them by keyboard versus pointing at the icon in the header, which is how sighted people do it.   Anyone know? 

Using Office 365 and JAWS 2022.

 

Robin

 

 

Robin Van Lant, Sr. Program Manager

Key Equipment Finance & Key Institutional Bank

720-304-1060

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

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.


 

Robin,

 

I don’t have an answer for you but you might consider subscribing to the office-accessibility@groups.io list. You can do so by sending a blank email to:

 

office-accessibility+subscribe@groups.io

 

That list has many smart Microsoft Office users who are great at offering help. I believe in full disclosure so I will admit that I’m the owner of that list as of the past couple of months because David Goldfield who created  it had time constraints. Brian Vogel does an excellent job moderating it and offering many helpful answers.

 

Alan Lemly

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Thursday, October 6, 2022 10:19 AM
To: JFW List (jfw@groups.io) <jfw@groups.io>
Subject: non-visual way to utilize grouping rows and columns in Excel?

 

Hi all,

I have a monster spreadsheet that has numerous columns I have to skip over.  I used to just hide them, but this is confusing to others who  also use the file.  They ask that I group the columns so I can hide and unhide them.  I’m trying to figure out if I can do this.  I know I can create the grouping by keyboard, but I’m trying to figure out how to know if some columns are already part of a group and how to hide/unhide them by keyboard versus pointing at the icon in the header, which is how sighted people do it.   Anyone know? 

Using Office 365 and JAWS 2022.

 

Robin

 

 

 

Robin Van Lant, Sr. Program Manager

Key Equipment Finance & Key Institutional Bank

720-304-1060

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

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.


Van Lant, Robin
 

Ok, I’ve figured out that options appear on the ribbon to hide and  unhide what you have grouped. That will work for the file I’m working on now. I’m still not clear on how I would know what is or is not grouped if I get a file from someone else.     From the examples online, someone could have groups embedded in groups so you can hide smaller or larger sets of columns or rows at once. 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Thursday, October 6, 2022 9:19 AM
To: JFW List (jfw@groups.io) <jfw@groups.io>
Subject: non-visual way to utilize grouping rows and columns in Excel?

 

WARNING: This email originated externally. Exercise caution. Think before clicking links or opening attachments.

 

Hi all,

I have a monster spreadsheet that has numerous columns I have to skip over.  I used to just hide them, but this is confusing to others who  also use the file.  They ask that I group the columns so I can hide and unhide them.  I’m trying to figure out if I can do this.  I know I can create the grouping by keyboard, but I’m trying to figure out how to know if some columns are already part of a group and how to hide/unhide them by keyboard versus pointing at the icon in the header, which is how sighted people do it.   Anyone know? 

Using Office 365 and JAWS 2022.

 

Robin

 

 

 

Robin Van Lant, Sr. Program Manager

Key Equipment Finance & Key Institutional Bank

720-304-1060

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

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.


 

Grouping is not the major factor when it comes to whether a range of rows or columns is hidden or showing.  

If memory serves, and if the worksheet is not immense, you can tell this as you traverse a row, or down a column, when there is a jump from, say column C to column X, or row 23 to row 55 as you go across a row or down a column, respectively.

I'd rather take this to Office Accessibility if we want to dig deep, as I'd need some example to work with so see what's what and determine keystrokes.  I have very limited availability today, as we're supposed to have a hard freeze here either tomorrow night or Saturday night, and I need to get my orchid collection back into the house before that happens.
--

Brian Virginia, USA Windows 10, 64-Bit, Version 21H2, Build 19044  

Puritanism: The haunting fear that someone, somewhere, may be happy.

    ~ H.L. Mencken, AKA The Sage of Baltimore


Van Lant, Robin
 

Thanks, Alan.  I just sent my subscribe email.  Considering how much I used MS products here at work, I’m surprised I havent’ paid attention to the existence of this group before.

 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Alan Lemly
Sent: Thursday, October 6, 2022 9:45 AM
To: main@jfw.groups.io
Subject: Re: non-visual way to utilize grouping rows and columns in Excel?

 

WARNING: This email originated externally. Exercise caution. Think before clicking links or opening attachments.

 

Robin,

 

I don’t have an answer for you but you might consider subscribing to the office-accessibility@groups.io list. You can do so by sending a blank email to:

 

office-accessibility+subscribe@groups.io

 

That list has many smart Microsoft Office users who are great at offering help. I believe in full disclosure so I will admit that I’m the owner of that list as of the past couple of months because David Goldfield who created  it had time constraints. Brian Vogel does an excellent job moderating it and offering many helpful answers.

 

Alan Lemly

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via groups.io
Sent: Thursday, October 6, 2022 10:19 AM
To: JFW List (jfw@groups.io) <jfw@groups.io>
Subject: non-visual way to utilize grouping rows and columns in Excel?

 

Hi all,

I have a monster spreadsheet that has numerous columns I have to skip over.  I used to just hide them, but this is confusing to others who  also use the file.  They ask that I group the columns so I can hide and unhide them.  I’m trying to figure out if I can do this.  I know I can create the grouping by keyboard, but I’m trying to figure out how to know if some columns are already part of a group and how to hide/unhide them by keyboard versus pointing at the icon in the header, which is how sighted people do it.   Anyone know? 

Using Office 365 and JAWS 2022.

 

Robin

 

 

 

Robin Van Lant, Sr. Program Manager

Key Equipment Finance & Key Institutional Bank

720-304-1060

 



KeyCorp Public

KeyBanc Capital Markets Inc. prohibits the use of texts or other unapproved messaging applications for business purposes.

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.