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 / April 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Hyperlinks Turning Them OFF!07 Apr 2004 04:31 GMT5
I have been unable to find out where and how to have excel turn off the Auto
hyperlink feature when web address and email address are typed into excel.
Any help would be appreciated in this matter...
Warning note in excrll 200007 Apr 2004 03:31 GMT2
Hi to All
I have in Excel 2000 (office 2000 Pro)
hyperlinks to WordPad files & mp3 files,
all of them in the same computer.
Variable column widths06 Apr 2004 23:22 GMT3
How can I change the column width for certain sections of my worksheet?
for example: i have three separate tables on a worksheet using the same
columns. I need two of the columns to have a different column width than
the first. please help!!
Saving Excel 2000 In RTF06 Apr 2004 23:20 GMT3
Does anyone know if there is a way to save Excel 2000 in a Rich Text Format?
Function to sort/order horizontally?06 Apr 2004 23:17 GMT2
I know I can select data and sort and order it vertically by row data.  But
can I select data and sort it into an order by columns?  I have lines charts
based on data that was dumped in kind of haphazardly.  The X-axis points are
set by the values in row 2 across each column - but ...
Nursing Scheduling workbook06 Apr 2004 22:49 GMT6
Hi - not sure if this is the best place to post this, but here goes.  I'm
using Excel 2000.  I have been asked by my wife, who has responsibility for
this, to look at a pre-existing workbook whose object is to schedule nurses
and technicians in a 70+ bed nursing facility, for ...
Newbie - help needed with lookup, please.06 Apr 2004 22:39 GMT7
Hi - help needed please.  I need a way to read a text string from one cell
(say Sheet1A1), find it in a list in another sheet (say Sheet2 A17), then
copy a numeric value from a cell alongside the found cell (Sheet2 B17, say)
into another cell on the first sheet (Sheet1B1, say).  If ...
Reinitialize a RANGE object in VBA06 Apr 2004 22:27 GMT1
Hi, again...now another question
I would like to write a function:
Public Function NetPV(CashFlows As Range, drate As Double, period As Integer) As Variant
All I need is the ability to change the contents of the Range array, CashFlows depending on the
Passing Cell values to a SQL statement06 Apr 2004 22:11 GMT3
I have set up a spreadsheet that uses excel's "Get external data"
feature to connect to a SQL database and run a querry. The problem is
that I need to get data for several different product codes. These
codes change from time to time but basically the querry looks like
Excel error: Permission to use object denied06 Apr 2004 20:58 GMT2
I have some new computers setup with Windows XP and Office 97.  When
go into Excel and open a spreadsheet, I get a Microsoft Visual Basi
error:Permission to use object denied.  The spreadsheet will not open.
The error happens with every spreadsheet I try to open on tha
Newspaper Columns06 Apr 2004 20:32 GMT5
I have a long list of data consisting of three narrow columns.  When I print
the sheet, I'd like to repeat the set of three columns a few times per page
(exactly like a telephone book) to prevent wasting paper.  Can't find how to
do this in the help index.  Any suggestions??  thanks ...
Fitting Line to Exponential Data06 Apr 2004 20:11 GMT3
I should be able to do this but can't figure it out in Excel.
I want to fit a line to some nonlinear data so I can project intermediate
points. I gather I need the LOGEST function for this but I'm not able to
make it work.
How can I insert an existing form into a spreadsheet06 Apr 2004 18:52 GMT1
I am using Excel 2002 SP2 on WinXP. I have a government form in pdf format
that I am required to fill out and submit each month. The data is summarised
in an excel spreadsheet and I copy the figures by hand to the form. How can
I insert the pdf form into the spreadsheet so that I ...
sorting/filtering a list into columns06 Apr 2004 17:10 GMT1
I'm nearing the end of a project (an email game) and i would like to
have the sheet keep scores.
So far, I have 2,3,4 players and these are represented by columns B,C
or B,C,D or B,C,D,E. (depending on which you select.) Player 1 takes
Macro help - formula showing #DIV/0!06 Apr 2004 16:37 GMT4
I've created a macro that inserts a formula in my current cell and then
formats the result. The macro looks like this:
   ActiveCell.FormulaR1C1 = "=COUNT(C[1])/COUNT(A:A)"
   ActiveCell.Select
 
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.