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)

-6
votes
0answers
33 views

Select higher / lower value by formula [on hold]

Which formula can I use to find out a value which is lower or higher, as per below example? APPLE MANGO ORANGE DESCRIPTION QTY UNIT PRICE AMOUNT UNIT PRICE AMOUNT ...
1
vote
1answer
12k 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 ...
2
votes
1answer
18 views

Excel - split view of sheet horizontally but viewing two separated sets of columns instead of rows

I have a sheet in excel 2007 which is quite long horizontally. I'd like to see the 'first' columns of the sheet at the same time as the 'last' columns. If I split the sheet horizontally (with a top ...
0
votes
1answer
4k 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
7answers
24k views

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column ...
0
votes
1answer
28 views

Autofill formula to return data from every tenth row

In Excel 2007, how do I autofill a function of =OFFSET(C2,10,0) to end up as: =OFFSET(C2,10,0) =OFFSET(C12,10,0) =OFFSET(C22,10,0) etc. as a pattern of referencing every 10th cell in the same row. ...
1
vote
2answers
2k views

Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values. I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
1
vote
1answer
4k views

How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once? I have been using what I ...
0
votes
2answers
2k views

Hyperlink to doc file slow opening

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm. While opening ...
3
votes
3answers
8k views

Convert Text Value to Time Value in excel

I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...
0
votes
2answers
118 views

Concatenate a range with values in between

I work with ranged data and want to populate a cell that includes values at set increments between the min and maximum. For example, the minimum outer diameter is 1 1/16" and the maximum outer ...
0
votes
5answers
1k views

When opening any file in excel, a 1 is added to ther name, and the default is to save a new copy…

Ok... I've searched a lot for this, but it's not an easy question to search for! When I open any files (xls, or xlsx) in Excel 2007, excel acts like it's a read only file, essentially creating a new ...
0
votes
2answers
635 views

Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...
1
vote
3answers
12k views

How can I stop Excel (2007) from copying hidden cells?

Let's say I have some rows or columns that are hidden, and drag a selection across where those hidden values would normally be. Is there a way to prevent Microsoft Excel from copying those hidden ...
0
votes
0answers
23 views

Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules: =$B97=1 Set Format (Custom) ">" @ On cell =$D97 =$B97=2 Set Format (Custom) "> >" @ On cell =$D97 =$B97=3 ...
10
votes
1answer
13k views

How can you make Excel 2007 stop formatting large numbers as scientific notation?

Kind of the inverse of this question. I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...
0
votes
1answer
8k views

Reference entire excel 2007 sheet to another sheet

I have one sheet with 100 rows of data. I have a second sheet that will use the same data but with filters applied. In fact, I will have a dozen sheets, each with different filters. My goal is to ...
0
votes
1answer
1k views

When importing data from web page using Excel, hyperlinks are lost. How to solve this?

When using the Data menu item in Excel to import data from web to spreadsheet, the hyperlinked items lose the link and appear just as text (for example try this: Test - How to overcome this? Note: I ...
0
votes
1answer
3k 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
0answers
25 views

Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...
0
votes
1answer
12 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
0
votes
1answer
37 views

Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items. The items in a group share the ...
0
votes
2answers
615 views

Insert Sheet Columns is greyed out in excel 2007

I want to insert a column in excel 2007, yet the insert column is greyed out the sheet it not protected, and there is not restrictions whatsoever another sheet on the same file work correctly. how ...
0
votes
1answer
65 views

Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:
0
votes
1answer
4k 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 ...
4
votes
12answers
20k views

Mouse wheel does not work in Excel 2007

I am running Office 2007 on Windows XP-SP3. My mouse wheel works fine in other applications, meaning that it scrolls information up and down when the mouse is positioned over a given panel. It's even ...
0
votes
2answers
3k views

In Excel I need to find data matches between two arrays - one horizontal and one vertical

In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...
0
votes
2answers
3k views

d/m/yyyy to dd/mm/yyyy

I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy. I want to standardize all the data of such column into dd/mm/yyyy , I format the ...
0
votes
0answers
44 views

MS Office 2007 Windows 10

I have used excel to set up a rota for home hosting a regular Bridge night, mostly there are 9 members but occasionally 10. The spreadsheet is setup with the 9 names rotating downwards in column A, ...
0
votes
1answer
36 views

Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this: List A: aaa bbb ccc Range B: 1 aaa --- --- ...
20
votes
6answers
9k views

How can I use custom colours in the Microsoft VBA editor?

I'm working on a few projects for work using Excel and VBA, so I have no choice but to use the Microsoft Visual Basic editor. I normally wouldn't mind, but I can't figure out how to set a custom ...
0
votes
2answers
88 views

Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if Main_Spreadsheet.xlsx Secret_Data.xlsx When someone opens Main_Spreadsheet.xlsx and they ...
0
votes
0answers
11 views

Excel 2007 Microsoft Action Pane 3

How do I install Microsoft Action Pane 3 on Microsoft Excel 2007? When I go to XML plugins, there is none on the list... I can add some manifest xml file, but where do I download it?
0
votes
1answer
20 views

Dynamically change cell reference of a formula in another cell where there is a reference to original formula w/o copy pasting the formula

I have a formula in cell A1 as =A2+A3, now i need the same formula in cell B1 as well however i dont want to copy paste the formula, i just want to give reference of A1 in B1 and B1 should calculate ...
0
votes
4answers
386 views

Multiple conditions in if statement on non-contiguous cells in Excel

I would like to perform an if statement with conditions on the values of multiple non-contiguous cells, something like ...
2
votes
2answers
16k views

Stop “Excel formula or sheet contains the name” dialog

When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog: where Author is a specific field somewhere in the sheet I'm ...
2
votes
2answers
5k 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 ...
1
vote
1answer
31 views

Excel: Checksum-like function to check if table copied correctly

I have the following scenario: I have a spreadsheet A with a large table. I open spreadsheet B and copy the table from A into it. I want to check if I copied the table from A to B correctly. In ...
-1
votes
1answer
75 views

Finding a value base on an “ID”

How can I assign a "CityID" in "Customer Table" using customer's Address and a given "ProvinceID"? (Province Table) ID . ProvinceName 1 . . Ontario 2 . . Quebec 3 . . Nova Scotia 4 . . Quebec (City ...
-1
votes
1answer
84 views

Correct way to write or even better combine these two Excel 2007 formulas

I have two formulas. As an example for this question let's assume I have a workbook that is basically a CD Database. It contains all the usual information that you would expect. This workbook is ...
0
votes
0answers
26 views

Macro, Formula or Code? Copy data to new sheet based on specific criteria?

I have tried pulling this together with various formulas but A. A lot of the didnt work and B. it was very messy. For the example of this question lets use a Music CD with 2 Disc. The information is ...
1
vote
2answers
38 views

How to convert cells of a column to text in Excel 2007

I have a column consisting of cells (from 1 hundred to over 100 thousands) with values like : 5 12 78.456 1235.78510 AFT780.963 ZFLQ 57180.004 ... I want a way to rapidly change the format of the ...
0
votes
0answers
22 views

Excel 2007. 2nd Formula wont accept result of 1st formula on a different work sheet

I have a rather frustrating problem that it seems others have had also but I have yet to find a solution that works. I have simplified things below as I tend to give too much information. Basicly I ...
9
votes
2answers
26k views

Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font). How can you configure Excel to use the same ...
3
votes
1answer
2k views

How to draw a 'sane' scatter plot in Excel?

I've been at it for over 2 hours now and am just a bit flustered :) I have the following data (for example): Label | Criterion 1 | Criterion 2 | A1 | 7 | 3 | A2 | 1 ...
0
votes
0answers
28 views

How to transpose a named range in Excel 2013, using cell formulas (not VBA)

Similar to this question, I want to display the values of a named range (horizontal) in a vertical range. If I have data a b d f which is named Letters (as a named range). I want to display this ...
0
votes
2answers
2k views

Lookup Multiple Results for Multiple Criteria

I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
3
votes
2answers
67k views

Plotting multiple series in a line graph in excel with different time values?

I have the following data: Time v 0 5.4 5 4.5 10 5.3 15 6 20 5.1 25 7.4 30 6.7 40 6.1 50 6.9 60 5.9 70 6.1 80 6.2 Time v 0 4.7 5 4.8 10 5.5 15 6.1 20 6.8 25 7.5 30 7.9 ...
1
vote
1answer
62 views

Change excel formula references when dragging across columns

I have a row that I want to populate with formulas like =SUMPRODUCT(B93:B96,B46:B49)/SUM(B46:B49) =SUMPRODUCT(C92:C95,C45:C48)/SUM(C45:C48) =SUMPRODUCT(D91:D94,D44:D47)/SUM(D44:D47) but dragging ...
0
votes
0answers
17 views

altering values in cells

I use a spreadsheet which has been pre "set". I add values and it auto does the calculations. For some reason my current spreadsheet will allow me to go to the cell I want to edit BUT as soon as I ...