1 of 1 people found this helpful
Hi Ram, unfortunately you can't get rid of it completely, but you can minimize it. First go to the little triangle next to 'color' and set the transparency to 0% (I always wondered about this scale labeling; isn't something that's 100% transparent completely see-through? I think they probably should have labelled it 'Opacity', then the way the slider currently works would have made sense.) OK, enough Sunday morning fun. After you get rid of ABC, you'll want to color all the borders white so they disappear. (Don't use 'none' because none doesn't really mean none, it means light grey or blue.) So now your sheet should look something like this:
Don't worry about the 'Drop', it disappears when you put the sheet on a dashboard:
Hope this helps.
Thank you very much for quick response. I am able to set the transparency to 0%, abc
values disappeared. I tried setting the borders to white, but still they are
visible. I clicked on menu item Format and Borders(please refer to screen shot below), and set
Cell, pane and Header fields under rows and columns tab to white. Am I missing
Ram, the easiest thing to do is go to the 'sheet' tab and set everything to white. Then experiment with adding back in the row borders it looks like you're wanting to keep. Also mess with level slider to get the lines the way you want. It's a lot of trial and error, and sometimes you have to live with little quirks like this:
Notice the little gap between the header and the blank column. You can make the column width narrower, but then it looks like a period and the end of the line. Good luck.