Hi, I know I can number sequentially by just entering 1 in the first row and hitting ctrl+draging it down. But what if there are headings inbetween that I...

Hiyee all~~ I'm a newbie of Excel with VBA. I got a question that need help from you all. When I create the pivot table, I record the macro. After...

I have text controls that are word wrapped and a 250 size. Can enter the text, and it does wrap, but the size of the control won't expand to see all the text...

I am trying to link a Word document content (inside the .doc) to my spreadsheet. I need help with this as the on-line help shows how to hyperlink between...

how to calculate the grading for staffs

How do I make the Microsoft mouse stop the zoom effect when I have it on the spreadsheet. I want to scroll up or down not zoom in or zoom out. Thx

I'm using Office XP and am putting text I typed in tables from Word into an Excel spreadsheet due to the columns expanding way beyond 11x17, Word's maximum...

I have a workbook that tracks inventory, but I would like to update it with a formula to help me track the materials used to create my inventory. Example: ...

Our employees turn in a weekly timesheet. We pay by the quarter hour worked. The timesheet automatically calculates the hours worked based on the starting...

I want to know how can I set the default for the classic Pivottable layout in version 2007. I've tried the pivottable options display tab and checked the...

Hi all, I am using office2007. I have an excel sheet with the following colimn invoicedate amount period. How I can give a formula i n period...

To take it a step further, I also need the formats to remain the same. ie...the left column data is Left-text-justified, and the right column is...

Hello, Using Excel 2007 Have a column of numbers that I entered as Text. Wish to change the entire column, now, to "Numbers," so that I can apply a formula...

Title tells all. This is probably so basis Old Hands will laff selves silly but I'm roadkill alongside the on-ramp to the Infobahn. I've bludgeoned Excel...

Hi, Using Excel 2007 Have a spreadsheet that I copied from elsewhere, that I want to modify a bit. In one column are GMT times expressed as 4 digits. e.g.,...

need major help with excel. I can't remember how to calculate the numbers and means etc for chart useage

Hi is there any way by which we can filter the rws by choosing the color of a cell.

In the excel 2003, i used to have a few specific macros i created and saved in my Personal.xls file. These macros were basically setup to format a specific...

How can I remove the space in BE 039 to make it BE039?