Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
worksheet names06 Oct 2004 13:59 GMT2
Is it possible to create a list of the worksheet names within the same file?
I received a file that has 40 worksheets.
I need those 40 names in a text list.
Is there a better way than cut-n-pasting?
How can I create an invoicing database in Excel?06 Oct 2004 12:54 GMT2
I would like to know how to create an invoicing database, or register in Excel.
(Invoice + tax = total) Are there any templates free online?
thanks
dynamic named range06 Oct 2004 12:33 GMT2
I have a dyanimce names range that starts in Cell A1.  The formul
behined the dyanimc range is:
=Offset(A1,0,0,Counta(A1;A65000),1)
This works fine if I have blank values.  But what if the blank value
Copy-Paste Subtotals in Filtered Lists06 Oct 2004 12:09 GMT2
Is it possible to paste just the subtotals from a filtered list.  I hav
tried to copy and paste the second level in outline view but when
paste I get the whole list rather than just the subtotals
--
Huge spreadsheet spanning 600 rows...06 Oct 2004 12:05 GMT4
User wanted this to print on 11x14..it spanned the entire
page and then some..where would I first look to edit to make this easy to
read.
Handle on cell selector disappeared..06 Oct 2004 11:29 GMT2
Fired up excel today just to see a very strange problem.. no handles on
selections at all. When I select the cells, its just a simple selection.. no
little cross at the bottom right. Can't drag, copy .. do anything.
Any suggestions on how to bring the handles back on?
a simple question06 Oct 2004 08:18 GMT1
I am using the Ctrl key to select a number of cells at one time. if
make a mistake how do i de-select a cell but still retain the selectio
of the others?
eg. I want to select the cells A1, A2, A4, A5. I hold Ctrl and click a
2 step LOOKUP?  Vector, array?  Help.06 Oct 2004 06:54 GMT1
Need Help!
I've got a Data spreadsheet  looking like the following:
Start | End | Class |  1  |  2  |  3  |  ... thru to |  150 |
1  |  5  |  1  |  12.25  |  13.50  |  10.00  | ... assorted #s unde
can it be done without notice06 Oct 2004 06:51 GMT10
The below code (which was given in this NG + With some minor alterations by
me) intends to check if anything is changed on column J then email that
changed info to a spesific email address without the notice of the workbook
user...
forecast function help06 Oct 2004 06:12 GMT1
Just to clarify that formula, am i right to say this?
=ROUND(FORECAST($E$1,B2:D2,$B$1:$D$1),0)
$E$1 - is selecting the forcast for year 2004
B2:D2 - is selecting all the data bar the years in the top row
forget VBA password06 Oct 2004 06:10 GMT1
I have forgot the password of VBA editor..how to hack it??
SumProduct/SUMIF?06 Oct 2004 03:13 GMT3
ok here is my data:
columnA
ACCOUNT EXE
Jason
Help killing Excel06 Oct 2004 02:17 GMT2
This code works for ~20 sets of excel workbooks.  ONE of the sets (a single
workbook) always crashes the workbook, with a request to contact MS with the
error report.  The last crash gave me a DDE server crash error.
Is there any thing in the sheet that would cause this?
How do I get XL2003 to default save overwriting the original?06 Oct 2004 02:06 GMT4
what program would be best for listing movie in alphabetical orde.06 Oct 2004 01:34 GMT2
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.