Topics

moderated Hidden cells

CathyAnne Murtha
 

The easiest way to unhide rows and columns is in the format menu.

 

If you don’t know which rows and columns are hidden:

  • Select the data range (CTRL-SHIFT-NUMBER ROW 8)
  • Open the Home ribbon (ALT-H)
  • Open the Format menu (O)

 

Within the format menu

  • Activate “Unhide columns” to unhide all columns.
  • Activate “Unhide rows” to unhide all rows

 

CathyAnne

 

 

CathyAnne Murtha

Access Technology Institute, LLC

cathy@...

www.blind.training

(520) 955-6611

 

 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Wednesday, January 15, 2020 5:56 AM
To: main@jfw.groups.io
Subject: Hidden cells

 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

John Doering
 

Thanks.

 

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of R&J
Sent: Thursday, January 16, 2020 8:24 AM
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

Highlight the row above and below the hidden cells or highlight the column to the left and to the right of the hidden cells.  Then in the "HOME" menu, go down to "Cells", open this menu and click "FORMAT", then click unhide columns or unhide rows.

R&J
 

Highlight the row above and below the hidden cells or highlight the column to the left and to the right of the hidden cells.  Then in the "HOME" menu, go down to "Cells", open this menu and click "FORMAT", then click unhide columns or unhide rows.

John Doering
 

George:

Thanks, that did the trick.

 

Regards,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of george b
Sent: Wednesday, January 15, 2020 7:15 AM
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

Go to a cell on the left of the hidden collums and hold down control shift and arrow right to the cell on the right of the hidden collum / collums are between the cells selected

 

Nowdo alt h o  and arrow down to hide unhide cells and arrow righe once and down to what you wish to unhide and hit enter.

 

The same works for hidden cells.

 

hth

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 5:09
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

Have not highlighted anything.  Asking if there is something to highlight to activate the unhide button.  Can you highlight columns that are   hidden?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of george b
Sent: Wednesday, January 15, 2020 7:00 AM
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

John what did you highlite let me know and we will go from there

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 4:56
To: main@jfw.groups.io
Subject: Hidden cells

 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

george b
 

Go to a cell on the left of the hidden collums and hold down control shift and arrow right to the cell on the right of the hidden collum / collums are between the cells selected

 

Nowdo alt h o  and arrow down to hide unhide cells and arrow righe once and down to what you wish to unhide and hit enter.

 

The same works for hidden cells.

 

hth

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 5:09
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

Have not highlighted anything.  Asking if there is something to highlight to activate the unhide button.  Can you highlight columns that are   hidden?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of george b
Sent: Wednesday, January 15, 2020 7:00 AM
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

John what did you highlite let me know and we will go from there

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 4:56
To: main@jfw.groups.io
Subject: Hidden cells

 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

John Doering
 

Have not highlighted anything.  Asking if there is something to highlight to activate the unhide button.  Can you highlight columns that are   hidden?

 

Thanks,

 

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of george b
Sent: Wednesday, January 15, 2020 7:00 AM
To: main@jfw.groups.io
Subject: Re: Hidden cells

 

John what did you highlite let me know and we will go from there

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 4:56
To: main@jfw.groups.io
Subject: Hidden cells

 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

george b
 

John what did you highlite let me know and we will go from there

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: January 15, 2020 4:56
To: main@jfw.groups.io
Subject: Hidden cells

 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

John Doering
 

Hello:

I was sent a  spread sheet with hidden cells.  How can I unhide these columns?

I did find a unhide button under the view menu but it states unavailable and does not work.  Do I need to highlight something or something else to get  it to work?

Any help will be appreciated.

 

Thanks in advance,

 

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org

Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.