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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
merging workbooks06 Dec 2007 15:57 GMT3
Hello, I have Excel 2007
I have 3 workbooks that I want to merge into a single workbook, with each of
the originals on a different sheet. I know how to open a clean sheet, but
cannot find out how to import the original workbooks into them.
Deleting shortcut key In Recording new Macros dialog box06 Dec 2007 15:41 GMT1
I have recorded several new Macros and I am running out of shortcut key
letters to put into the shortcut key box within the Record a new Macro dialog
box.  How could I delete the shortcut keys that I have already used to reuse
again to record new Macros?
Compare and Highlight Rows06 Dec 2007 15:26 GMT12
I have an excel file with two worksheets.  is there a way to programatically
compare the two worksheets to find matches and highlight those matches on
each worksheet.
They both have the same columns.  
Read displayed, rather than raw, date06 Dec 2007 13:54 GMT8
I have a row of months which, for ease, I have allowed Excel to
interpret as dates. The month is displayed as e.g. "Dec-07" but the
'raw' data in the cell is e.g. "01/12/07". For reasons that are not
important here, I need to be able to perform conditional functions
Currency problem with SFr.06 Dec 2007 13:04 GMT2
Hi All,
odd problem this one. One of my users is updating an existing spreadsheet.
We use Office 2003 with SP3. He has a list of figures (5 off) all set to
different currency's, one of which is £ (british pound). However, all is fine
how to find data and list all of them in a cell.06 Dec 2007 13:03 GMT1
I have one database table like this.
==============================
Col_A         Col_B           Col_C    
name         room            cancel
count function06 Dec 2007 12:56 GMT1
How to count in Excel with 2 or more arguments
Somthing like this
=Countif (a2:a200 = "A" and B2:B200="B")
Please Advise
Date format in Indian style06 Dec 2007 12:46 GMT1
   I am trying to get the date format in Indian style... That is dd-mmm-yy. I am unable to set my excel to do that. It always asks me to enter mm-dd-yy. Kindly help
L Krishna Kumar
Get Excel to provide equation for my x and y06 Dec 2007 12:01 GMT2
I am doing an assignment on how hot water gets in degrees celcius when so
many kilojoules are supplied to it. i have a graph, with data provided to me
for this function. kilojoules is my y, and degrees celcius is my x. i need to
get excel to provide an equation that relates heat, ...
Date/Time entry06 Dec 2007 11:53 GMT4
Where a cell is formatted for date / time ( yyyy-mm-dd hh-mm) is there a
shortcut keystroke(s) that will insert system time in that cell.
Thanks in advance
teabag
CALCULATING DATES06 Dec 2007 11:40 GMT3
can anyone help me! i have created a gantt chart, but having the following
problem: column A contains qty of days, column B is start date, column C is
end date. i have set column C so that it adds column A + column B to give me
an end date, but if there is no start date, the end ...
Saving custom colours?06 Dec 2007 09:05 GMT3
When you choose a custom colour via Tools->Options->Color and make it
available in that particular workbook by modifying one of the standard
colours to the chosen colour - Is there any way of making those colour
modifications permanent so that those new colours are available in ...
xlodbc.xla - Excel ODBC Add-In - Where is it for Office 2003/2007?06 Dec 2007 05:40 GMT3
I am trying to run SQL queries directly from a worksheet in Excel.  I have
found an add-in for Excel 2002 that is no longer supported in 2003 or 2007
which is just what I want (xlodbc.xla).
1.  Why was this discontinued?
extract data from middle / right of string06 Dec 2007 04:39 GMT11
I have a column in a spreadsheet containing the following type of
string:
330189149967 Ideal - Series 2 (DVD) 3 12.99 GBP 38.97 GBP
I would like to extract the number after the (DVD) in this string.
excel opens but not the document06 Dec 2007 04:31 GMT2
i have a problem with excel 2003 - when i click on an excel document excel
opens but does not load the document  - i have to go to file >> open  to
open the document
any idea's would be appreciated
 
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.