Hi.
目前分類:title (5957)
- Jun 22 Fri 2007 20:38
Inserting rows, updating linked worksheet
- Jun 22 Fri 2007 20:38
macros
I have recorded a macro, using the mouse, as folows:Sheets(quot;rep90quot;).Select
Columns(quot;GN:GUquot;).Select
- Jun 22 Fri 2007 20:38
Comments in Excel
I do schedules in Excel and post it on a shared drive. I lock the book for
read only. I insert comments in some of the cells for my own information ie.
- Jun 22 Fri 2007 20:38
Cell reference in the auto filter custom list
Hello,I have data tables in cells A115, and have organised the auto filters in
the header cells A1 to D1
- Jun 22 Fri 2007 20:38
Dynamic Named Range
- Jun 22 Fri 2007 20:38
How can I count the number of times a letter repeats in a string?
- Jun 22 Fri 2007 20:38
Border color doesn't change.
Using Excel 2003. When I format cells --gt; border and change the color, it
continues to show up on the screen as black. Any suggestions?
- Jun 22 Fri 2007 20:38
How to insert auto populate calendar icon?
How do I insert a calendar icon that you can click on, it opens a monthly
calendar that you can move about in until you find the date you want, then
- Jun 22 Fri 2007 20:38
Setting borders for two rows and all columns on spread sheet
Have large spread sheet which requires two rows to be included within one
border for over 48 columns. Need to change the single row box to double row
- Jun 22 Fri 2007 20:38
Excel Formula?--gt; if A1=11am, then D5=A1; if A1=12pm, then D10=A1
I need to create a log that goes hand in hand with this contract that I have.
Both are in Excel. The thing is I don't know if the following is possible
- Jun 22 Fri 2007 20:38
Actual graphs
How do I plot a graph from an excel spreadsheet that shows the values of one
variable versus the values of a different variable, ie. along the X-axis
- Jun 22 Fri 2007 20:38
How do I automate credit control
My sailing club is in difficulty with people who pay late fees, I am a novice
with excel
- Jun 22 Fri 2007 20:38
highlighter
Does anyone know of a tool that highlights the row, column, or both that you
are currently in?
- Jun 22 Fri 2007 20:38
average 2 cells (Mileage Divide by Gallons in two cells
In excell What formula do I use to for above problem?
- Jun 22 Fri 2007 20:38
charts
I am trying to have the data on the y-axis appear exactly as it does in my
source. I would like it to say 1:00 AM, 2:00 AM, 3:00 AM, etc. It keeps
- Jun 22 Fri 2007 20:38
MS Query takes along time to open
I have a local spreadsheet which has a couple of queries. When I try to edit
the query, it takes about 10 minutes to open the query wizard. When I
- Jun 22 Fri 2007 20:38
Excel 2003 -vs
Finally I broke down and upgraded to Excel 2003 from Excel97. Various small
differences exist that I'm trying to come to terms with. Specifically, in
- Jun 22 Fri 2007 20:38
Assigning values to letters
We have a spreadsheet that we are to enter either an quot;Aquot;, quot;Bquot;, or quot;Mquot; to
designate whether some is quot;Abovequot;, or quot;Meetsquot;, or is quot;Belowquot; a designation.
- Jun 22 Fri 2007 20:38
ISBLANK
I have a formula in cell F9: =IF(D9=C9,quot;quot;,quot;NOT EQUALquot;). It's working great.
Now I want a formula in the next column that will compute a percentage if
- Jun 22 Fri 2007 20:38
When I add cells the sum is coming up $0.00
I have Essbase on my excel spreadsheet and it seems to really screw with
formulas. I am trying to add three cells together and the sum keeps coming