|
|
|
|
2 |
92 |
|
|
|
|
2 |
529 |
|
|
All column and row headers hidden by
tevans
My column and row headers/titles are missing (for example,
the ABC at the top of the sheet for a column and the 123
on the left side for rows). Any ideas on...
|
|
1 |
110 |
|
|
120 small images making workbook 37mb!! by
neowok
I have a workbook with 4 sheets, 3 sheets just have some organagrams
that dont take up much space. the 4th sheet has about 120 small
pictures on it, of maybe...
|
|
9 |
169 |
|
|
Column Numbering by
Andy M. - Utah
Ok, I'm sure this can be done and it might have already been posted but this is what I'm wanting to do. I have a spreadsheet of sports cards of a particular...
( 1 2)
|
|
10 |
264 |
|
|
Trouble with dates on a chart by
deacs
I have 3 columns of data. Column A = dates, Column B = numbers
corresponding to Column A, and Column C = other numbers corresponding
to Column A.
The dates...
|
July 7th, 2004 06:01 PM
by deacs
|
3 |
504 |
|
|
|
|
1 |
492 |
|
|
|
July 7th, 2004 05:27 PM
by Andrew
|
1 |
449 |
|
|
Auto Correct by
I am trying to type the last name "True" and Excel keeps
changing the word to "TRUE" in all caps and centers the
word in the cell. How do I stop this from...
|
July 7th, 2004 05:05 PM
by Andy B
|
1 |
829 |
|
|
Protecting cells by
rob p
Excel 2000. I have a worksheet that has some columns I want protected and
some others I want to be able to enter / edit . How do I set this up. (I
don't want...
|
July 7th, 2004 04:53 PM
by jeff
|
7 |
223 |
|
|
|
July 7th, 2004 04:32 PM
by RB
|
4 |
728 |
|
|
Comparing sheets by
Allison
Is it possible to compare two different sheets similar to
the way the EXACT function compares two cells? I have two
sheets that are probably exactly alike,...
|
|
1 |
247 |
|
|
Sum by
TJ
Hello,
Is there a way to sum in excel based on the color of the
cells above it.
If there is not a formula for this - is there vba code
that could do this and...
|
July 7th, 2004 03:46 PM
by TJ
|
2 |
119 |
|
|
Zero to appear as blank by
Prakash
I have a VLOOKUP formula below. When the value is zero, I want the result to be blank. What do I do.
=IF(A10="","",VLOOKUP(A10,detail,2))
Thnx
Prakash.....
|
|
3 |
162 |
|
|
Concurrent access to data by
count
Hi,
I have a working Excel 2000 app, where users see and manipulate data through
forms rather than worksheets.
Can you recommend a method of making this app...
|
July 7th, 2004 03:20 PM
by count
|
9 |
255 |
|
|
|
|
2 |
333 |
|
|
|
|
2 |
409 |
|
|
Formula for Date and Time duration by
Adam
Morning All,
I have to work out the time in which a case has taken to resolve on our system.
Now in Excel I have the Case Date (Date opened), Case Time (Time...
|
|
4 |
465 |
|
|
Column order in pivot tables by
Randy Harris
I have a workbook with several pivot tables that use "Month" for column or
row headings. Month is derived with:
=INDEX(Months,MONTH(F1),1)&" "...
|
|
3 |
410 |
|
|
Text Boxes - Scroll Bars by
Tappie
Hi,
I am currently using Excel in Office XP.
I have created a small 'Text Box', but have a lot of text
in it and I do not want to make the 'Text Box' any...
|
|
1 |
329 |