Column A has hard coded data.  I need to add to the hard coded data figure
another cell.  I do not want to insert a new column or change the format of
my worksheet.  How can this be done without manually adjusting each cell?

When recording a macro - the absolute cell addresses are referenced as
an end result of my using the END & UPARROW (DOWN ARROW, etc...).  In
an unknown range of data I would like to use the movement keys define
my print range.  My method is to go to column D - press the END + DOWN

tab1
salesperson    1/31/2007   2/28/2007  3/31/2007
XYZ                      ?              ?               ?
tab2

I was going to print a multiple worksheet workbook, selected to print the
entire workbook, then saw that it was spooling 187 pages!  I cancelled it
immediately, though it would have been a good reference, but I was thinking
it was going to be less than couple of dozen sheets.

I am trying to divide my pivot table output by a constant (which is
5.05).  The tabulated output is summarised by the "Sum" function which
has been selected in the PivotTable Field dialogue box. I have invoked
Options and examined the further dropdown selections from the "Show

Is there some way to show the formulas used and their current values
in a report?
Thanks

I'm pretty good at using excel, and VBA macro, so I'm not a compelte
newbie.  But I am having issues trying to change/link the data labels
to a 3rd series of points.
I have download an excel sheet (that has no macros) that contans a XY

I would like to update a range of cells with any number that is input into a
specific cell

I have a formula that work fine on a computer, but on other computer (same
software installed) it return #VALUE. Formula is:
=SUMPRODUCT(--(Export!$G$2:$G$100>C9);--(Export!$G$2:$G$100<D9);--(Export!$D$2:$D$100))
Can anybody help?

I have an Excel file and i want to convert it so that i can work with it in
Word - how can I do that?

I wish to detect a signal in to an excel cell via a parallel port, hopefully
I can then count the number of pulses over a period of time. Any help would
be much appreciated

Hi there .. I am new to this forum .. was needin some urgent help on
this excel file of mine which seems corrupted for some reason. I try
to open the file when i get the message "The file is not in a
recognizable format". I click on the OK dialog and I can see my

I just started using Excel 2007.  In the older versions when I select a row,
column, or specific group of cells, Excel would highlight the group in a
certain color.  In Excel 2007, it simply surrounds the selected group of
cells with a thick black line.  I've tried going into ...

I'm using Excel 2002 and have a workbook with 3 identical worksheets in it.
I have frozen the top 5 rows, using them for headers.
On one sheet, when I want to sort the data starting in cell A6, I go to that
cell and then to Data & Sort.  The window that opens, opens properly  - ...

I have a document with 4 worksheets. Three of the worksheets contain bill of
materials (BoM) data.Each one has different number of rows. Additional rows
are added/removed as needed from each of the BoMs. Forth sheet is for
consolidation where I show totals as well as selection ...