|
|
extra empty rows in Excel file by
Linda
My Excel file has 950 rows of data. Somehow, I now have
over 58,000 rows of empty cells; the file size has grown
from 500kb to 2100 kb. How do I delete the...
|
|
4 |
483 |
|
|
Digital signature in Excel 2000 by
Unexperienced user
When trying to sign a macro project (with a valid
certificate), I receive the following error message:
"There was a problem with the digital certificate. ...
|
|
0 |
192 |
|
|
|
|
2 |
169 |
|
|
Can I convert a WORD document to EXCEL? by
Robert Judge
A person has a data base program of some kind that tracks
students in a school. I have asked her to save the file
in a CSV format and send it to me so that I...
|
|
4 |
354 |
|
|
|
|
4 |
537 |
|
|
Sorting by
Kim
I have a list of names like so:
Last Name First Name Middle
Jones Kim A
Jones Kim
Jones Kim D
I am...
|
|
2 |
207 |
|
|
Auto Filter and Protection by
Gord Dibben
Side note:
Use a news reader like OE or Agent or one of the others and point it to
msnews.microsoft.com
CDO interface is not the greatest.
Gord Dibben Excel...
|
|
6 |
360 |
|
|
Count only nonduplicate number by
B Call
What is the formula that is required to return a count of numbers in a given
range while ignoring duplicate numbers?
For example, a column contains the...
|
|
1 |
145 |
|
|
Printing Issues by
Johnny
I have a spreadsheet and have setup and checked all of the
print areas for each tab within it.
I host a link to the spreadsheet from an intranet site and
have...
|
|
1 |
286 |
|
|
Can't choose printer by
Alexandre
One computer in our network has a problem. It has 3
printers intalled but Excel do not shows them to user in
print dialog. Default printer works, but its...
|
|
1 |
184 |
|
|
deleting macros by
itsme
Is there anyway to delete all macros in a file at one time, instead of picking one and hitting delete and then having to go back in for everyone.
Thanks
|
|
2 |
255 |
|
|
keep tab order after protection by
Rawley
I used the Insert, Name, Define, OK function in EXCEL to create a tab order, which works great. However, after protecting the sheet, the tab order doesn't...
|
|
3 |
158 |
|
|
Formulas dealing with +/- changes by
glissonk
I have the need to create a formula dealing with the positive or negative change in cells:
Example:
cell 1: 2.7
cell 2: 2.1
cell 3: 4.2
cell 4: shold equal...
|
|
7 |
196 |
|
|
Returning multiple values for a lookup by
cfincham
I have a spreadsheet showing the purchases of various part numbers with
the corresponding unit costs paid, there is normally more than one unit
cost per part...
|
|
4 |
137 |
|
|
crashed page by
This is probably a stupid question, but is there anyway to
retrieve a page you have been working on if the program
crashes? The Dr. Watson box came on the...
|
|
2 |
221 |
|
|
|
|
1 |
254 |
|
|
Annoyign Formulae Problem by
foolio
My work for the day involves calling our suppliers and getting them to
send us their price lists. I then take these price lists and format
them in a certain...
|
|
5 |
142 |
|
|
Group Rows to Sort by
Viki
I am creating a spreadsheet to log tapes. Column A is the Name of the tape. Column B is the names of the spots on each tape. Each tape could have up to 10...
|
|
5 |
257 |
|
|
eliminating blanks by
geza
I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.
Thanks.
|
|
5 |
356 |
|
|
text show as ###### by
Leo Lin
Hi,
I have a cell in Text format with "wrap text" enabled, And I copy from
notepad multiple lines of text. The cell turns to show "################",
Can...
|
|
4 |
191 |