One of the auditors I work with pushed something, I don't know what, and this odd grey column is now on the left side of the report.I have been looking for something that looks out of the ordinary to make it go away but haven't found anything. I would greatly appreciate any help and have attached a screenshot. This one has me stumped and I don't know what to call it to Google the problem.
Thanks!
1) Select all cells
2) Click on Data > Ungroup > Clear Outline
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
What they did was they timelined the spread sheet. you can select the worksheet, click the data tab and click ungroup.
been better if you posted the excel sheet but thats grouping
go to data/group then ungroup
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks