Q&A for How to Make a Spreadsheet in Excel

When you click "Save As," at the bottom of the page there should be a file name box. Whatever you type into that box will be your spreadsheet's name.

You cannot change those labels. Typically, the name of the column is simply written in the first row.

As you're typing, select the cell where you want the text to be and select "Wrap Text" at the top of the page. This will contain all of the text to the same cell, which will grow as you type.

Anyone who owns Excel or a similar application/website should be able to do this. It may take a little practice to get to know all of the operations and symbols but you can do it with a half day's practice, or even less.

Click on the page layout tab on the task bar. Click on "orientation", click on "landscape".

Highlight what you would like outlined, then click on the boarders button in the home tab and select a border.

The easiest way to get more space to type is to merge a few cells.

Type the title in the top of the first cell. Select the number of columns to center it across and choose "Center Across Columns". If you get stuck, search the MS help for "Center Across Columns" feature.

Select the names you want to alphabetize by highlighting them. Go to the editing section on the task bar, click on "A to Z" sorting button. Click on A-Z. The selected name will sort by the first name, unless you entered the last name first.

Go to the "insert" tab, and click on "symbols." Choose the degree symbol from a font such as Bodini MT or Century.

First, select the cells that you want to merge with your mouse. Then, go to the alignment section and select the merge option you want to use.

If you're referring to turning on the row number indicators, in the Ribbon Menu, click on View and check the box next to "Headings", in the "Show" section. If you're talking about having a cell display the row number it is in, try the formula, =ROW(). This formula can be combined with operators + and - to add and subtract numbers or other formulas such as =COUNT() and =COUNTA(), depending on what you need.

In the 'format this cell' function under the right click menu, there is an option to change the way numbers present themselves.

I assume that the cell contents shown in the formula bar look like =1+2, and the cell will show the result 3. You can double-click the cell and add a number (e.g. +3) after the 2; the formula bar will then show =1+2+3, and the result shown in the cell will be 6. Another method: if you want to add up a range of numbers that you can change easily, put the numbers in a named range; e.g. MyNumbers =Sheet1!$A$1:$A$5. In the cell, where you want to add up the numbers, enter the formula: =sum(mynumbers). Now you can type any numbers in cells A1 to A5 to add them up.

No. After you finish entering data, you may highlight the row/column, double click at divider line. Then it will auto resize.

Do you want rows 22 and 35 to each be totaled? Or do you want them added together? If the first, click the box where you would like row 22's total to be, type =SUM(range), indicating the range of boxes in row 22 for "range", then hit enter. Do the same for row 35. To add them together, do the previous step, then click the box where you want to put the total, then put the equal sign, then click row 22's total box, then put the plus sign, then click row 35's total box, then hit enter.

Enter 1, 2, 3, then select those number then columns number 3 right side pointer then click right right side, then scroll it.

You click on the home tab, highlight the text you want to color, click the font icon and choose the color you want.

Hold the selected area and extend it to the region you want to include in the formula in either direction.

Select the item you want to delete and press delete button. You can do this either in the given cell or in the fx bar on the upper region of MS Excel.

When printing, you can choose the option to "Fit all columns in one page" so nothing gets printed on the back.

Click the cell(s) whose color you want to change, and then look for the paint can icon in the Font group of the ribbon. Clicking that icon will give you a dropdown of color options for your selected cell(s).

At the edge of each column, you can double-click to auto size it to fit your text.

Consider the way you want the page to be configured, and continue by using the menus at the top of the page.

New cells should appear as you continue to move across (AA appearing after z).

Format the cell. Click the first cell. Write the figure you want, then drag it down to the last cell.

You can use the Find shortcut. Hold down Ctrl+F and a box should appear; type in the item you're looking for.