I have a form in excel that has the unlocked cells (the ones to be filled
out) shaded so they stand out to the user.  (FWIW, the form is an
application for services)
When this form prints, I would like it to print simply with no highlighted

Hi there I got in troubles when I use Excel in my laptop because I have to
translate sometimes from English to Spanish so I need these symbols (á é í ó
ú) but when I try to use with the Alt+Fn+161 for example it doesn't work,
sometimes takes me to the colum M or shows a double ...

I've got a huge sheet of data that I'm trying to change into a specific
format.  I'm putting formulas on sheet 1 referencing the data on sheet
2 but putting it into the format I need.  The only problem is with the
numbers.

I have a worksheet of rows of customers and columns of products. There
are about 250 customers and about 100 products. Therefore, there are
25,000 cells of data. Each cell contains the dollar amount of that
product sold to that customer. I would like to create a 3-column list

How can you prevent the loss of formatting when refreshing a pivot table.

I have cells with a person's name in it.  Is there a function or formula to
enter in the cell next to that one that will only show the first 4 letters
from the original cell.
Cell A1 is Amanda

I have a workbook that contains energy information about every floor of
a building. In column 'Z' there could be a message called 'no savings'.
What i want to do is delete these
rows. I have started by selecting a range within column 'z' from 10 to

Here's my question:
Say I have the following I want to implement (each value is in its own
cell):
NEW BALANCE = CURRENT BALANCE - DEBITS

Excel 2000, workbook with several sheets. Each sheet is set up exactly the
same way so that the cells are constant from sheet to sheet. I want to
export (or, I guess Save As) CSV ALL worksheets at the same time. The only
way I can see that it works is that you have to save each ...

I have a userform which contains textboxes with calculations.  For
example, I have a statement that requires the user to input data to be
used to calculate inventory turns.  Once the data is entered, a formula
will calculate the number of inventory turns and will display in a

Our accounting department maintains an Excel file, updated in an onging
process, converted to a PDF at month close, and distributed to our senior
management.
There are nine worksheets, seven behave normally, but two worksheets default

I have a series of cells that will hold values such as 350,000.00.  This
value is entered by the user and entire amount is used in calculations
across the worksheet.
I want the output to be 350k.  This way, more columns can be viewed at a

Is there an easy way doing this.
A      B
1 Name1 7
2 Name2 8

i set up a calendar with business days listed with a number "1" in the
col to the right of the date.  i am now trying to return business days
only to a list in another sheet.  
i have done the following:

If column A has a series of numbers and column B has one number which is the
sum of specific numbers (cells) in column A is there a way to find out which
cells on A add up to the one number in B?
Thanks for any clues as to how to do this....