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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Percentage of Count in Pivot14 Jun 2007 02:32 GMT3
I'm trying to get the percentage of a count of ID numbers in a Pivot
Table.
This is my Pivot;
Segment2 Description    (All)
Closing Excel 200714 Jun 2007 00:08 GMT9
When I click on the "close" button on Excel, why does Excel close just
the active window instead of exiting from Excel?  Now, even if I have
just one workbook open, I have to effectively close Excel twice.  Is
there a way to change this behavior?
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?13 Jun 2007 23:07 GMT1
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for
this?
Why is Excel renaming worksheets? Is there a fix for this?
I am seeing something very strange with some Office-2003 Excel spreadsheets
HLOOKUP problem...13 Jun 2007 22:58 GMT3
I'm having a problem getting HLOOKUP to work where my data is on another
sheet and the table array comes before the lookup value. For instance, on
sheet2 I have a list of names in column G and money amounts in column F. So
on sheet1 I coded: =HLOOKUP(Sheet2!"Bob Smith",F12:F20,1 ...
Formula Help, LOOKUP, INDEX...(?)13 Jun 2007 21:19 GMT1
Let me preface this by saying I have limited experience with formulas (and,
frankly, Excel).
I've got two workbooks - ONE logs in time spent on a task for each day of
the year, TWO is a weekly timesheet.
Adding contents of a cell as the worksheet reference in a formula13 Jun 2007 20:56 GMT4
Here's the dilemma:
In each cell of column 1of worksheet 1, I want a formula of the form:
='target worksheet tabname'!A1
In the cells of column 2 of worksheet 1, I have 'target worksheet
How to merge multiple worksheet data into one.13 Jun 2007 20:35 GMT2
I need to merge multiple worksheets in the same workbook. The headers
are same for all the worksheets. The worksheets contain each months
data now i want to merge them in one worksheet and get the entire
years data in one sheet. Each worksheet has auto filter enabled.
Repeat a macro13 Jun 2007 20:34 GMT4
I have a client using Excel 2000. They have a data sheet with over 9000
lines of information. She basically wants to find, say from column D, every
cell that contains the word "bearing" and copy that cell to another
worksheet. She has a macro that does the copying, but what she ...
Find maximum across multiple sheets13 Jun 2007 20:14 GMT1
I'm having alot of problems trying to summerize some data that I have
on multiple sheets. I have set up a sheet called Cases that has an
index of all the data sheets (i.e. 1, 2, ...) and would like to
iterate through this list and find the maximum values and report them
How to convert an Excel file to CSV File13 Jun 2007 19:10 GMT1
IS there anyway to convert an excel file into comma delimited file - I
used the Save as and CSV file format, but that didnt help much.
Any other options/ways we can do this.
Thanks,
What denotes a month in cell format?13 Jun 2007 18:25 GMT19
I have a list, 3,4,6,7,8,10,12. I want to apply a cell format which will
result in months, that is, March, April, June, July, August, October,
December. What should be specified? Thanks
Scroll bar in excel13 Jun 2007 18:21 GMT6
I don't use excel that much but I want to add a scroll bar to excel with a
list of items to pick.  I guess I use a scroll bar.  I've manged to add a
scroll bar but can't find how to add my list.  Do I have to use VBA or is it
simpler than that - can't find any help on help!!
FORGOTTEN PASSWORD PROTECTION13 Jun 2007 18:08 GMT2
I have forgotten my password for a excel file I created a while ago.  Is
there anyway I can find this out in the background somewhere?
Regards
Geeves1293
Excel Print All Tabs Macro?13 Jun 2007 17:53 GMT1
Can anyone help me with this newbie question:
I need a macro that prints all tabs in a given workbook.  Can anyone
provide me the code please?
Thanks,
Header & Footer - Font colour13 Jun 2007 17:06 GMT3
Can anyone advice how I change the font colour for footer text?  I'm wanting
to change it to grey so it's a little less obvious but can't figure out how
to do it.
Many thanks,
 
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.