I have a range of cells (A1 to F1) that I fill with dates. In cell A1 I put the date in (8/24/08) then use the control,+ and ; keys to drag the dates across...

I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING. IT...

I wanted to delete and rename some of my Excel work sheets. I see the option, but it's grayed out so it won't allow me to do this function on a particular...

I have a worksheet with data in the region C1:Z10. I want to sum over everything in the region C1:Z10 which meets certain criteria for columns A & B (more...

Hi, Please guide me how to remove an external data source link in pivot as i need to make a new link (I am using excel 2007) Thanks Dinesh

Whenever I change, some change in worksheet, it starts recalculating formula everytime thereby taking so much time to return to READY Mode. Earlier it was...

I have a checklist of questions for a chair. All questions have a yes or no answer. I would like to record this information in Excel as a chart/graph. How...

I have a table where column A is the size of the material, e.g. 0.5",1",1.5"..., columb B is the thickness, e.g. 11,14,16, of the material, column C is the...

EXCEL DOCUMENT PRINTS MULTIPLE COPIES EVEN THOUGH SELECT AND 1 COPY. IT PRINTS LINES 1-12 MULTIPLE TIMES AND DOES NOT PRINT THE REMAINDER. THE REMAINDER HAS...

I need to request a little help please: I'm not fluent with writing formulas from scratch and need help (please): Using column B, I'd like to determine...

I need simple tutorial for Excel. Thanks,

I am creating a teacher planner with two different formats (top down and then, side-by-side) that each need identical event information on any given day. For...

Sorry to say this but as a new user who just got really familiar with the 2003 menu system, I think the "User Friendly" graphical menus of 2007 version are...

I'm working with Exel 2007. I made a simple spreadsheet with several due dates of a particular project. The spreadsheet shows when a person first came onto...

Is there any way I can add the two digits making up example: the number 16 which is found in a single cell. Add 1 plus 6 which would equal 7. The original...

I want to combine two worksheets into one summary worksheet so I can create a pivot table to chart dates along x-axis and numbers y-axis, legends being Open...

Hi I have a spreadsheet with stacks of £0.00 figures but need to increase these by 1.3%, so rather than manually doing it, can this be automated with a...

i am trying to put together a formula that sums a column based on the information in two other columns. The two columns that need to be evaluated have Dept...

i paste this code to code sheet but i dont know how can i sort my data after that and what is this code Private Sub Worksheet_Change(ByVal Target As...

can i sort my data automatically without click on "sort" icon