0
votes
0answers
57 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
2answers
40 views

“#REF!” appears in cell after referred-to cells are pasted in

On Office 2007's Excel on Win7, I have a file with a formula like AVERAGE(A29:A33) in cell A34. I then copy four vertically-adjacent number-containing cells and paste them into cells A29:A33. At ...
-2
votes
1answer
63 views

Excel formula to calculate taxes

I have the cost of a ticket without taxes on N45. I want to calculate 7% of that (take out comm. %), then add taxes from P45, but what formula do I use for that? Say I have a ticket price for $100.00 ...
1
vote
1answer
317 views

excel macro with column criteria to copy two rows in one sheet to another

I need a macro that searches for a string in a column; on finding that string it copies the row in which that string is found as well as the row above that. For example: Search for "boy" in column ...
0
votes
1answer
102 views

How to change background color in excel on word cell value?

I want the cell to turn green when I type in "win" or red when I type in "lost". How do I do that? I tried with Conditional formatting but I was only able to do it for one word value. There was no ...
-4
votes
1answer
79 views

How to open files when the sources are in a column of another file

I have a large three-column Excel file: first column is "data (Excel file) name" second column is the "data source(of that Excel file's data)" and third column is "remarks" visit link for see ...
1
vote
1answer
1k views

Excel 2007: Intermittent 0xc0000005 crashes

Hello there SuperUser Hive Mind. We are having an issue at the office I work. One of our users who has a workflow which consists mostly of Excel documents with dynamic formatting and macros which she ...
0
votes
1answer
529 views

Print multiple copies of “Print Selection” Excel 2007

I have a user who is trying to print only a certain set of cells in Excel 2007, but she needs to print 2 copies of the selection. Using the print dialog, she selects Selection under Print What and ...
1
vote
1answer
2k views

Is there a way to delete everything except what is selected in Excel?

I have an Excel template with 20 tabs (worksheets) and plenty of data in each sheet. When a user opens a copy of the template, he will only need to use one tab. Is there a sneaky way to select that ...
0
votes
0answers
452 views

How to get back to having OPEN IN SINGLE INSTANCE" as default for Excel 2007?

In June Mikhail asked the same question but the answer was how to do the opposite (make multiple instances the default). I am trying to get to an answer to Mikhail's question which I rephrase as :- I ...
0
votes
1answer
60 views

Spreadsheet calculation - determine number of days in a month

Expenses Shift Jan-12 Feb-12 Mar-12 Apr-12 1 Jan-12 Feb-12 Mar-12 ...
2
votes
1answer
64 views

Evaluate statement in IF condition in Excel

I'm trying to set up a budget where my last column shows what's left in my account in every cell from F6 to F30. I want the cell to only show it's value if another cell on the same row has a value. ...
2
votes
1answer
8k views

Why does my excel document have 960,000 empty rows?

I have an excel document, Office 2007, on a Windows 7 machine (if that part matters any, I'm not sure but just throwing it out there). It is a list of all employee phone numbers. If I need to generate ...
1
vote
3answers
1k views

Hide cells when printing in Excel

I'm using Excel 2007. I have an estimate sheet, which I will use to keep track of client information. There is some low level information that the client shouldnt see on their version of the document. ...
2
votes
1answer
2k views

Export Excel settings to a file

I have customized Ms Excel to my needs, for example I have written small macros and attached them as buttons to the quick access toolbar, made the Developer tab visible etc.) Is there any way to ...
2
votes
1answer
3k views

Recent files opened in Excel 2007 not appearing in the 'recent documents' list

I have tried: Clearing out all the recent files opened with Excel by going to Office button -> Advanced -> Display Category -> Changing the "Show this number of Recent Documents" to 0, and then ...
2
votes
1answer
257 views

Protecting the custom ribbon in Excel 2007

I'm creating a custom ribbon for a workbook in Excel 2007. If I open the Excel file as a zip file, then I can see the customUI.xml file that was created for these modifications to the ribbon to work. ...
0
votes
1answer
343 views

Can I update multiple Excel 2007 Pivot Tables data drop down one time?

I have about 50 Pivot Tables in Excel 2007 that need a drop down updated on a daily basis several times to reflect multiple pieces of data from the page I have of data. It is very time consuming to ...
5
votes
4answers
8k views

How can I force Excel 2007 on Windows 7 to always open another instance of the application?

I want to be able to compare to large spreadsheets side by side... Since you can not natively expand to all monitors I would like to have the two documents open in two instances. These files are ...
3
votes
3answers
3k views

Why can't I “tear” a maximized Excel 2007 window in Windows 7

In Windows 7, in most applications, when an application is maximized...I can "tear" the window (grab the title bar and drag) from it's maximized size and off the top of the screen and then I can drag ...