Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know how to remove unused columns and rows from being displayed in an calc file? I want the display to just be solid grey or white with no grid or column/row names.

share|improve this question

You can hide unused rows or columns (right click the row, go to hide).

You can paint the background of the cells grey or white which makes the grid disappear.

You will still see the column/row names of the columns you have not hidden. Why do you not want these invisible?

It sounds to me like you should just be pasting calc data into writer and using it there since that is how you seem to want it to look.

share|improve this answer

If I understand your goal, you should look a box for "Show cell grid lines" and uncheck it. Next, go to the menu bar. Click "View" and uncheck "Column and Row Headers". This will change the view on the screen to what I think you are seeking. Unless you selected them as borders the grid lines shouldn't print anyway.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.