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 / February 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Help formatting text color based on formula11 Feb 2006 00:54 GMT1
I have searched the forum and find some things that help but not quite
enough.  I have a table of numbers.  In fact there are 300 rows of 5
colums of numbers.  What I would like to do is to change the color of
the number if it matches one of 5 other numbers.
Find Column Reference Number11 Feb 2006 00:25 GMT2
I receive an Excel tab with headers. The header is always the same
exept for the order. I mean, let's say I have the header : Name , Unit,
Company
Those three will always be there but in different order.
Excel 2000 Drop Down Menu10 Feb 2006 23:57 GMT2
I have seen a drop down menu before in an Excel cell.
I would like to incorporate this feature to be used for selecting a
month of the year. How do I go about creating such a feature?
Histogram Plot10 Feb 2006 23:30 GMT1
Hello fellow Excel users,
When trying to do a histogram plot I receive the following error
message: "Cannot change part of a merged cell" and then "Histogram -
Cannot draw chart for empty bins"
update cell without saving10 Feb 2006 23:13 GMT2
I have a real beginner question. I have an excel 97 spreadsheet that
won't update the results cell for a simple SUM function without saving
the spreadsheet. Can I change that ?
How do I reset the automatic outline for subtotals10 Feb 2006 23:03 GMT1
When I create subtotal levels, I do not automatically see outline or
grouping. What have I turned off?
Masking?10 Feb 2006 22:22 GMT1
I would like to do some data entry in a spread sheet.
First example
I have a date cell and it is using the standard of 02/07/06 .
I want to make it so that when I start the cell I see the slashes and I
Undo current sheet10 Feb 2006 22:20 GMT1
Hi again.
Don't know how to explain this.
I'm working on a couple of Excel files at the same time, going from one to
the other.
Excel 2002 can't open Excel 97 properly ?10 Feb 2006 22:19 GMT1
I am using Excel 2002. If I open an Excel 97 spreadsheet, I get the
error below :
Renamed invalid sheet name
The new sheet name is then "Recovered_Sheet1
Pivot table experts: using sums instead of counts in repeated columns10 Feb 2006 22:11 GMT1
Pivot table experts, I can't seem to make this work.
First field is dragged to "row fields" and correctly becomes my first
column.
Second and subsequent fields are the same kind of field and are supposed to
External reference with variable workbook name?10 Feb 2006 21:48 GMT4
I'm referencing an external workbook and need part of the workbook name to
be a variable.  My base formula is;  [55421GNTForms.xls]SBR'!$C$5
I need "55421" to be a variable, with the new information pulled from a cell
within the referencing workbook.  (55421 is a name, not a ...
Latest Modification Date Automatically Printed10 Feb 2006 19:56 GMT1
I am new to Excel and I have a pretty elementary question that I could
not find an answer for.  I want to indicate on the Excel spreadsheet
when it prints out the last date I have modified the spreadsheet.  I
would like to have that printed out automatically, without my having to ...
Excel 2000 large files losing formulars...10 Feb 2006 19:44 GMT9
Ok, this is a serious issue. In our accounting department we're using Excel
2000, but on some files (25k -63k) from time to time it would lose the
formulas or we'd get an error when we try to save, "not enough memory"
We're on Win2K, 1GB memory. But, does anyone know how to ...
FIND and REPLACE characters needed10 Feb 2006 19:09 GMT2
What characters (~, #, ?) do I use to Find and Replace item cells of first
following row with second row below?
FIND these types, eg:  =(DSUM(DIVOH,$CX$1,$DG$2:$DG$20)
Replace with these types, eg:
Simple Stock Control Sheet10 Feb 2006 18:33 GMT1
Im Trying To Write A Simple Sheet That Basicly Lists All The Components
In Stock With There Quantities, And Then Have A Cell Dedicated To
Selecting A Component And Entering A Quantity That Has Been Removed
From The Total Individual Amount.i.e
 
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.