I have been searching for an easy answer to how to align 2 sets of data each with several corresponding columns. Both sets are sorted by company name, and I...

Is there anyway to change some of the fields in excel as a regular file (xls) then change it back to comma delimited? One of my clients wants his fields to be...

I need a code either a formula or better still a sub procedure or function for storing a current date value which cannot alter after that date and the...

Hello wizards! There's a way to show only the last column (grand total) in a pivot table? I have to present the worksheet but the audience does not have to...

I have an excel spreadsheet that is over 50,000 rows long and over 50 inches wide. How do I get the horizontal Scroll to appear on screen at all times?

I have an external file that import. It has state abbreviations only. How can I convert them automatically to full state name? Thanks -- bobr

Help me, oh ye gurus of Excel! I've made a pretty spiffy little spreadsheet with lots of drop down lists; the problem is, they don't drop down anymore. The...

The recently used file list in Excel does not reliably display all most recently used files. Settings under Tools/Options/General is set for 9 files. While the...

Using Excel 2003. We have a workbook with 3 worksheets with similar (but not exactly the same) information/layout. There are no links, groups, etc. between...

I have an excel file, I double click on it and excel launches successfully but the file does not load! I have looked thru preferences/options to no avail. Any...

When I open Excel, the very top of my window is the column letters. All menu's and toolbars are gone. How to I get them back?

I have several worksheets with too many tabs for them all to be visible on screen. Is there any way to have Excel display two rows of tabs instead of only one...

I have a web query that was created by going to a web page http://finance.yahoo.com/q/ks?s=GE selecting Export to Excel, then selecting the specific data I...

Hi, I have an xls sheet that just has the pivot table but no data sources. I managed to extract data by double-clicking on a data field. If I make it so that...

Hi I'm on XL 2000. In cell B3 I have a set date & time of 08/07/2004 16.30 , the NOW function in cell B4 and would like to calculate the difference in days,...

I would like to combine text from multiple cells inserting a comma between each word and the word "and" before the last cell combined, followed by a period. NO...

I have a user that claims that whenever she types a negative number it always displays it in brackets ( using Excel 97). I had to recently re-create her...

Hello, this is my first attempt at a newsgroup and I'm hoping that someone might know what's happening to this system I'm working on. The computer I'm dealing...

Every programming language I've used has wildcards....what is Excel's? I'm trying to use the following formula to simply find numbers that end in 12. How can...

I was not able to solve my problem yet. I am trying to find a row carrying certain data in a page and I want to cut this row and paste to another...