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 / General Excel Questions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
2 monitors - Excel 9719 Sep 2006 21:33 GMT6
I can stretch Excel 97 across 2 monitors, but worksheets can't seem to
stretch any larger than 1 monitor wide.
Excel Appearance19 Sep 2006 21:22 GMT2
All of the sudden, I saw that the letters at the top of the columns now are
change to numbers. Now I see numbers for rows and columns. How can I change
the Excel appearance, so I see the letters at the top of the columns again?
Conditional Array Formula for date19 Sep 2006 21:05 GMT5
I am trying to display all the dates for a particular month from a list. The
data is accumulated on the Log sheet and is pulled to the Monthly Log sheet
based on a dropdown.
=INDEX(Log!$A$1:$O$2000,SMALL(IF((Log!$B$1:$B$2000<($Q$1),
enter consecutive cells into a formula19 Sep 2006 20:46 GMT2
I am trying to find a folrmula that will enable me to get the data in
consecutive cells, but the cell numbering changes every time, I am using the
Vlookup function to find the info in the first cell, but the other cells dont
have a V or an H lookup possiblility. What I'm trying ...
All Excel Dates show as 200619 Sep 2006 20:39 GMT5
All my dates are showing as 2006. Even when I type 2003 or 2004, they come in
as 2006. What is causing this problem?
Taking infomation in one sheet and adding it to another sheet19 Sep 2006 20:37 GMT1
I have two sheets.  First sheets has the heading Homeroom and then the
teachers name next too it assigning one homeroom to that teacher.  In my next
sheet I have homerooms and teacher again but this time I have the same
homeroom mulitple times.  Another words Sheet 1 would have ...
freeze font size in excel.19 Sep 2006 20:31 GMT1
I have set 14 as font size in "format cells" drop down.
Right size font is printed, but it reverts back to 7.5 as soon as I leave
cell.
Note: I'm trying to add e-mail addresses in a column after a list of friends
creating a pdf19 Sep 2006 20:21 GMT4
when creating a PDF from excel with 3 worksheets the 3rd worksheet comes out
blank. I also add a compamy logo at the top of the three woorsheets in a jpeg
format but it keeps getting cut off. Earlier vervions of excel didn't produce
these problems.
Protection on excel file19 Sep 2006 20:06 GMT4
To the 'community'
Is it possible to protect a formula and still have it update the calculation
when others add to the database?
Thanks ahead for your help...
How do I make colors appear correctly when linking excel to pub?19 Sep 2006 19:52 GMT3
Hi, when I link an excel table to a publisher document (for a client report),
the number that are in red in the excel spread sheet appear red in the
publisher document, until I print it. Then, the number appear black. Why?
Thank you -- any help would be greatly appreciated!
data validation - more than one in same cell?19 Sep 2006 19:31 GMT2
I have set up data validation to ensure number is = or > 3,000.  Otherwise an
error box shows up with a message.  However, I want to have another error if
the number is = or > 1,000,000 with a different message.  Is this possible?  
Thanks.
Using data form in large mailing list spreadsheet19 Sep 2006 19:28 GMT1
I have a large mailing list in EXCEL 2003 that I am updating and adding to on
a regular basis.  I am also doing registration for an event using this
spreadsheet which has many columns.  When I use the data form I am limited to
32 columns, which so far means I have to hide some of ...
Ms Query problem19 Sep 2006 19:25 GMT2
Sometimes when using MS Query, I can select multiple datafiles to construct
my quuery with, but sometimes that is greyed out.  Why??  Oh, I also notice
that when the "Add Workbooks" is greyed out, the file that I am conected to
places a dollar sign chaacter after the shet name, ...
How do I change the AUTOMATIC color in Excel for the font?19 Sep 2006 19:18 GMT1
When I first got excel I changed my automatic color for the font.  I would
like to change it again and I cannot remember how to do it.  Does anyone have
any answers for me?  Thank you......
Adding to an exsisting formula19 Sep 2006 18:46 GMT2
I need to know if or how I can add to an exsisting formula. I have currently
=SUMA1+B1    I need to add
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.