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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Mail merge matching fields30 Aug 2007 18:32 GMT3
How do I increase print fields on mail merge labels
Filter data and fill only filtered data30 Aug 2007 18:26 GMT1
It is truly amazing what a terrible job microsoft did in putting together
Excel 2007.  What a complete disaster.  
Here is my problem:
I have filtered data that I want to flag as "Y" for example.  If I put the
Trailing Periods (Dot Leaders)30 Aug 2007 18:18 GMT5
Is there any way to add the trailing periods, dot leaders to cells that
contain text and in the next cell a dollar amount, I have someone requesting
it so that it is easier for them to see which amount corresponds to that
description.  If you manually insert them, you have to ...
filters and summing in status bar30 Aug 2007 18:11 GMT1
when i filter on anything, it doesn't show me the sum of the totals in the
status bar.  how do i get this to show me.
File Properties30 Aug 2007 18:06 GMT2
I have added file properties to an Excel file, and I can view them when the
file is open.  However, when I go through Explorer, the properties are not
visible?  Fix?
seeking help on how to automatically shift an average range as new data is added30 Aug 2007 17:59 GMT2
Cells b20 through m20 contain numerical values by month.  These cells
get their data from an external source; using code I gleaned from here
and elsewhere on the 'net this data will be automatically populated.
That is, today the cells for August 07 through March 08 (f20 - m20)
SUMIF and {multiple criteria}30 Aug 2007 17:53 GMT7
Can anyone help me to understand why this formula gives the correct
result:
=(SUMPRODUCT((Region="Asia")*(DECONS="Ontime")*(SPLIT={"E","W"}))
+SUMPRODUCT((Region="Asia")*(DECONS="Ontime from
Updated Cells in different workbooks30 Aug 2007 17:49 GMT4
Is it possible to update cell a1 in 7 different workbooks or files at
the same time?  Thanks.
From Excel 2000 to Excel 200330 Aug 2007 17:42 GMT3
Our office is just moving from Office 2000 - Office 2003.  Can someone give
me a quick idea of some of the major changes between Excel 2000 and 2003?  I
understand that there were some major changes to Excel in the 2002 version.  
I have also been able to find some articles with ...
How do I copy a worksheet for each day of the year?30 Aug 2007 17:40 GMT9
I'm trying to create a new sheet for each day of the year.  It needs to
contain the day and date but I really don't want to copy and paste 2 years of
forms and manually change the date.  Please can anybody help.
Preserve cell formatting as SSN30 Aug 2007 17:36 GMT2
I've got a couple cells formatted as Special, then Social Security Number.
When users enter the spreadsheet they are presented with a series of VBA
forms for data entry, and on one of them they input a SSN. The idea is to let
them enter the ssn with or without dashes, and have ...
Recent problem opening files with Excel 200330 Aug 2007 17:34 GMT2
When I double click a file or when I right click to open a file, the file
will not open. The only way I can open a file is by opening it through Excel.
I tried reinstalling Excel and Office as well as disabling Norton Security;
but to no avail.
How do I merge address information in Excel into Word?30 Aug 2007 17:34 GMT1
I am trying to take information in Excel that is split up in columns, such as
first, middle, and last name plus each field of their address and merge it
into word for printing on envelopes.  I have tried all that has been
suggested on this site and what I get is a bunch of boxes. ...
make backup excel30 Aug 2007 17:32 GMT2
I'd like to make a backup of an Excel file, but NOT in the same folder. I'd
like to make a true backup, not in the location of my original file but on
another physical drive.
So I don't mean the auto backup function which saves the backup in the same
zip code with mail merge30 Aug 2007 17:24 GMT4
the 1st zero gets dropped from zip codes when address spreadsheet is used for
mail merge.
 
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.