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
Conditional Formatting across many cells with a mobile comparison27 Sep 2006 06:37 GMT2
My description was probably more confusion than helpful but here we go...
C4 has a hard coded value in it.
The range C8:V8 has values created due to a formula (say something like D8
has =SUM(C8,D7) and E8 has =SUM(D8,E7).
Print Page Numbers27 Sep 2006 06:15 GMT2
Is it possible to create a formula that returns the page number relating to a
particular cell?
For example, I have a print range set up that has multiple pages and I would
like to determine what page number a particlar cell, say "F123", will appear
Formatting a Cell as "Time"27 Sep 2006 06:15 GMT2
Hi...
I'd like to format a cell as "Time". I want to use the 24 hour Timing
system, but  When  I enter the time: 24:00, I don't want it to apear like
this: 0:00. Is there any possible way to do this.
Would I use an "If and" statement?27 Sep 2006 04:36 GMT2
I have a table as shown.  
Column A             Column B
                                    Y
????                               Y
Getting the sum of the same cell in defferent exel sheets.27 Sep 2006 03:54 GMT2
I am working on a big excel sheet, and I am kinda new at it. How can I get a
sum of the values on 45 different excel sheets? I can only get the sum of
about 15 sheets for so before it says that my formulat is too long. Here is
an example of the formula: =SUM('Service Invoice ...
Pivot Table - Drill down to source and update27 Sep 2006 03:50 GMT1
Is there a way to drill down on a cell of a pivot table and update or change
the underlying source data from the pivot report? I'm afraid that the users
will have too much trouble understanding the data in a matrix or table format.
The Pivot Table report is being used as a budget ...
Data Entry problem27 Sep 2006 03:35 GMT2
When I try to type in "1:500" without any formula in it plain text  excel
return a value of "0.388888889". Why is that and what is the colon mean. I
try to work it out i got no clue how excel got that value.
Thanks in advance
Data entry27 Sep 2006 02:47 GMT3
When my boss tries to type a quotation mark, it does not appear nor does the
cursor advance until you press the spacebar.  How can I correct this?
Under Page Setup the page option of Ledger - for Office XP27 Sep 2006 02:46 GMT2
Have someone using Excel 2002, needs to print an Excel file on Ledger size
paper.  However, they do not have this choice under page setup.  Reinstalled
Office using complete install - did not add this feature.  Installed SP3 for
Office XP, and all the updates - still no Ledger ...
excel generated polynomial equation is wrong27 Sep 2006 02:45 GMT9
fitting a trendline to data and the polynomial equation it spits out is
obviously wrong.  Any ideas?  thanks
How can I do a mail merge w/ Excel contacts into a Word document?27 Sep 2006 02:45 GMT1
I have 200 contacts in an excel spreadsheet.  I want to type a letter in Word
so that each letter will be written to a different contact.  Thanks in
advance for any suggestions.
where can i find  the auto fill options?27 Sep 2006 02:43 GMT1
plz tell me where can i find the atuo fill options and also where is the
toggle total row
thank you
Cannot remove read only attribute27 Sep 2006 00:37 GMT2
A frequently used .xls file suddenly could not be modified because it was
labelled 'read-only'.  The read only attribute can be removed but when the
file is closed and re-opened the read only has returned.  Data cannot be
saved to the original file on closing.  Can anyone please ...
Formula to count cells that contain a number & are not shaded26 Sep 2006 23:52 GMT2
I am trying to get Excel to count up blank (or non-shaded) cells, as well as
cells that contain a "1" in it.  Can someone please suggest a formula to do
that?  I really need it & an excel "guru" told me it could be done, but he
didn't remember how.  Any help would be greatly ...
COPY26 Sep 2006 23:38 GMT1
I would like extract the entire row of information from the received excel
spreadsheet into the non-compliance excel spreadsheet that meets the criteria
of "OLD", "0" "XL", "XC", "XR" or "VAC".  There are five columns that could
contain this information.  Please note that it is ...
 
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.