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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
find a value in a table21 Sep 2007 17:58 GMT1
i have a table full of numbers. let's say it's 1000 by 1000.  I want
to see if this table has a set of specific values, say 100 i want to
check for.
rather than doing ctrl-f and find each of these 100 numbers, there
Column styles doesn't appear on the worksheet21 Sep 2007 15:42 GMT1
one of my customers has changed the windows xp designs to its own. From this
moment excel doesn't show the font color and the background color of a cell
in the worksheet. Only in the print preview you can see the color settings of
the cells.
text and date concatenation21 Sep 2007 13:43 GMT1
I'm using the following formula to concatenate some text and a date
into a single cell
=Concatenate("End Date for the period is; ", Data!W2)   where cell W2
on the data sheet is the date I want to use.    Unfortunately the
Next occuance21 Sep 2007 13:24 GMT4
I am trying to create a spreadsheet list of client birthdays.  I need a col
titled Date of Birth (this is obviously just data entry).  The next col
needs to be Next Birthday and then one for age.  I have the calculation
formula done for the age col.  Is there an easy way to ...
2 excel programs21 Sep 2007 08:46 GMT4
I have Excel 2003 and lately installed Excel 2007. When clicking on an Excel
file it opens it using Excel 2007.
I need the files to be oppened in Excel 2003 when double clicking the file.
How can this be done.
Linking Option Buttons to Cells21 Sep 2007 08:22 GMT2
I am develping qa questionnaire with something like 120 rows in it. Each row
has 7 possible responses in it. Each response has an options button/check box
associated with it (In don't mind which), but only 1 button can be selected
from each row. The questionnaire therfore has ...
Update Graph Data Automatically21 Sep 2007 02:22 GMT2
I have a sheet with data and graphs - e.g. below shows one set of data -  of
the last 14 fortnights
14-Mar    28-Mar    11-Apr    25-Apr    9-May  etc..............
4    6    5    2    6
Opening XLS with XL2003, not XL200721 Sep 2007 01:34 GMT2
I have both Excel 2003 and Excel 2007 installed on the same machine.
Until today, I could doubleclick on any .XLS file and it would
automatically open in the old Excel.  Now, however, it opens in the
new Excel in compatibility mode.
delete row of same colors21 Sep 2007 00:50 GMT1
I have an excel file of 100 names and address, etc. I have color coded some
of the row in red. I want to delete all of the colored rows. it is the entire
row that is colored not the text.
new to using pivot tables and excel21 Sep 2007 00:06 GMT6
I am new to using pivot tables in excel 2003. Right now I need to change
some pivot tables.The person who setup the pivot tables at my company no
longer works for the small  company I am working at.
 Right now the pivot table I want to change, is intended to have a blank
Counting only uppercase letters with wildcard in column/row20 Sep 2007 23:52 GMT6
I'm working with columns and/or rows containing both upper and lower case
letters with wildcards. I only want to count upper case letters with
wildcards. Any help to this problem will be greatly appreciated. BTW I'm
using excel 2007. Thanks!
Can I select multiple rows from a data range?20 Sep 2007 23:41 GMT3
I'm trying to add a feature to someone's Excel spreadsheet where they can
print a list of owned items based on a user id. In "real life", I'd be
looking at a database to do this, but it's a non-profit organization staffed
by volunteers, so you take what you get as far as ...
Forms20 Sep 2007 23:28 GMT6
How do I make a form where I can type on top of a line?  I don't want to type
the text and then underline it, I actually want to type on top of the line
where the lines stay static.  Can this be done?
Thanks
Cut and paste issue20 Sep 2007 22:20 GMT3
I've distilled a previous problem that I posted down to something very
simple, however I still can't figure it out!!!  Here's the deal...
In any cell, type in this....
Line 1 <then hit alt-Enter to do a carriage return>
Get rid of FALSE in cell?20 Sep 2007 20:42 GMT3
How do we get rid of the FALSE in a cell, pls?  The cell in question, N2,
has this formula in it:
=IF(K3<>"",IF(M2=0,"OKAY","RE-CHECK"))
When K3 is empty, I get a FALSE rather than just a blank cell.
 
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.