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)

0
votes
1answer
35 views

Excel SUM function for whole column?

How can I sum the whole column without freeze head? I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...
-1
votes
1answer
27 views

how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...
0
votes
2answers
40 views

Superscripts in Excel chart labels

I have data like this: 2 | 5 4 | 6 8 | 7 I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...
0
votes
1answer
15 views

Excel 2007. Write changes back to extern file source

it's possible to import data into an excel sheet from an external (csv) file. Every time content of this external file will be changed, we'll see these changes in the excel sheet. But is it ...
0
votes
1answer
32 views

I don't want Ms excel to scroll down by cell units

When I scroll down (or up) in Ms Excel 2007, it scrolls down so that only whole cells (or at least it tries to do so) could be displayed next in that page. And it keeps jumping down one complete row ...
-1
votes
0answers
21 views

Why does Excel 2007 change 13 to 14 when typed in?

Every time my co-worker types 13 into an excel cell, excel changes it to 14. She was using excel 2003 and this was happening. Our tech installed 2007 and it is still happening. We have to use a ...
-4
votes
0answers
21 views

EXCEL HELP.Comparing 2 columns [duplicate]

Please Help me regarding this issue. I have 2 columns 1st column-676 rows 2nd column-1006 rows All the data in 1st column are there in column 2 I want the ones which are not there in column 1 and ...
-4
votes
0answers
22 views

Comparing two columns

I have 2 columns.First column has 676 rows and second column has 1006 rows.All the data in first column(676 rows) is there in second column.But I need to put the missing data which is not there in ...
1
vote
1answer
15 views

Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
1answer
25 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 ...
1
vote
2answers
55 views

Excel Lookup adds double quotes to string

I'm using this formula to get value form a table =LOOKUP(C11;Alias[A];Alias[B]) where C11 = 12354567 But when I use =LOOKUP(LEFT(C11,7);Alias[A];Alias[B]) where C11 = 12345678, the formula does ...
0
votes
1answer
33 views

Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank. But when I use this defined name in another cell, the second ...
0
votes
1answer
18 views

cell format excel number to text

I have a file with 4 columns and over 7000 rows. The columns are formatted as Number or Geral. But I'm using a plugging for php (SimpleXLSX) to read the xlsx file and create queries to insert into a ...
2
votes
1answer
35 views

Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple. Suppose the following example: There are two tables, one containing animals, and the other one ...
1
vote
2answers
34 views

MS Excel Column content replication across two sheets

Microsoft Excel functional Question How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...
0
votes
3answers
39 views

In Excel replacing a column with another column

I have a list of Variables in Column A > list of items another list of variables in Column B > with corresponding Item Codes for >> column A And in Column C > I have list of item codes randomly ...
0
votes
1answer
22 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
-2
votes
0answers
15 views

Protect and Lock Excel sheet dynamically

I want to dynamically protect my sales sheet, so when an entry is made and save the sales man go back to previous entry. My sales entry sheet consist of the following column heading date -invoice ...
1
vote
0answers
19 views

Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be: New view (not Classic view) Autofit column widths on update = on Subtotals = on (top of group) I end up ...
0
votes
1answer
35 views

excel - if value grater than, use that value

I am having problems with my excel function. I want to: if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell. ...
0
votes
2answers
26 views

How can I work out days, hours and minutes from a total number of minuts?

In Excel I have a number of minutes that I need to convert in to days, hours and minutes, but I cannot figure out how to get the minutes. Here is how the data must be presented - Total Minutes Days ...
2
votes
0answers
33 views

CTRL+SHIFT+DOWN not working in Excel 2007

CTRL+SHIFT+DOWN is not working in Excel 2007. I have unchecked Excel Options> Advanced> Tools>Options> Transition Navigation Keys. CTRL+SHIFT+UP arrow is working fine. If I connect to an external ...
0
votes
1answer
27 views

How to change the size of my 'glow' effect on excel, when I use custom color?

When I create a shape in Excel(2007) I apply some effects in it on Format > Shape Styles > Shape Effects, with one of them being "glow" with some predefined colors and sizes. What I'm trying to do ...
0
votes
1answer
37 views

New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document. Everything ...
1
vote
1answer
38 views

Sumif range of criteria

I've checked different questions and answers on the site, but couldn't find what I'm looking for. I try to have a sum of values, using multiple criteria (OR): When I use, e.g., ...
3
votes
1answer
65 views

Excel - Get rid of extra space in cell when using Text Wrap

When I type a long sentence (or more than one sentence) into more than one cell in a row, and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them. There ...
0
votes
1answer
95 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 ...
-1
votes
2answers
22 views

Referencing cells from a different worksheet

Im trying to reference data within a cell of first work sheet (active) on a second worksheet (trucks). When I use =active!$L$34 on my second worksheet (trucks) it bring the right number over. However ...
0
votes
1answer
16 views

How to match Reg No. in one workbook to another

I want to find out a formula to match Reg No. for two workbooks. First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...
0
votes
0answers
25 views

How to see green and purple box around charts?

When I create a chart in excel and I click on the chart I would like to see the green boxes around all the data that the chart plots as well as purple boxes around the headings. How do I enable this ...
2
votes
1answer
40 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
0
votes
0answers
40 views

Excel, Compare columns values between 2 sheets and if any match update data if one

I 've found many useful info at the past from the forum, but now i trully need a hand. So, my issue is: i have 2 sheets containing some common columns, lets say Product Name, ID#, Price etc. How to ...
0
votes
0answers
25 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...
1
vote
1answer
18 views

What's the best way to merge 2 tables keeping 1 column aligned?

What's the best way to merge 2 tables keeping 1 column aligned? Example: I have these 2 tables from which I want to make table 3: TABLE1 color name1 red apple orange orange yellow banana ...
0
votes
1answer
32 views

Method to Consolidate Cell Contents from Two Excel Files into One Excel File

I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT. However, the customer wants me to submit an ...
0
votes
1answer
49 views

Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100. On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...
0
votes
1answer
90 views

VBA Excel: Function to find a string in another workbook

I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the ...
0
votes
2answers
84 views

Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...
0
votes
1answer
23 views

Separate cell content after “-” for multiple columns at once

-------------------------------------------- | Visible | Actual formula | I need | -------------------------------------------- | 0 | =500-500 | 500 | | 0 | ...
0
votes
1answer
50 views

VBA Excel: How to select only numeric values in a range?

I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column. I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...
0
votes
0answers
36 views

How to compose one table out of many tables?

I have a couple of tables which contain various data and I'd like all of them to be composed into one table. In one of the tables I have a lot of entries with various IDs for different things on ...
0
votes
1answer
63 views

Deleting entire row in excel if missing data in certain column or columns?

I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
2
votes
1answer
43 views

Horizontal Index Match Excel 2007

i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as ...
0
votes
1answer
87 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 ...
0
votes
0answers
32 views

Microsoft Office Excel 2007 conditional formatting

I have an excel sheet (2007). It is a tracking log of items. In one column I will input the date of the item received and in the next column will be the due date for that item (Example in I15 I have ...
0
votes
1answer
86 views

VBA string search within files in directory not working in Excel 2007

I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...
-1
votes
1answer
30 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
1
vote
0answers
14 views

Excel: cannot remove advanced filter

I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago. Now I would like to remove the advanced ...
0
votes
1answer
79 views

Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell): ...
-1
votes
1answer
89 views

Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...