I have a set of data like below-
Col A    COL B
aaa    1
aaa    10

I am new to Excel 2--7, having used Quattro Pro for many years and I have
received very useful assistance from this group.  I have what is probably a
pretty basic question, but I can't find an answer in the Help files.
Every time that I open Excel and then exit, whether I have ...

http://msdn.microsoft.com/en-us/library/bb242669.aspx
consider this link, which gives the Object Model Changes Since Microsoft
Office 2003 of Excel object model
can u please give complete idea regarding the status "Hidden". Why I want to

Chart Object.PlotArea.Fill returns ChartFillFormat  object. But in 2007 both
the ChartFillFormat object and property Fill of PlotArea are hidden.
Actual requirement is like following.
 .PlotArea.Fill.Visible = True

want to add the location box (formerly the web toolbar), however when i go
into customize per the instructions online the add and remove buttons are
grayed out, same w/ the 'customize toolbar' dropdown option off the QAT.
it's a work computer, could there be something to do w/ ...

Is there some key combination that enables the user to quickly jump to file
properties in excel 2007.
Kind regards
IgorM

I have a lot of text boxes that I am using as command buttons (calling
macros).
There is 1 text box that is placed between cells that are hidden until
needed. That 1 text box will not unhide when I

I had to uninstall and reinstall Office 97. It was crashing randomly.
I have the Analysis Toolpak installed and macros enabled. Now, My
macros are not working correctly. Many errors. The example below, It
moves the number to A4 correctly ....but not to A5 and no beep. Yes,

$N29="$0.00" applies to $O29, but it didnt trigger when O29= 0
Note: format at O29 nbr cells set to currency $

I have an excel file that I always save as a text file for importing into
another program. I was wondering if a Macro could be made to do this? I have
tried to record the Macro as I do it, but it didn't even save it.

I have to compile a worksheet from data copied from a pdf file.  Problem when
i copy and paste text all data falls into column A and i have to drag one
line at a time to the specific headings.
this is how the data I copy pastes into excel:

I have used Excel 2003 for years and have made a rather heavy customization
by defining new toolbars with buttons calling VBA. Unfortunately, with Excel
2007 toolbars no longer exist! Gates and his gang of developers have decided
that we all have to use Ribbon instead. Ofcourse I ...

How do I calculate the confidence interval for each year's forecast with the
output Excel gives me regarding the confidence intervals?  I ran a multiple
regression in Excel using the Analysis Tool Pack and I can see the upper and
lower limits, but I do not know how to use those ...

Dear experts,
I have a long list of student numbers (numbers occurring more than once).  I
want to set up a formula which automatically filters for unique entries.  I
used an array formula which I got on this site and it works beautifully

I was hiding a sheet and fooling myself that it was truly hidden. I
discovered that by going to
Format - Sheet - Unhide , the sheet is there on a list and can be
unhidden. Very sad. Is there a way to hide the sheet so it is not