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)

-1
votes
0answers
17 views

HyperLink to Another WorkBook based on a cell value [on hold]

I have two Workbooks. WorkBookA.Sheet1 and WorkBookB.Sheet1 In WorkBookA.Sheet1 in cell S1 I have the value of US1000. I would like to hyperlink to the cell containing the Value of US1000 found ...
5
votes
3answers
4k views

Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore. Using Excel ...
0
votes
0answers
15 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
-2
votes
1answer
52 views

Countif formula

I have dates in one column and names in the next column. I want the formula to count the individuals as per the date. For example, on 10/1/2014, I want how many times the name Kiran is populated in ...
0
votes
1answer
26 views

How to constant 0 in the range when the number is not inputed

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?
0
votes
1answer
23 views

In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back. Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...
2
votes
1answer
817 views

Why is Excel 2007 backwards?

I opened up Excel 2007 and this is what I see: Where the row headings are on the right and the columns are backwards... Does anyone know what is going on and how to fix it?
0
votes
0answers
9 views

How to perform calculations based on multiple conditions involving current cell cell color and the value or color of other cells [on hold]

I have a color coded spreadsheet for rental properties that I downloaded from a software program. The spreadsheet basically has 3 colors, green means the property is booked, black means it is ...
2
votes
5answers
11k views

How to stop Excel from formating the 16 digit account number in a way to avoid making the last digit zero?

I have large number of bank account numbers of different banks. Some banks account number start with zero and some have 16 digits. When I paste the data in Excel the leading zeros will be removed and ...
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 ...
3
votes
3answers
14k views

Microsoft-excel newlines and tab

Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE". Example: I've string below when I completed join string. "Today ...
0
votes
3answers
23 views

Excel pivot and chart - hiding field from the chart

Hi have this pivot table the pivot table is basically as follows Project1 - 01/01/2010 | some data Project2 - 01/06/2010 | some data Project3 - 01/05/2010 | some data Project4 - 01/04/2010 | some ...
0
votes
1answer
10k 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 ...
0
votes
1answer
17 views

Filter a pivot table based on the values in specific columns

I have a pivot table where there are multiple column labels: group subgroup subsubgroup status The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...
0
votes
1answer
14 views

Excel formatting: how to format time periods?

I would like to format a time period like: 10:00 - 16:00 How do I? And can I do it without dates?
9
votes
2answers
7k views
0
votes
1answer
9 views

Conditional formatting, one Column based on another

Cells in column A will contain dates. There will be dates in column B as well. I need the cells in column B to turn red if the date is after that of column A.
0
votes
0answers
14 views

Scores results needs updating as you type in the answer- excel lookup or similar [on hold]

I have a two tables the first is a table where results get typed into Table Name Rounds 1 2 3 4 5 6 7 8 9 10 bonus Round played ...
1
vote
1answer
7k 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
1answer
23 views

Double click on one cell to change text bold and font color of another cell on the same row

I have some code written that was given to me by another user, Twisty (who I seam unable to reply to in the page that was used), which is amazing and what I needed. However, I need it to do a little ...
0
votes
0answers
13 views

Excel 2007 freezes hangs when I enter an email address

I don't know how this started. But anytime I enter an email address, excel freezes. It never responds no matter what option I choose. I have tried it with one cell and nothing else. I have tried it in ...
11
votes
3answers
53k views

Excel keyboard shortcut to copy/fill down for all cells with non-blank adjacent cells?

I'm looking for a keyboard shortcut that will duplicate the functionality available by double-clicking the "handle" in the bottom-right corner of a cell. Is there something that can do this, without ...
1
vote
1answer
5k 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 ...
1
vote
1answer
24 views

How to count number of unique buyers in excel? [closed]

I am creating a workbook for sold items of my company. and I have a list of items in column O of one of my sheets. now I want excel to count the number of total buyers and number of unique buyers. I ...
1
vote
1answer
32 views

How to return a value from a range if cell contains that value

I have a list of Names (First and Surname) in A:A. I also have a range called 'Surnames'. How can I apply a formula so that B:B returns the surname only of A:A if that name is found in the range ...
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, ...
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 ...
-2
votes
0answers
14 views

Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have? I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...
1
vote
2answers
20 views

When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link: http://web.utk.edu/~dhouston/excel/exam1.pdf to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...
1
vote
1answer
42 views

excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform. Now I would like a button on the ...
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
0answers
26 views

Excel error – command sending fails

Everytime I double click .xls file I get error window: "There was a problem sending the command to the program". There is no problem if I open the file by “File-Open” command.. I tried to copy and ...
1
vote
1answer
19 views

Hide a number in excel 2007 spreadsheet

I am using excel for a mileage log. I want to be able to hide the "Daily Accumulated Odometer" number if there were no kilometers put on that day but still need that number to add to the next time i ...
6
votes
3answers
17k views

Setting up a column of “enum”-fields in Excel

I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled'). I'd like to set it up so the only possible values in these column are from the fixed ...
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 ...
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). ...
-1
votes
0answers
37 views

Identifying and highlighting non-matching text across 2 columns

Hope you can help a first time poster (self taught at Excel). I am working in Excel 2007 and have data in 2 columns (approx. 70000 rows) which contains details of 500 current & historical: ...
0
votes
0answers
15 views

How to have excel 2007 userform stay on top of all other windows

The title says it all really. I have a modeless form generated in excel 2007 that'd ideally stay on top of all other windows (not just excel). I know other applications can set this, but I'm unsure ...
0
votes
3answers
24k views

Excel 2007 formulas not autofilling when I drag down

If you write a formula like: =sumproduct((something=$A1)*(somethin=$B1)) Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...
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 ...
3
votes
3answers
8k views

How can I insert the quoted price of gold from kitco.com into my excel spreadsheet?

kitco.com provides a realtime price quote for gold and other metals. I have a spreadsheet which makes calculations based on the price of gold and would like for this realtime value to automatically be ...
2
votes
1answer
23k views

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...
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
4k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
2
votes
4answers
61 views

Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this: % of ...
2
votes
2answers
73 views

Add button to copy Excel rows

I want to add a button on a row in a spreadsheet that copies the contents from one cell to another if and when I click the button. I already have found the code to do this, however, I want to be able ...
0
votes
1answer
2k 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 ...
0
votes
0answers
26 views

Sharepoint Excel file synchronization

I recently found a problem with Sharepoint and Excel with concurrent changes: Person A created an Excel file with, let say, 2k inputs and uploaded it to Sharepoint with website Person B did not open ...
0
votes
1answer
39 views

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

I have the following formula on the second sheet of my workbook. On my 'output' page, I want to display every 17th cell of the first sheet. However when I drag the formula down, it goes up in 2's. Any ...
8
votes
4answers
12k views

Why does Excel 2007 changes the text “HSA”to “HAS”?

Working on Excel 2007 I am trying to populate a cell with the text HSA. However, when pressing enter, the text changes automatically to HAS. I assume there is a kind of auto spelling correction here, ...