|
|
Format for 3 D reference by
Dan
When referencing a cell in a worksheet in another worksheet, is there a way to have the formatting from the referenced cell automatically be the same in the...
|
|
6 |
510 |
|
|
Cut and Paste by
Chris from Waterworks
Hi all. How can I cut and paste a formula that retains the same formula. Every time I do it the cell references change. While this is a nice feature in some...
|
|
3 |
336 |
|
|
Excel 2000 pPaste special features. by
Maurice
I need to add Biff3 and sylk formats in the excel 2000
paste special options do anyone know how to add these add-
ins? Thanks in advance
|
|
1 |
571 |
|
|
|
|
1 |
514 |
|
|
Excel spreadsheet by
Andy
I am a bit of a novice in the workings of excel. I have created database of fungi records from the london area and have uploaded it to my website. It appears...
|
|
1 |
405 |
|
|
|
|
1 |
669 |
|
|
sumproduct by
Sarah
Any help would be appreciated:
I have a spreadsheet with company salaries on it. The
sheet has multiple positions. I have position titles
column C and pay...
|
June 14th, 2004 10:25 PM
by Sarah
|
4 |
366 |
|
|
Fixing Comment Box Position!!!!! by
jphil1919
I have a worksheet that I have put comment boxes on numerous cells. I
have coded the sheet to display the comment box when the cell is
selected. I am now...
|
|
2 |
676 |
|
|
Excel schedule worksheet problem by
kaloseimi
Greetings:
Using XL2000 to modify file that creates work schedule.
- Cells formated for times.
- I enter 6 Am and 3 pm in two adjacent cells and the...
|
|
2 |
391 |
|
|
If Then Statements by
mh4568
Need help. Need to turn the following into a formula within Excel.
If B1945 then A19
If B19=45 but 100 then B19*A20
If B19=100 but 300 then...
|
June 14th, 2004 10:47 PM
by mh4568
|
2 |
462 |
|
|
Display different command buttons if... by
an
Hello!
I have many data to append in different dates, but only
one time for year, and many data to append hour to hour.
I think to make two distinct tables to...
|
June 14th, 2004 11:12 PM
by an
|
2 |
722 |
|
|
Finding all rows containing a number by
brazen234
I have one column by 5000 rows.
I need to find out the index positions of a certain number.
So let's say the number 123 is located in row 1000 and row 1400.
I...
|
|
2 |
347 |
|
|
|
|
1 |
574 |
|
|
question on pivot table by
Keyur
i have a column which states months. Before i had abbreviations for the
months and now i want them to be full names. when i changed them the
drop down list...
|
|
3 |
356 |
|
|
worksheet protectoin by
murtaza
some one pls guide me abt the following
my workbook has 3 sheets and sharing is also enabled along with protection (range defined)
when i unprotect the sheet...
|
June 15th, 2004 12:18 AM
by murtaza
|
2 |
321 |
|
|
Cannot open .xls file by
uglyphd
A friend of mine has a file on a floppy disk that she couldn't open. I
tried it on my PC and can't open it either.
The error message reads: 'filename.xls'...
|
|
5 |
352 |
|
|
|
June 15th, 2004 12:25 AM
by Matt G
|
5 |
584 |
|
|
Multipage Reply by
Mark E. Philpot
Someone asked me about multipages and I have been ill for
the past 3 days and could not reply. By now the post will
be more than 5 pages back. I ain't gonna...
|
|
1 |
378 |
|
|
pivot tables by
tikitai
I want to create a pivot table where I just have to enter the data in once where it will post to a general ledger, income/expense statement, profit & loss...
|
|
1 |
313 |
|
|
lines in cells with numbers by
MileHigh
When I print an excel worksheet, I have line lines running through the
some of the numbers. It looks like I put a number in and then crossed
it out.
I have...
|
June 15th, 2004 12:37 AM
by CLR
|
1 |
511 |