Q&A for How to Use Excel

Return to Full Article

Search
Add New Question
  • Question
    How do you add a check mark or an X mark to a cell?
    Community Answer
    You can go into Insert, then Symbol, and choose the symbol you want. After that, you can just copy and paste the symbol from one cell to another.
  • Question
    Can I add work sheets on Excel?
    Community Answer
    Yes. At the bottom left of the Excel you will see the list of sheets. To the left of those sheets you will find a "+" sign. Click on it.
  • Question
    How do I move cell contents to another cell?
    Community Answer
    Highlight the cell, right-click, and click Copy. Click destination cell, right-click and Paste.
  • Question
    How do I make cells large enough to fit the data I put into a cell?
    Community Answer
    Click the cell, then drag the column of the cell, from the top to the desired size
  • Question
    How can I sort columns alphabetically?
    Community Answer
    Highlight the column that you would like to sort. Then, go to "Sort and Filter" on the Home tab and click the option to sort from A-Z.
  • Question
    How do I carry headings from one sheet to the next?
    Community Answer
    Highlight the row with the headings and copy. Open a new sheet. Highlight the first cell (A1) in the new sheet, and paste.
  • Question
    How do I download Excel?
    Community Answer
    Excel comes with the OS (operating system) you already have, if it is Microsoft. If you use Microsoft, it should be on your computer, just search for it in the Start Menu. If you are using a Mac, you will not find "Microsoft Excel", but a program similar to it.
  • Question
    How do I print titles on columns?
    Community Answer
    Click on the cell where you want the title to highlight it, and type in your title.
  • Question
    The arrows do not work. How do I turn this function on?
    Community Answer
    Click in the cell you are wanting to move. You will see a dark boarder around the cell. Hold you pointer over one of the sides and the arrows will appear.
  • Question
    How do I delete unwanted cells in Excel?
    Community Answer
    Highlight the cells you don't want and go to the Home tab and click on Delete Cells.
  • Question
    How do I create a multiplication or percentage function?
    Community Answer
    Go to the accounting box and click on the function, then highlight the columns you want changed.
  • Question
    How do I extend a column in Excel?
    Community Answer
    Click on the right side of the column, and once the arrow appears, then stretch the lines to the right to extend the size of the column.
  • Question
    How do I print only certain columns instead of the whole spread sheet?
    Community Answer
    Highlight just the area you want to print. When you go to the print menu where it defaults to "Print Active Sheets", change it to "Print Selection".
  • Question
    How do I make my columns the width I want them?
    Community Answer
    You can select the lines on the sides of the column and drag them left or right to increase or decrease your column width.
  • Question
    How do I insert a line?
    Community Answer
    Right click the row you would like to insert above, and click "Insert" in the right-click menu.
  • Question
    How do I merge cells or sheets in Excel?
    Community Answer
    Click the "home" tab then find "merge cell", click the drop-down button and select "merge across".
  • Question
    How do I carry headings on the next sheet?
    Community Answer
    Highlight the headings within the sheet you're working in, right click, and do a copy of the headings. Click on the new sheet, insert the cursor within the row that the headings are to appear in, right click and paste.
  • Question
    How do I join cells in Excel?
    Community Answer
    Highlight the cells to be joined. Right click within the cells and click on format cells. Within the text control area click on the merge cell option, then click on OK.
  • Question
    How do I change columns and rows without affecting the ones above them?
    Community Answer
    Click on the original column and click the right button. Then choose Insert and the same highlight on the row will appear, then right click on row and B and Insert.
  • Question
    How do I change the background color of a cell?
    Community Answer
    Highlight the cell you want colored and then go to the highlighter button and select the colour you want. Choose it and the cell will fill with that color.
Ask a Question

      Return to Full Article