That also removes the x and y axis lines. Is there a way to keep those?
1 of 1 people found this helpful
My apologies, read through the post too quickly. Currently, it can't be done using the format menu on the worksheet (this might be a good one to add to the Ideas section). However, as a bit of a workaround, two annotations could be added to the view. Right click on the view and select Annotate-->Area. Type in one space and click OK. Then, resize and move the annotation so that it looks like a x and y axis line. Not ideal, but should work nonetheless!
I will definitely add to the ideas section and thanks for the workaround – I’ll give it a try.
I just learned this the other day, it turns out you can show just the X + Y axis lines. Turn off the borders like Tracy described, and then go to Format->Lines and turn on Axis Rulers:
If you want just an axis line for for the Y axis, then you can go to the Rows tab and set it there, or Columns tab for the X axis.