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

Return to Full Article

Search
Add New Question
  • Question
    How do I add sheets to my spreadsheet document?
    Community Answer
    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."
  • 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
    Community Answer
    After you've hit "Print," go to "Page Setup," click the "Sheet" tab, then click the "Gridlines" checkbox under "Print."
  • Question
    How can I edit text in a spreadsheet cell?
    Community Answer
    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.
  • Question
    How do I print the lines on a spreadsheet?
    Community Answer
    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.
  • 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
    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.
  • Question
    How do I move text up after something is erased from a cell?
    Community Answer
    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.
  • Question
    When I print my sheet, how do I make the lines and columns appear?
    Community Answer
    Community Answer
    Go to File Select Page Preview Right-click on page Put a check next to Grid Click OK
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

Return to Full Article

You Might Also Like

Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Edit Data in Microsoft Excel3 Simple Ways to Edit Data in MS Excel
Use Google Spreadsheets Use Google Sheets: The Ultimate Guide for Getting Started
Create a Simple Checkbook Register With Microsoft ExcelCreate a Simple Checkbook Register With Microsoft Excel
Type Formulas in Microsoft ExcelType Formulas in Microsoft Excel
Subtract in ExcelSubtract in Excel
Use OpenOffice WriterUse OpenOffice Writer
Edit Google Sheets on MobileEdit Google Sheets on Mobile
Use LibreOfficeA Complete Beginner's Guide to Use LibreOffice
Format a Cell in Microsoft ExcelEasy Steps to Change the Format of a Cell in Microsoft Excel
Create a Budget SpreadsheetCreate a Budget Spreadsheet
Add in Excel Add Numbers & Cells in Excel: Complete Guide
Add Up Columns in Excel Add Up Columns in Microsoft Excel: Quickly Sum Numbers