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
0answers
26 views

How to Copy/Paste Link data conditionally (or achieve the same results), based on entries from one worksheet to the next within Excel 2007?

I am attempting to create a job log in Excel 2007 with two separate worksheets: Potential Opportunities (source sheet), and Interested Employers (destination sheet). These two sheets have the ...
1
vote
1answer
520 views

Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116): And click Ctrl+V. It gives me ...
0
votes
3answers
156 views

How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...
1
vote
0answers
16 views

Embed an dotm file into an Excel document

I have a dotm file( macro enabled word template). I want to insert it into an Excel file and I want to open it by the clicking of a command button in Excel form. The problem is, when I open this dotm ...
4
votes
1answer
2k views

Add/Subtract button Excel VBA

Here is an example of my project in this picture I like collecting, so I am making an inventory sheet in Excel. I want to make a way that I can click a button and it affects the next, or previous ...
0
votes
1answer
152 views

Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following: Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...
1
vote
1answer
191 views

Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...
0
votes
0answers
55 views

Cannot “save as” file on Microsoft Excel and Word 2007 running on Vista Home Premium edition

I have Excel and Word 2007 running on Vista home premium edition. After working on a new file and try to "save as" just before naming the file, a window pops up 2 dialog messages "Search online to ...
0
votes
2answers
2k views

How to automatically update values referenced from one sheet to another in excel

Here is my problem . I have 2 to 3 worksheets and I need to make a master worksheet . The 2 3 worksheets are containing the sales made in the day and the customer name . the problem is that new ...
2
votes
1answer
957 views

How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?
0
votes
2answers
180 views

Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...
0
votes
1answer
51 views

Why is Excel truncating my normal numbers?

I open MS Excel 2007 and I write: 50 and Excel changes that into 0.5 I write 500 and excel changes that into 5 I write 5000 and excel changes that into 50 and so on and so on. It is driving me ...
-1
votes
1answer
83 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
1answer
31 views

Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D | |---|--------|-----------|-----------|-----------| | 1 | Number | First | Second | Third | ...
0
votes
2answers
68 views
1
vote
1answer
523 views

Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values. However, experimentation suggests that the data validation drop-down list will never display at a smaller ...
1
vote
1answer
28 views

How to generate a series of growing values and timestamps for cell that updates automatically?

I have a cell A1 which references a sheet that gets updated by an external source (database). My goal is to record a log that traces the growing value of cell A1 at each different time the data is ...
0
votes
1answer
46 views

Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file? For example, I want a cell that can only get the values: a) "value1" b) "value2" c) "value3" Is this possible? PS: I have used this ...
0
votes
2answers
356 views

Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS. There is a mistake in my formula but I can't find a way to have it since ...
1
vote
1answer
47 views

Excel not accessible after import of data through script [closed]

I am using a python script to open up an excel workbook (by creating a pointer to it). After I put some data in the excel and script execution is completed, I tried to access(see note below ) the ...
0
votes
1answer
128 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
0
votes
0answers
248 views

Can't Find/Find&Replace “Purple, Accent 4, Lighter 40%”, all other colors work - Excel 2007

I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for ...
0
votes
1answer
27 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...
1
vote
2answers
46 views

How do I find matching data in Excel?

I am trying to find some files listed in a big Excel workbook. On Sheet 1 I have the list of all the files with full path. C:\A\B\01.xlsx C:\A\C\02.xls C:\A\D\03.zip C:\A\E\04.jpg ...
0
votes
0answers
39 views

Excel dates with standard format (*) become custom when opened in another country

Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...
0
votes
2answers
271 views

In Excel, checking if a cell matches one item from a named constant string list

This question is an expansion on In Excel, how do I check if a cell is in a list of values (a range of cells) . I'm trying to do =COUNTIF(name,G6) and when name refers to some cells, it works fine, ...
1
vote
2answers
218 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
101 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
215 views

Superscripts in Excel chart labels

I have data like this in two columns: 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 ...
0
votes
1answer
33 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
923 views

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

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 ...
0
votes
0answers
31 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 ...
1
vote
1answer
297 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
74 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
356 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
177 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
261 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
1k 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
695 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
80 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 ...
1
vote
0answers
75 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
56 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
60 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
47 views

CTRL+SHIFT+DOWN not working in Excel 2007

Ctrl+Shift+↓ is not working in Excel 2007. I have unchecked: Options → Advanced → Tools → Options → Transition Navigation Keys Ctrl+Shift+↑ is working fine. If I ...
0
votes
1answer
93 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
43 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 ...
2
votes
1answer
90 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., ...
4
votes
2answers
3k 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
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 ...
-1
votes
2answers
40 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 ...