General

How do i change category names in a drop down list in excel?
I have an expence templae for excel made by someone else.I need to know how to change/create the category names from a drop down list.Any help appreciated. ... 2 Feb 2010 22:27

Vlookup
Can you have two vlookups in one statement? Tab A has 3 columns, EMP #, GROSS PAY, and DATE. See the chart below. Say i want to a cell to tell me the gross pay of emp #1550 on 01/22/10, how would the formula be? EMP# GROSS PAY DATE 1550 $1000 01/08/10 1582 $1530 01/22/10 15... 2 Feb 2010 22:27

Nonadjacent columns
How do I select noncontiguous columns? ... 2 Feb 2010 22:27

Formula Help
How do I enter a formula to look at a number and based on calculation round up or down to nearest hundreth? For example 421 would round down to 400 while 573 would round up to 600. ... 2 Feb 2010 17:29

Hard to select first worksheet tab
When you click on the icon in the upper left of a window a box appears with: Restore Move Size Minimize Maximize Close With Windows 7 the box also appears when clicking in the lower left of a window. That is the same area as the first worksheet tab making it very difficult to click it. Is there a solution to... 25 Feb 2010 12:34

Pivot Table Totals
I have a pivot table with a calculated field called potential units. The formula is (1 - Closure Rate) * Net Units. The column headers are individual months of the year. The calculated field works fine for the individual months, but the total always returns a 0. Any help would be greatly appreciated. ... 2 Feb 2010 17:29

VB Code to Change the Color on boxes - gradient
I can not figure out how to select a box and change the background color gradient to one of the standard selections? Any suggestions? ... 2 Feb 2010 17:29

pivot tables
So in 2007, I have two pivot tables that reference the same data set and have the same report filters. Is there a way to set it up so I only have to change the report filter selection on one pivot table and the data will be updated in both? I am fairly comfortable with VBA so any solution/suggestion is welcom... 3 Feb 2010 06:10

excel chart in word
How do I paste an Excel 2007 chart into a Word document? ... 2 Feb 2010 17:29

Unable to open Excel files sent to me by email.
When I receive an e-mail with an Excel file attached, I am no longer able to double click on the file to open it. Depending on the file type, I can save a copy to the desktop and open it. How can I correct this issue? I am using Excel 07 and Windows 7. ... 2 Feb 2010 17:29