|
Email?
Received e-mail states I need miscroft office XP cd, Do I need to buy this,
or can I download the program?...
|
10 |
16.07.2006 01:53:46 |
|
|
Highlight Duplicate on entry
Hi,
I need something that would highlight the cell entry if there is a duplicate
entry located on the sheet.For instance, i enter account N15650 in the
account column and if this entry has previosly been made in the same column
then i want this new entry to be highlighted as a flag for me.Does this
require a macro or vb for this action?
Thanks...
|
3 |
15.07.2006 09:46:01 |
|
|
Slanting cells across top of Word table or Excel spreadsheet?
I want to make a single-page form that has long descriptions down the left,
and names of people across the top -- but the names need to be slanted upward
because there are too many, and the matrix boxes will have only a + or - in
them so they can be quite small. An example would be the mileage charts on a
road map, with city names at left and top but only a few numbers in the
matrix boxe...
|
2 |
15.07.2006 00:59:34 |
|
|
copy over just columns and headers
How can I transfer columns and headers from several worksheets to another
with out having to copy and paste everything?...
|
2 |
14.07.2006 19:52:10 |
|
|
Some users have more worksheets than others in same doucment
Hello,
We have users who access an Excel spreadsheet on a network drive. They
all access the file throughtout the day. A few users have added worksheets to
the spreadsheet and can see them when they re-enter the document later on.
Other users, however cannot see these added worksheets (Sheets 19-24, for
example). I checked their permissions and they all can modify the document.
My...
|
1 |
14.07.2006 17:10:02 |
|
|
How do I enlarge the spreadsheet that has no sizing handles?
I opened a read-only copy of an Excel spreadsheet. It opened at a quarter
size of the screen. The only help available says to enlarge by using the
sizing handles. When I go to the sides or corner, the sizing handles DO NOT
show up. Please help. TIA....
|
3 |
13.07.2006 22:28:59 |
|
|
Can you change the font in sheet tabs?
Can you change the font in sheet tabs?
TIA for your help!...
|
4 |
13.07.2006 20:06:02 |
|
|
Naming Row/column in same cell?
When you are using one cell with a diagonal line to separate the row and
column headings, how do you make the row text to the right margin ih the cell
and the column text to the left of the cell?
--
SgtBob...
|
2 |
13.07.2006 14:58:57 |
|
|
How do display a "+" or "-" sign when hiding columns?
How do display a "+" or "-" sign when hiding columns that allows someone to
click on the + or - as a shortcut to hide or unhide cells?
I want to hide my column and have them click the - sign to unhide....
|
2 |
13.07.2006 12:21:29 |
|
|
Excel Auto Fill Handles
I have a formula in C2 which calculates data from A2 and B2. I can
double-click the lower right "handle" in C2 and if I have data in columns A
and B, rows 3 through ??, that will copy my formula down and fill values
(i.e. through C500) until a blank row is found. Now what if I want to copy a
fromula horizontally across many columns until it finds a blank column? If I
double click the ...
|
2 |
12.07.2006 20:58:57 |
|
|
how to hide a list of macros in excel 2000 without password protection
Hi,
I would like to hide a list of macros from user in excel 2000 without
password protection functinality.
could you help me out at padam76@gmail.com?
...
|
2 |
12.07.2006 20:10:03 |
|
|
how do I delete rows,
I only want rows A through G, how do delete rows H through whatever. I do
not want them on my screen, I want to totally delete the rows. ...
|
3 |
12.07.2006 11:03:59 |
|
|
The autofill function of Excel seems to be damaged.
Dear Sir,
The autofill function of Excel seems to be damaged. The following figures
showed what happened when I use autofill function with my PC.
When I click the cell with the wrong result, I found that the function is
correct but the number is wrong as following figure shows.
After I double click the cell with the wrong result, I will enter the edit
mode for the cell. ...
|
2 |
12.07.2006 03:28:32 |
|
|
I LOVE EXCEL!
I just love this program. It is so organized and almost anything is
possible, you just have to know how to use it. I wish there would be a
quicker way to ask questions, like an instant messenger. Otherwise, it is
the best!!!!
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the...
|
2 |
11.07.2006 21:31:39 |
|
|
Change the default Currency style
It is both frustrating an nonsenical that the default Currency style (ie the
one applied when you click the Currency button on the Formatting toolbar) is
actually based on an Accounting format.
Why isn't it based on a Currency format?
.... and why can't it be changed without creating a template? (ie so it
applies to all Workbooks rather than just newly created ones)
----------------
...
|
2 |
11.07.2006 06:52:23 |
|
|
Calendar Control
Hi,
Is there anyway I can download the Access calendar control and use it in
Excel? My problem is I want to use the calendar control but do not want to
install Access.
Is it possible?
Please advise.
Thanks!
xertef...
|
3 |
11.07.2006 03:41:02 |
|
|
filter on a protected sheet
I have a sheet on which I need to protect some cells. I have it
filtered. Whenever I protect the sheet, I cannot click on the little
arrow to filter, even on cells that are not protected. What am I doing
wrong?
Thanks,
Peter
...
|
5 |
10.07.2006 23:04:51 |
|
|
Font Size in Drop Down List
I have a drop down list where I want to change the Font Size. I have tried
changed it in the cells where the data resides and also in the cells where
you have the drop down list and neither way increase the Font Size. I am
sure it is something very simple that I am forgetting. Hope someone has the
answer....
|
4 |
10.07.2006 22:40:26 |
|
|
Outlined Data in Excel
Can you collapse Text Data in Excel like you can in Word? For example I have
three columns (A, B, C) I want to be able to hide the data in column B and C
for example and just see A condensed onto one page. I know you can use the
collapse and hide function when you have subtotals, but I am using text....
|
2 |
10.07.2006 21:50:46 |
|
|
Disable automatic GETPIVOT
Whenever I reference to a field in a pivot table I get the
"GETPIVOTDATA....." worksheet function. This would normally be OK but
this is an Absolute reference and I can't figure out how to get it to
make it a relative reference.
The only way I can do it is by taking out the formula and manually
entering the cell reference - ie "A1". Is there any way the GETPIVOT
function can be turned of...
|
4 |
10.07.2006 20:19:12 |
|
|
Color Palette changes when I open excel file
I have an Exel file that, whenever I open it, it changes my color palette,
and applies that color palette to all the Exel files I may already have open.
The palette applies itself to all Excel files I open after I open this file.
Even if I open this Exel file first, close it, and then open other Excel
files, this "wrong" color palette applies itself to the other files. I have
to close...
|
3 |
10.07.2006 14:49:10 |
|
|
hyperlink
hi, i am a layperson . i am looking for a way to do the following-
i use charles schwab to invest, the stock prices are constantly changing. i
was wondering if i could use hyperlink to constantly move the data to excel?
if so is there a stright forward way for a layperson to do it? thanks jeff...
|
1 |
08.07.2006 11:38:01 |
|
|
Template for state of Alabama Certificate of Immunization
We fill out many, many certificates of immunization for the children we
vaccinate at our office. It would be nice to have a template where we type in
the dates the immunizations are given, add to it, and retrieve and print the
document on the state approved "Blue Card" for the children of Alabama. The
document is known as the State of Alabama Certificate of Immunizaiton....
|
1 |
07.07.2006 20:22:01 |
|
|
Gremlin on VBA help
In the vba editor if I highlight a legitimate VBA keywork and hit f1, goes to
the help information without a problem.
If I don't highlight anything or highligh something that is not a keyword,
it goes to the help index tab. When I type in a word, all the available help
topics appear below.
Now here is the weird thing, when I then click on the desired help topic,
its starts running th...
|
1 |
07.07.2006 17:52:02 |
|
|
Total on filter
Hi,
I have a sheet which contains many accounts in one column and amounts paid
in another column,I really dont need the auto filter which places a filter on
every column.How do you make a filter for the account column and at the same
time have a total for the amounts paid column when the filter shows only
those accounts? ...
|
5 |
07.07.2006 17:29:30 |