How to Increase Cell Padding in OpenOffice

Save

OpenOffice.org offers many formatting options to display your data in its Calc spreadsheet program. One nifty format is cell padding, which creates blank space around your data, so the figures do not butt up against the cell walls or potentially run together with data in adjacent cells. By default, cell padding is configured with 1 point of space around your text, but you can increase that padding to virtually any figure.

  • Highlight the cells you want to format. Do this by clicking a row number or column letter to select an entire row or column, or clicking-and-drahging your mouse over a selection of cells. Alternatively, hold the "Ctrl" key and press "A" to select all cells.

  • Right-click a selected cell and choose "Format Cells."

  • Click the "Border" tab in the Format Cell window.

  • Uncheck "Synchronize" if you wish to apply varying values for cell padding to each side of the cell.

  • Click the up arrows inside the field you wish to change. If "Synchronize" is checked, this will simultaneously change the values of all sides of the cell. Alternatively, highlight the number in the field, and type the value you want.

  • Click "OK" to accept your new cell padding configuration.

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!