Can anybody help me with the following issue:
I have an Excel workbook with several filled sheets, when printint eac
sheet may contain more than one page.
When adding pagenumers and selecting a group of sheets, the pagenumbe

How or where do I perform linear regression - in the chart or worksheet?

I have created some macros in excel.  So my excel asking every
time  that file contains macros and it may contain viruses. do
you..............  How to disable this dialogue box. I didn't want that
macros. So Again i deleted all macros using Tools - > macro -> macros->

I have been lurking here for about a month.  There were some mentions made
of pivot tables, so I went to the Microsoft website and read some of the
training articles on them.
I am starting a new job and they want someone who understands pivot tables

At least the borders? We have a pivot table that has many columns of
data (18 months) and it is very useful to have an underline or row
shading to help follow across this large table.
We can set the borders and it works OK, but as soon as the data is

I've got a worksheet containing an invoice with client information including
fax number.
I would like this invoice to be faxed when the user clicks on a button.
This works fine with the 'Printout' method of the Workbook (I can select the

I got this formula, n i want to drag down so that the rest of th
columns has this formula too. However, when i drag down. A12 become
A13. I want A12 to remain as A12 and A1 become A2 n so on n so for
Does anyone know how to do it?

When I try to record the steps to unmerge 2 previously merged colums into 2
separate colums into a macro, when the macro is executed it tries to merge
the colums instead of unmerging them?
If I do the same steps without recording as a macro the unmerge works fine.

I am having difficulty devising a formula that works.  What I need is a
formula that will round time up or down to the nearest quarter hour.  For
example, if a person were to enter 4:06 PM I need a formula that would
calculate 4:00 PM; or if they enter 4:11 PM it would calculate 4 ...

Hi, anyone any thoughts on how I can best manage a very large
forecasting workbook with several spreasheets all linking in to one
another.
I already use a specialist program (Sage financial foreacsting) to

Hi formatting gurus,
How can you apply title case to text in columns in excel??
Please help.
Annalise

Is there any way I can display the Control Tip for a control that is
disabled?
thanks

I have a spreadsheet with about 13,000 song entries... Col a artist col
b song title.. Iv'e read advanced filter tutorials till I'm blue in the
face..  All I want to is filter the artist column delete duplicates and
replace the dups with empty cells., Anything I try deletes the ...

need to freeze top two rows (headings) while move down in the work sheet

Hi, after sorting information that I show in a listbox I would like to
highlight  the first item showing up at top of the listbox(right now I
get by default a dotted line under the first item)
Thank's ahead for any hint!