Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

3
votes
2answers
4k views

Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values The calculated values never change directly, but only as a result of ...
4
votes
1answer
29k views

Inserting a (jpg) picture into a cell in Microsoft Excel 2007

Is it possible to insert a jpg image inside a cell, or do Excel cells only display alphanumeric characters (or references)?
0
votes
1answer
3k views

Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...
1
vote
3answers
2k views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
0
votes
0answers
4 views

Tex-style keyboard shortcuts for inserting symbols to MS Excel and Word documents

I've used Latex before in Linux and I loved it. My favourite thing about it was the reliance on the keyboard. For example, if I wanted to insert a 'sigma' symbol, I would simply type '\sigma' and when ...
0
votes
2answers
564 views

Can Excel sorts be saved and used again?

On an Excel 2007 worksheet, I have several tables, each sharing the same columns. For every table, I sort in several particular ways, depending on the task at hand. It gets tedious going to the Data ...
1
vote
2answers
12 views

Run-time error '1004';

I was trying to copy the formula from N39 up to the last row but I'm always getting a Run-time error '1004' refer to this line: n.formula = ...
0
votes
1answer
32 views

How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet: Roll-No:- 801 Maximum Marks 20 20 20 20 20 20 Sig. of Class ...
1
vote
0answers
13 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
1
vote
3answers
301 views

Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007). It doesn't format the year, it just states yyyy instead of e.g. 2014. If I have a cell with 23-7-2014 and use the formula ...
8
votes
4answers
22k views

How to stop Excel from Auto-formatting and making it work like a number crunching program

I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do. Imagine I have a colum ...
1
vote
1answer
8k views

Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...
0
votes
0answers
20 views

Excel formulae to select cell and cell header

I have a spreadsheet of student data. I want to be able to look up a student and return the grades for the students with the subject header. Students do not take all the subjects. Name Maths ...
5
votes
4answers
24k views

How do I merge two tables in Excel that have identical columns?

In Excel, I have a spreadsheet that pulls data from a SQL Database into a table and then generates a report based on that data. Unfortunately, the data in this SQL database is incomplete and I want to ...
1
vote
1answer
24 views

In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...
1
vote
1answer
3k views

probable cause of excel files getting corrupted

how to find out the probable cause of corruption of excel files...here i m not saying of a single file...files are getting corrupted one after the other...can 1)using windows 8 with excel 2007 and ...
0
votes
1answer
11k views

Select Multiple Items from Excel Data Validation List

How can I set up the ability to chose more than one option for a data validation list and list them in one cell? So I have a validation list of A B C D. I want to chose A C D and have those three ...
1
vote
1answer
33 views

'IF" Formula in Excel with additional conditions

I am working on a template which calculates the cost/price of a cabinet and I'm stuck at a certain point. There are 3 types of cabinets and there is a condition where a particular cost is applied to ...
1
vote
2answers
21 views

How do I Calculate Variance with Missing Values coded as -99?

I am trying to calculate individuals' variances on multiple measures, however, if they skip a question it is coded as -99. I would like my formula to calculate the variance for these measures while ...
0
votes
0answers
22 views

Error when running a VBA in Excel

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process. Here is the VBA ...
1
vote
6answers
18k views

Why does Excel now give me already existing name range warning on Copy Sheet?

I've been working on a Microsoft Excel 2007 spreadsheet for several days. I'm working from a master template like sheet and copying it to a new sheet repeatedly. Up until today, this was happening ...
0
votes
3answers
518 views

Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...
21
votes
8answers
86k views

Excel: Find Items in one column that are not in another column

I have two columns in excel, and I want to find (preferably highlight) the items that are in column B, but not in column A. What's the quickest way to do this?
0
votes
1answer
24 views

Formula for COUNTIFS excluding another column

I'm trying but failing to work out a formula in Excel 2007. I have an large area of data that isn't in a table format. The main columns I care about are: chapter title (text), number of tasks ...
6
votes
2answers
21k views

Fit column width to text shortcut?

I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?
6
votes
4answers
52k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
0
votes
1answer
626 views

Excel: URL with normal Text in a Cell

How can you add an HTML URL to a cell with normal text? I have a cell with normal text, but want to add a URL, but I don't want the whole cell to be the URL. i.e. Please go to this link: ...
0
votes
1answer
5k views

Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...
1
vote
2answers
6k views

Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...
0
votes
0answers
59 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
0
votes
1answer
2k views

Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options. There are five separate ranges so this is the first selection then within each range there are additional ...
0
votes
1answer
3k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
5
votes
2answers
4k views

Importing multiline cells from csv file into excel

I have a csv file (comma delimited and quoted). When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8). ...
3
votes
1answer
1k views

copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer. I'm fresh to vba, but I thought I can handle it. I was wrong. I ...
0
votes
1answer
3k views

How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise. I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...
1
vote
2answers
64 views

Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...
4
votes
10answers
45k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
1answer
19 views

How to trigger a letter in a cell when something is put in another cell

Example: when I enter 24 in A1, I would like the letter "x" to appear in B1. I hope this makes sense. I don't know a lot about macros or would a simple formula work?
-1
votes
0answers
9 views

Excel file unlocking in another PC (2010 to 2007)

I have locked an excel file in 2010 version, I am unable to open same file in excel 2007 version. File unlock option not coming to enter password. Pls help me open the file
12
votes
7answers
36k views

Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...
0
votes
2answers
29 views

In Excel, how do I get a list of cells to display based on an if function?

I have a list of quantities with a description column. It's counting doors based on size. I'd like to output a list (preferably separated by commas) of the description numbers with applicable numbers. ...
4
votes
1answer
34 views

Formula bar view changes when document is saved and reopened

I have an Excel 2007 document with a lot of formulas of the format: SUMIFS(view1[COLUMN1],view1[COLUMN2],$C13,view1[COLUMN3],I$10) but when I save the sheet and reopen it each formula is changed to ...
1
vote
1answer
52 views

Drag a formula, so that it increases by 17 each time

I have the following formulas on the third sheet of my workbook. They are simply cell references to the first sheet; on my 'output' page, I want to display every 17th cell of the 'input' sheet. ...
0
votes
1answer
39 views

How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...
2
votes
2answers
4k views

How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it. Every so often, in order to get the latest ...
0
votes
1answer
19 views

excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated. I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...
16
votes
10answers
72k views

Excel Auto-Fill Without Mouse (Keyboard Only)

So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then ...
2
votes
1answer
54 views

Restrict paste into dropdown cells in excel

I have one excel sheet which contains many dropdown columns. Lets say one column has Test1, Test2, and Test3 as dropdown option values. Cells under this column should not accept the values other than ...
2
votes
4answers
4k views

How do increase row height in excel by X. ie. Add verticle cell padding

I have this report and I want to increase the vertical cell padding to make it easier to read. Now, typically you could just select multiple rows and change the row height until you're satisfied. ...
-1
votes
1answer
68 views

Change values on x and y axis on a graph

I want to change the values on a graph, but I don't have the initial data, means I have just the graph. Any idea?