Questions tagged [microsoft-excel-2007]
Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.
2,279 questions
1
vote
0
answers
27
views
Windows 11 Alt+Tab issue with Excel 2007 and 2010 — Excel windows always move to the end
We’ve run into a recurring issue on Windows 11 with Excel 2007 and Excel 2010.
Whenever multiple Excel files are open, pressing Alt+Tab causes all Excel windows to move to the end of the Alt+Tab list.
...
2
votes
3
answers
161
views
Change row number in multiple places at once with one cell reference
I have a database where all of the values of each form entry appear on one single row. Every additional form entry response appears on subsequent row.
I then take this info and copy the info in ...
2
votes
1
answer
362
views
Excel always changes .xlsx to .xlsm — how to fix?
When I create or download a .xlsx file, Excel always saves it as .xlsm automatically. I don't need macros or VBA.
I already tried:
Changing default save format to .xlsx
Checking for hidden macros in ...
- 21
1
vote
1
answer
83
views
Make visible the "data table" on chart with the information that it contains
I have created a chart from a pivot table. The columns are built by counting the number of cases per month. I have built the pivot by having "causing instance" on the filter area; have the ...
- 11
0
votes
0
answers
41
views
Applying Cell Formatting on one column based on values in two other columns
I need VBA Code or a Macro to apply a Cell Formatting on column A, based on values of both columns A and C on the same row , so if Column A Value starts with number 1 and Column C value is B ,then ...
- 1
0
votes
1
answer
73
views
Pulling names from different cell on same row
I have a worksheet which contains quality results, for each day. Each day has about 50 cases on.
I am now trying to create another sheet which year to date will pull from each of the daily to tell me ...
-2
votes
1
answer
118
views
Need values in column B to appear as a list (now CSV value) and the value corresponding it (value from column A) to be filled correspondingly
I have a category name in column A, and its corresponding attributes in column B as comma separated values. I need the attribute values to appear as a list and the value corresponding it (value from A)...
0
votes
2
answers
72
views
How to classify a range of values based on another range of values, each with its own value range? [closed]
This is the document in question.
I want it to return the classification as A, B, C, or D for each row in the fields otx and ttd. The classifications A, B, C, and D are composed of values from otx and ...
0
votes
1
answer
97
views
Change the status text in a cell (e.g. from Ongoing to Alert), if the date on another cell passes 30 days
I have received date on column B and status on column A (Ongoing, Closed, Alert, Waiting to receive the product, Not started).
How can i change the status of column A(for example from ongoing to alert)...
- 11
1
vote
2
answers
484
views
Combine duplicate rows on Excel with the "non-blank" value?
I have a spreadsheet with duplicate names, but each row has different columns where things are blank. Is it possible to remove the duplicates in a way that keeps the non-blank value, or keep the value ...
- 11
0
votes
0
answers
60
views
how can i increment cell value by 1 (number format and date)
A
B
1
No
Date
2
1
01/01/2024
3
4
5
2
01/02/2024
6
7
8
3
01/03/2024
When I tried auto fill, obviously failed. It doesn't seem to skip blank cell and I dont want to do it manually by putting =A2+1 on ...
1
vote
1
answer
85
views
Having a hard time using Microsoft Excel IF function
I have been working on a simple tracking database, and I'm having a hard time using the IF function (or if this is even the right function to use for my problem). I want to create an ID number for the ...
- 13
0
votes
1
answer
630
views
How to add a cell reference to Date Filter in Excel Pivot Tables
I have a date in cell C3, I want the Pivot table to only show expenses from that day. I tried entering the cell reference in this field to create a custom filter but it does not work. I also tried ...
0
votes
1
answer
50
views
Use Excel to get only the cycle start date
I have the following data in Excel:
Date
Status of Lab1
Status of Lab2
01-01-2024
On pause
Pausing
02-01-2024
Started
Pausing
03-01-2024
Started
On pause
04-01-2024
Started
On pause
05-01-2024
Pausing
...
- 3
4
votes
1
answer
5k
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, something like ...
