A guy here is trying to figure out example: Columns A to K in row 1 is particular headings displayed. He wants to know instead of copying and pasting where...

Hi all, I have a long table where i need to add and colour individual cells based on 'days home' and 'days away'. The table is uploaded here...

I am new to computing and would like to know if someone can help me write a formula in excel for a worksheet. I have quite a significant amount of rows of 6...

Why can't I create two separate workbooks in excel 07. Why is it so difficult to find out how to do this. It is not in your help menu. You force people to...

Is there a formula to hide a row without writing a procedure in the code. Example: If A1 is blank don't hide, if anything is in A1 hide. Thanks in advance.

I have recorded the simple macro below but need to change the "F2" cell address to be a user defined cell preferrably by 'clicking' on cell as I have had no...

Excel 2000 When I "automatically" generate a cell reference in a formula by clicking on the source cell, the reference is generated as a relative reference...

I am trying to enter swimming race times in excel. I am using the format: m:ss.0, but when i put the data into a pivot table all of the tenths become...

I have a large excel 2007 spreadsheet for data entry. My users are highly accustomed to using Enter rather than Tab to move right across each row from...

Is there any way to open multiple workbooks in Excel 2000 and have each workbook open in a new *Excel window*? MS Word 2000 does this, by default, i.e., each...

As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the...

HI, When I double click to open a file with an .xlsx extension all I get is the Excel ribbon on top and a blank screen. I have to minimize then maximize or...

Hello Chip, I read your response to this problem of having multiple separate workbooks but was your response for Excel 07 or 03 because in 07 it seems...

Hey Everyone, I have tried to glean as much as possible from the forums and/or Help, but have hit a roadblock when it comes to my formula. I'll paste the...

Would like to set up a worksheet that is linked to an MS Project project. The intent is to pull certain fields from the project and use Excel to analyze the...

In Word there is a way to do different even/odd page footers. I would like the headers and footers on my even pages to print on the left side of the page...

I like to use this date format: 06-03-09 , but it isn't an option in my Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in FORMAT...

In our company environment we are having Office 2007 with SP1. One of our user group performs analysis on Excel sheets using the custom VBA code and the...

I have numerous similar pivot tables that were converted to excel 2007. They have the salesmen in the report filter and customer in the row filter. When I...

If B2 has a date lets say 3/15/09. How can I get D2 to show exactly 3 month ahead to 6/15/09.