Hi,
目前分類:title (4957)
- Nov 03 Mon 2008 20:47
Pivot tables
- Nov 03 Mon 2008 20:47
Need help with copy if
What I am trying to do is copy column A-D from quot;scheduledquot; worksheet to quot;testquot; worksheet if column X has an quot;Xquot; in the column. Is this possible and if so how is it done.
Enter and run this small macro:Sub Macro1()
- Nov 03 Mon 2008 20:47
gray screens
i am trying to open an excel spreadsheet, i was able to do it about 2 weeks
ago and now everytime i open excel i get nothing but a gray screen. if i go
- Nov 03 Mon 2008 20:47
Vlookup
=VLOOKUP(B21,{quot;Canonquot;,2;quot;Compaqquot;,3;quot;Dellquot;,4;quot;Eizoquot; ,5;quot;Fujitsuquot;,6;quot;HPquot;,7;
- Nov 03 Mon 2008 20:47
second highest digit value
- Nov 03 Mon 2008 20:47
Smart Tags and Stock Symbols
Using Smart Tags to get Stock updates is great, but some stock symbols do not
trigger the Smart Tag. For instance, HD (Home Depot) does not, or COSI (COSI
- Nov 03 Mon 2008 20:47
How do I create multiple scroll bars within one Excel sheet?
- Nov 03 Mon 2008 20:47
tick box, how to set up
Hi can anyone explain (if possible) how to set up a tick box?
- Nov 03 Mon 2008 20:47
Saving as Web Page in Excel
Hey all,
- Nov 03 Mon 2008 20:47
Hyperlink function problem
Hi! I'm hoping this will be very simple. I'm working on a database with
hundreds of contacts. Column A has the contact names, and Column B has their
- Nov 03 Mon 2008 20:47
How do I make two y axis in bar graphs (i.e. cross hatching)??
Two y axis on a graph with one x axis.
- Nov 03 Mon 2008 20:47
is there a way to make the bars on a bar chart narrower?
- Nov 03 Mon 2008 20:47
Backup settings
Hi,
If I want to backup any settings I have in Excel and move them to another
- Nov 03 Mon 2008 20:47
Creating a numercal list
Hi. This may be in easy question for someone to answer...
I want to create a list of numbers beginning with, say, 17635 and running to
- Nov 03 Mon 2008 20:47
Percentage formatting
Is there a way to format a cell that has a negative % to be (100%) vs. -100%?
- Nov 03 Mon 2008 20:47
pb with calculated field in a pivot table
Dear experts,
I have a pivot table to which I would like to add a calculated field that
- Nov 03 Mon 2008 20:47
how to add watermark in microsoft excel 2003?
dear all,
someone can tell me, how to add watermark in excel 2003?
- Nov 03 Mon 2008 20:47
print 4 alternate columns
hello community
- Nov 03 Mon 2008 20:47
is there a limit to the number of rows the filter can handle?
I have and Excel spread sheet w/ 12000 rows of data. With common data on
many of the rows. Is there a limit to the Filter? I'm not picking up all the
- Nov 03 Mon 2008 20:47
Formula Help
Is there a way to delete line items in a worksheet and still have the formula
produce a correct result? Ex: If I delete d1 then my forumal says REF!