|
|
Hyperlinks by
engmgriff
Hi
I have set a number of hyperlinks up in excel to jump to different
worksheet in the same workbook. My problem is when i hide the
worksheets my hyperlinks...
|
|
1 |
356 |
|
|
Validation blues by
Hari
Hi,
I have created different validations in my worksheet using a list as
dropdown.
Strangely when I click on the cell which has validation then the...
|
|
5 |
562 |
|
|
averaging time values by
Karen
I have a worksheet with data per week that I need to average for the month. However, until all weeks are completed the Avg/Month is wrong. Is there a way...
|
|
1 |
372 |
|
|
filter? by
Jan
I have a column that contains a bunch of repeating
information. what I would like is to somehow filter the
column so that only one of each topic appears.
for...
|
June 15th, 2004 12:42 AM
by AlfD
|
2 |
366 |
|
|
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 |
506 |
|
|
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 |
307 |
|
|
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 |
374 |
|
|
|
June 15th, 2004 12:25 AM
by Matt G
|
5 |
580 |
|
|
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 |
346 |
|
|
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 |
314 |
|
|
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 |
353 |
|
|
|
|
1 |
569 |
|
|
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 |
341 |
|
|
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 |
718 |
|
|
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 |
457 |
|
|
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 |
385 |
|
|
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 |
671 |
|
|
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 |
360 |
|
|
|
|
1 |
664 |
|
|
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 |
400 |