I am often assigned to create a report based on formatted reports downloaded from a database. Excel's maximum number of rows is most of the time insufficient...

Have a spread sheet with several columns. Would like be able to hit a key (i.e. Enter) to return to next row and back to column #1. thanks, L.

I have a column of pipeID (1400 IDs). I have a column of Target pipes. (78pipe IDs) I want a command to look Target pipes in pipeID and writes broken in...

Hi, I have a sheet which contains many accounts in one column and amounts paid in another column,I really dont need the auto filter which places a filter...

I have a sheet on which I need to protect some cells. I have it filtered. Whenever I protect the sheet, I cannot click on the little arrow to filter, even on...

I have just installed Office 2003 on my new computer and I forget how to change the unit of measure from cm to inches. I want to be able to set my margins...

There is a Recently Browsed Pages tab under Insert Hyperlinks. How can I clear them upon opening Excel each time? Or how can I change the number of recently...

Hi there, I hope someone has seen this before and knows the fix! We have a csv file format that we use to upload data to our custom system. The last 3...

On a new spread sheet, every time I try to type a 3 digit whole number or less (i.e. 2 digits) the cell records the number with a decimal placed after the...

Can this be done? I have 850ish worksheets in a workbook that I would like to sort by geographic region - and a cell contains the region value on...

In attempting to prevent automatic recalculation in Excel, I went to Tools, Customize and the Tools optiion disappeared from the menu. How can I restore it?

I can't find any information anywhere about how to change the default paper size in excel and publisher. I inherited 6 computers which have all been...

We havea copy of Excel 97 that has some customized buttons on the standard toolbar. How can we move these into Excel 2000? We have two other machines...

I have several pc's here but only on one of them the csv opens in a single column. On the other pc's data is parsed into multiple columns. How can I get this...

Hi, I have a worksheet I give for the students, but I don't want they modify. If I choose Tools - Security - Password to Modify,

I want the three left hand columns of my excel worksheet to remain fixed while I scroll across the remaining 22 columns. How can I do this?

I have a range of cells that cannot be formatted and they are not protected. What else can be wrong with them? How do I find out (I tried Ctrl `, but there...

Does anyone have an Excel spreadsheet they use to track utilities usage? Are you willing to share? Any tricks for setting up a simple one? Thanks.

I keep having to change the Decimal places from 2 to 0, check the "Use 1000 Separator" and select for "Negative numbers" the red with parenthesis formatting. ...

I recently installed Hyperion Smartview and ever since then, every time I open an excel worksheet (whether or not it is linked to smartview) an extra...