|
|
Excel File Open by
Ron Oatney
When I choose the file and open option characters
automatically are entered in the filename box. The
characters vary and include "this then" and "this...
|
|
1 |
153 |
|
|
Graphic/Picture/Shape return possible? by
Numb brr Crunched
I would like a graphic, picture, or a shape to be displayed when a value falls within a particular range of numerical scenarios. I'm currently using an IF...
|
|
1 |
187 |
|
|
|
|
1 |
207 |
|
|
Font Size of List in Combo Box by
DB
Hi, is it possible to change the font size of the words
listed in a combo box? I have Excel 2002. Thanks in
advance for any feedback.
|
|
1 |
315 |
|
|
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 |
186 |
|
|
eliminating blanks by
geza
I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.
Thanks.
|
|
5 |
351 |
|
|
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 |
252 |
|
|
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 |
137 |
|
|
|
|
1 |
244 |
|
|
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 |
216 |
|
|
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 |
133 |
|
|
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 |
191 |
|
|
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 |
153 |
|
|
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 |
243 |
|
|
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 |
178 |
|
|
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 |
280 |
|
|
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 |
140 |
|
|
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 |
350 |
|
|
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 |
202 |
|
|
|
|
4 |
525 |