Q&A for How to Learn Spreadsheet Basics with OpenOffice Calc

Return to Full Article

Coming soon

Add New Question

Question

How do I add sheets to my spreadsheet document?

Community Answer

Right click at the existing sheet and then select "Insert Sheet." Choose before or after the current sheet, name the sheet, and then click "OK."

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 2
Question

When I go to print the spreadsheet, the lines are not on the page. What do I need to do to add the lines on the page?

Community Answer

After you've hit "Print," go to "Page Setup," click the "Sheet" tab, then click the "Gridlines" checkbox under "Print."

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 3
Question

How can I edit text in a spreadsheet cell?

Community Answer

Either double click on the cell you want to edit text in and start typing, or single click on the cell and type in the formula bar above the column letters.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 1
Question

How do I print the lines on a spreadsheet?

Community Answer

In Windows 10, after you click Print, click Page Setup, then the Sheet tab, then the Gridlines checkbox under where it says Print.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 1
Question

I want to enter a number in one cell (0-5), and have another cell produce a number to make the total 5. How do I do this?

Community Answer

If your first number is in A1, and your second number is going to be in A2, then in A2 type: =5-A1.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 0
Question

How do I move text up after something is erased from a cell?

Community Answer

You can either select all the information you want moved up, cut it, then paste. If there is no other data in that row, you can right click on that row number and select delete row.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 0
Question

When I print my sheet, how do I make the lines and columns appear?

Community Answer

Go to File Select Page Preview Right-click on page Put a check next to Grid Click OK

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 0