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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
compressing an Excel file17 Dec 2005 13:36 GMT1
compressing an Excel file for faster emailing
Drop down box font size17 Dec 2005 10:20 GMT2
XL 2004 (Mac) Drop down box font size appears to be same as font used in the
sheet
When the same workbook is opened in XL 2002 (Windows), the 12pt Arial in the
sheet appears to be about 8pt in the drop down box
Need help with a formula17 Dec 2005 09:38 GMT2
I need help setting up a formula.
I have N observations (usually between 60 and 100 observations).
I want to choose the observation that estimates the 95th percentile.
Industry guidelines suggest that the observations be ranked and the 95th
Excel VBA to be replaced by C# ?17 Dec 2005 09:35 GMT2
Are there any plans on ditching Excel/Office VBA and replacing with C# ?
If so, then I suppose I'd better start getting prepared....
Named Reference17 Dec 2005 08:20 GMT2
Can someone tell me what the pros and cons are (if any) of these 2 ways
of naming a range.
ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell
Range("HOME").Select
Saving17 Dec 2005 06:16 GMT1
Here's a good one, is there any way to save changes to a worksheet, but not
the whole workbook?  Any help would be greatly appriciated.  Thanks.
Justifying Text17 Dec 2005 06:12 GMT2
I'd like to be able to wrap a 2 word header, have the second (bottom) word
right justified in the cell but the first (top) word centred above the
second word.
I can manage it by padding the first word with character colours matching
How can I choose alternate rows in a column?17 Dec 2005 05:16 GMT2
My requirement is to be able to create a column whose elements consist of
difference between adjacent elements in a column, say column A. If I can
choose alternate elements and create 2 new columns then I can just subtract
the 2 columns easily.
Display row for presentation17 Dec 2005 05:14 GMT2
I sat in a meeting recently in which the meeting leader displayed a large
spreadsheet on a projector connected to a laptop. Each row had 20 + columns.
Is there a way to choose a row and display only that row in a format more
suitable for presentation ??  Perhaps linking the cells ...
3 possible values17 Dec 2005 04:57 GMT5
=IF(F85>F84,"Winner","Loser")---- this is the formula that I'm currentl
using, but if a value has not yet been entered into cells F85 or F84 i
will still give me a Loser value. I understand why it is doing, but ho
can I have it put N/A if both values after still empty? Hopefully
Locking Formulas17 Dec 2005 02:19 GMT3
I need to average 3 cells.  However, whenever I add a new column, the
formulas shift by a cell, but I dont want them to.  How do I keep the
formulas from changing?
Example:
What is the cell data reference for 5th row and 7th column called17 Dec 2005 01:52 GMT1
Can someone help me with this question? I need to get the answer for my
homework. Thanks for your help.
unrecognized character17 Dec 2005 01:47 GMT3
I am trying to SEARCH or FIND a text string in an excel file without
any luck. The character is a hyphen (-) and the excel function (see
about) says it can't see it.
28(Sittin' on) the Dock of the Bay - Otis Redding (1968)
It would be nice if.......17 Dec 2005 01:14 GMT9
somebody actually took the time to help people on this website.
Read-Only won't go away.17 Dec 2005 01:09 GMT2
I've been working at this issue for some time now and all the advice I
have tried has failed.
Familiar problem:
I attempt to open a excel file from my A: drive and of course it says,
 
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.