Question about Microsoft Excel for PC

1 Answer

Excel 2007 spreadsheets

On my excel 2007 spreadsheets iam getting numbers for my columns headings instead of letters which is very confusing when using formulas why is this happening ?

Posted by on

  • 1 more comment 
  • Anonymous Jan 10, 2008

    same as above

  • TARA CHAND Joshi Jan 19, 2008

    what is DATA BASE

  • aiustudent Feb 25, 2008

    I would like to do some research on Excel formulas that use more than one spreadsheet, I am doing this for my class assignment. Can you help me?

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 17 Answers

The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

Posted on Jan 10, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Excel Spreadsheet question


cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    Describe the each part of microsoft excel 2207


    anmolsxn_0.gif
    Parts of the Excel 2007 Screen

    Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
    Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
    Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
    Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
    Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
    Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
    Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
    Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
    Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
    Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

    Nov 15, 2010 | Microsoft Windows XP Professional

    2 Answers

    What is the function of Microsoft excel?


    Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

    If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

    Hope that helps!

    Rgds

    David

    Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

    1 Answer

    Excel 2007 question


    Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".

    May 14, 2009 | Microsoft Office Excel 2007

    2 Answers

    In Excel hitting tab jumps to next page


    I solved my problem. go Tools -> options -> transition -> transition navigation keys. if this box is checked, clear it.

    Apr 20, 2009 | Microsoft Office Professional 2007 Full...

    1 Answer

    BASIC EXCEL FORMULA


    Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

    However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

    Suppose you have the following numbers typed into your Excel spreadsheet:

    columns: A B C D
    rows
    1 20 3
    2 10 4
    3 15 2
    4 1 2 3


    Then suppose you type in the following formulas (in the D column):

    columns: A B C D
    rows
    1 20 3 =A1+B1
    2 10 4 =A2-B2
    3 15 2 =A3*B2
    4 1 2 3 =sum(A4:C4)


    Then the following answers will appear in the D column:

    columns: A B C D
    rows
    1 20 3 23
    2 10 4 6
    3 15 2 30
    4 1 2 3 6

    Sep 29, 2008 | Microsoft Computers & Internet

    1 Answer

    Percentages in Excel


    No problem, Melinda, I am here to help!

    If I understood correctly, your spreadsheet looks something like this:
    A B C D
    1 Question Yes No Total
    2 Is sky blue? 20 2 22
    3 Is world round? etc.

    In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
    1) click on the cell where you have the division formula
    2) clck on Format in the top menu bar
    3) click on Cells
    4) click on the Number tab (if you're not already there)
    5) click on Percentage in the list of categories
    6) click OK

    To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

    I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

    Good Luck!
    Regards,
    RichMTech

    Aug 08, 2008 | Microsoft Excel for PC

    1 Answer

    Excel Formula


    Do you simply need to have the formula: = I2 - F2

    Is there a condition that you want to return zero?

    Jan 19, 2008 | Computers & Internet

    2 Answers

    Duplicacy in excel sheet


    Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
    Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

    Drag this formula down column F till the end of your data
    Select the entire data and do an auto filter
    In column F filter the data by Duplicate and delete all these rows
    What remains should be unique data

    Dec 19, 2007 | Computers & Internet

    Not finding what you are looking for?

    Open Questions:

    See all Microsoft Excel for PC Questions

    Microsoft Excel for PC Logo

    Related Topics:

    109 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2994 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18424 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...