Is there a way to force the user to enter in in ALL CAPS in a
particular cell irrespective of whether the keyboard has caps lock on
or off?
Like we can give a condition to enter only Numbers / logical select

If I hide the row/columns containing the source data of a chart the
respective series disappears from the chart.
Is there any way to hide chart source data without affecting the chart?
Many thanks,

I have created a Gantt Chart with Excel.  I would like to embed that
spreadsheet in Word for a report.  I have used "Paste Special" --> "MS Excel
Object"
However, there is 2 problems

I have a activeworkbook.save in my code after a command button is
pressed but as far as I can tell it doesn't actually perform the save
until I close my forms...Is this normal?
All I want is sheet one to be saved every time the "job end" button is

Maybe someone could help me out,
I recently made the regularly used excel spreadsheets on out office
network shared workbooks. It worked fine for about a day or so but
soon started stuffing up. We started having the problem where after

My bank allows download of account files into the
CSV format
so I can then use Excel to do my accounting.
All of a sudden it stopped giving me the option of

Is it possible to set one sheet to manual calculation and another sheet to
auto calculation, in the same workbook?
Thanks

Is there a function in Excel that will allow me to enter my current credit
card balance, the interest rate I'm being charged and the amount I wanna pay
every month and have Excel give me the rundown of how many months I must pay
that exact amount before my balance gets at 0 ...

I would like to input monthly data in a cell, lets say Cell A1
Within the spreadsheet I have a set of monthly figures, lets say from Cells
M1 through to M12  (Jan to Dec)
If state that Cell M1 = $A$1 and drag that down to M12.

Will anyone know how many tabs one Excel file can include ?
Thanks for your input ... I will search on my side.
Jacques

I need help with this if anyone can help me with this:
A1=$1500
B1=$1500
I want to create a logic that if B1 is greater or equal to A1 then YES and

I have gotten this formula thru the help of someone. It converts dates into
their respective fiscal quarters. The formula is:
="Q"&INDEX({4;1;2;3},INT((MONTH(A2)+2)/3))
However, this formula uses a fiscal year which starts on April 1st. I need

How big can Excel files get before they are too big?  Is there a
standard rule on this?
I have a file that contains 4,800 rows, each representing a high
school student, and 50+ columns.  I want to grow it to 6,000 rows over

Sheet protection does not protect tab names. How can I protect tab
names?

I have a simple spreadsheet that totals the hours from start to end time ie
a1+a2. However when I try to calculate total hours in a column ie
sum(L2:L36), the answer is not correct. What am I doing wrong?
Thanks - Dave