**3**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**3**answers

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

**4**answers

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

**1**answer

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

**0**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**6**answers

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

**3**answers

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

**8**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**10**answers

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

**1**answer

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

**0**answers

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

**7**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**10**answers

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

**1**answer

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

**4**answers

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

**1**answer

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?