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 / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
increase data with cursor on cell bottom right corner21 May 2007 20:14 GMT2
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to perform
such operation.
Pls give a hand.
Macro (or equivalent) to display certain pivot table data21 May 2007 19:40 GMT8
Here's the situation. It's hard to imagine without seeing the whole sheet,
but here goes.
Assume someone enters a product number (e.g., 1438) into cell A1. Let's say
I have a pivot table about 30 rows down that lists all the sales data YTD
Dynamic number formatting21 May 2007 19:27 GMT2
Costs in my sheet could be in a wide range of different currencies. The ideal
visual outcome would be to associate the appropriate currency symbol to each
cost number. The currency information is dynalically generate in a cell
inside the working sheet. As an example, if Euro is ...
The column name on Excel are numbers instead of letters21 May 2007 18:59 GMT1
Right now for some reason, I have numbers for both rows and columns' names. I
would like to go back to the original setting of having letters as columns'
names. Can anyone help? Thanks!
auto-expansion of excel cells, turning it off21 May 2007 18:55 GMT2
I regularly paste text into the content bar in Excel 2003 that contain
several lines of text--enough to cause word wrap to trigger and such.
I like the word wrap, but I dislike that the cell expands to display all the
content.
Data Validation/Forms Combo Box21 May 2007 18:49 GMT5
I have created a worksheet that works splendidly involving Data Validation
Drop Downs (DDVD).  There are many formulas in this workbook.  All was well
until my boss told me that he prefers "the little hand instead of having to
click on the cell to select the item he wants."  ...
How to sum more then 31 worksheets  cell21 May 2007 18:45 GMT3
My one Excel file have 31 worksheet i want Cell A1 data of all 31worksheet in
one worksheet with sum furmula (Summery worksheet) sum of all 31 worksheet
cell A1 data in my summrey cell. i know only with + Exp
=SUM('(1)'!B5+'(2)'!B5+'(3)'!B5+'(4)'!B5+'(5)'!B5+'(6)'!B5) till 31 ...
Word has "compare documents" function, does Excel? Any way to do?21 May 2007 18:44 GMT2
In Word, you can pull up a file, click track changes, compare documents,
choose another file, and it will show you the differences between the two
very similar documents.  Does Excel have anything like that?  I looked at
"track changes", but compare documents was not an option.  ...
Absolute Reference Problem...21 May 2007 18:37 GMT5
Hi Every One,
I am using Excel-2007.
I used this formula in cell R15C15
                         =$R12$C10*$R13$C10
formula21 May 2007 18:31 GMT1
I have 2 workbooks, Weekly Totals and Monthly Totals.  I would like the sum
of each week in Weekly Totals (week 1, week 2, week 3, week 4, week 5) to
appear in the workbook Monthly Totals.  Some of the Weekly Total catagories
are $ amounts and some are #' of patients.  Does ...
Take me to the number21 May 2007 18:30 GMT1
I've used this formula to count the number of order numbers that
appear X number of  times in one column:
=SUM(IF(FREQUENCY(A1:A36533,A1:A36533)=X,1))
There is one order number that appears 6 times in column A and I need
Can I use an IF statement to show a picture?21 May 2007 18:21 GMT3
I am using the following IF statement to show the % increase in costs,
only if it is 10% or higher than the running average. If not the cell
stays blank.
=IF(AND(J11>10%,J11<>""),J11,"")
Date/Time parsing and calculation21 May 2007 17:59 GMT8
I'm struggling with this one and would appreciate some help please. I
have a Start Time fixed in C3, 10:20, in Custom format hh:mm. IOW,
getting on for half past ten in the morning. In the body of the
worksheet I have
How to send worksheet so indicator will show with comments21 May 2007 17:49 GMT1
I am trying to email a worksheet that has comments.  The indicator shows on
my worksheet, but when I email the indicator is just numbers of comments
listed.  How do I send with the indicator?
bluetooth - Broadcom21 May 2007 17:34 GMT4
does somebody know how to solve the following problem (which causes EXCEL 2007 to crash very often) ?; it has something to do with a bluetooth-add-in in EXCEL (sorry, I ony have the text in Dutch) :
           Probleem veroorzaakt door Btsendto_office.dll.
 Dit probleem is ...
 
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.