ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extra Columns (https://www.excelbanter.com/excel-discussion-misc-queries/27272-extra-columns.html)

Peco Worker

Extra Columns
 
One of our users have an a/b column to the left of the columns(a-..) and rows
(1-..)
Is there a way to turn this off. It is like a toggle columns. If you click
on a it will hide any rows that you have inserted and if you click b it shows
the rows that you added.

Not even sure what these extra a/b columns are called and I can't find
anything in the help?

Please Help!


Hi

It sounds like either Data|Subtotals have been used, or
Data|Grouping/Outline

--
Andy.


"Peco Worker" wrote in message
...
One of our users have an a/b column to the left of the columns(a-..) and
rows
(1-..)
Is there a way to turn this off. It is like a toggle columns. If you
click
on a it will hide any rows that you have inserted and if you click b it
shows
the rows that you added.

Not even sure what these extra a/b columns are called and I can't find
anything in the help?

Please Help!




Peco Worker

Thank You! That is it!


"Andy B" wrote:

Hi

It sounds like either Data|Subtotals have been used, or
Data|Grouping/Outline

--
Andy.


"Peco Worker" wrote in message
...
One of our users have an a/b column to the left of the columns(a-..) and
rows
(1-..)
Is there a way to turn this off. It is like a toggle columns. If you
click
on a it will hide any rows that you have inserted and if you click b it
shows
the rows that you added.

Not even sure what these extra a/b columns are called and I can't find
anything in the help?

Please Help!






Glad to help and thanks for the feedback!

--
Andy.


"Peco Worker" wrote in message
...
Thank You! That is it!


"Andy B" wrote:

Hi

It sounds like either Data|Subtotals have been used, or
Data|Grouping/Outline

--
Andy.


"Peco Worker" wrote in message
...
One of our users have an a/b column to the left of the columns(a-..)
and
rows
(1-..)
Is there a way to turn this off. It is like a toggle columns. If you
click
on a it will hide any rows that you have inserted and if you click b it
shows
the rows that you added.

Not even sure what these extra a/b columns are called and I can't find
anything in the help?

Please Help!








All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com