目前分類:title (3013)
- Oct 22 Sun 2006 20:10
caps
- Oct 22 Sun 2006 20:10
how do i hide negative values in excel
I can hide zeroes but I also need to hide negative values as well. How can I
get negatives values to hide?
- Oct 22 Sun 2006 20:10
golf score templet for a league are there any
are there templets for keeping scores, handy-caps ect. for a golf league?
- Oct 22 Sun 2006 20:10
COMMAND BUTTONS and CELL COLOR
My worksheet is a usable form with cells that are selected by changing thier
color. If the cell is a certain color, the reader of the form knows which
- Oct 22 Sun 2006 20:10
If A1=HR then...
- Oct 22 Sun 2006 20:10
Finding last used
I have imported a query into excel and I'm having a problem sorting the data.
The data consists of part #, description, technician #, usage qty, and usage
- Oct 22 Sun 2006 20:10
Moving workbooks between folders
I have a problem in that I currently run a macro that opens all the workbooks
in a particular folder, and merges the data onto one new worksheet, which
- Oct 22 Sun 2006 20:10
Rolling Information
I actually have two questions,
I have a spreadsheet with rolling data- everytime I insert a new line the
- Oct 22 Sun 2006 20:10
Between? Is there a way?
I'd like to count the number of cells in a range whose value is between two
preset numbers. I would imagine that it would be something like
- Oct 22 Sun 2006 20:10
function question
Is there a way in Excel to use the Min function to determine the minimum
value in a column, and copy that entire row to a new area of the
- Oct 22 Sun 2006 20:10
Month end calculation
I am writing a formula to calculate the last and next month end e.g. if I
enter 28-02-06, the expected result will be liked 31-01-06 and 31-03-06.
- Oct 22 Sun 2006 20:10
Need to rebuild formula using the value entered into a cell on the
I know this process can be done in VBA. I have done it. But using vba also
requires that I have a mechanism to run the code. This would either be a
- Oct 22 Sun 2006 20:10
.csv file
Once I saved an Excel file to .csv file, how can I protect .csv file with a
password?
- Oct 22 Sun 2006 20:10
set column width using character spaces
Hi there,
- Oct 22 Sun 2006 20:10
on particular action run a macro
i would like a macro to run the minute a user selects certain worksheet is
this possible?
- Oct 22 Sun 2006 20:10
Negative figures to appear in brackets
In excel, how can I get negative figures to appear in brackets
ie (7,500)
- Oct 22 Sun 2006 20:10
Drop down box in a cell
- Oct 22 Sun 2006 20:10
titling columns
is there a way to give titles to the upper portion of the spreadsheets (that
are listed A, B, C, etc.)? also, the same for the left side (1, 2, 3, etc.)?
- Oct 22 Sun 2006 20:10
Feature to flag unpopulated required fields in Excel?
Is there a feature in excel that will either:
- Oct 22 Sun 2006 20:10
partial lookup/match
i have 2 worksheets. the 1st contains a table of companies with their
industry codes (4digits) and the 2nd sheet contains tables with industry