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 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Format excel sheet where one row is silver and the next white ???16 Dec 2004 21:46 GMT5
I have an excel sheet where it is formatted that one row has a silver
background
and the next has a white background ....
How is it done ????
Newbie question16 Dec 2004 21:30 GMT5
Please help, I'm a total Excel newbie. I need to create a spreadsheet that
works pretty much like a checkbook register. I need to be able to make daily
entries of deposits and withdrawals (dollar amounts) and keep a running
balance. I don't want the balance column to extend all ...
Moving cursor to next open cell16 Dec 2004 21:00 GMT3
What command do I need to type to move the cursor one cell down?  I have
created a macro that copies an entire line of data to a spreadsheet by going
to a specific column, using the end and down commands, to find the first
empty cell.  My problem is that after I have recorded the ...
Averaging columns16 Dec 2004 20:15 GMT3
I made a spreadsheet where data can be entered into 8 columns.  In eac
column for each day, this data has a formula run on i
(=(E16-E$15)/E$15, for example).  Then sum of these calculations ar
taken and averaged (=SUM(C17:J17)/8).  The problem is, towards th
Splitting a Cell16 Dec 2004 18:46 GMT2
I have a Cell that contains first and last name data.  I would like to
split this one cell into two cells, one with first name data and one
with last name data.  I have tried doing this through a Macro, but with
no sucess.  Can anyone point me in the right direction?  Thank you!
???: Freezing data at a set time16 Dec 2004 18:20 GMT2
I am ingesting real-time temperature data into excel.  I want to know what
the temperature was at certain times of the day.
How do I get the computer to save the temperature every hour but also keep
importing and monitoring the current temperature ?
Securing Workbooks16 Dec 2004 18:03 GMT1
Gang:
I would like to secure my Excel 97 (and Excel 2000) workbook from users in
such a way that they can only enter values in a specific range and view the
results in another range.  I'd like to keep my formulas and other sheets
VB Scripting/Macro - Filling/Editing Worksheet References16 Dec 2004 17:55 GMT2
Question:
What VB code will allow me to rewrite just the worksheet reference in a
function/cell reference. For example it says
=January!$AH40
how to stop program in a big loop16 Dec 2004 16:17 GMT3
Hi, everyone
    Right now I wanna do a time-comsuming loop in excel programming, for
example:
for i = 0 to 100000
Hide too long text in a cell16 Dec 2004 16:17 GMT2
How can I hide the part of the text that is too long for the cell? This
automaticly happens when in the cell on the right is already a text. But I
want this also when there is no text in the neighbouring cell. (Note: I don't
want to use wrap text)
Using on one list derive from another16 Dec 2004 06:26 GMT5
I need to write a formula to operate on numeric values from column B in the
contiguous range of all rows where column A has a specific string value.  
Column A is sorted on that string value, ascending.  I'm using Excel from
Office Pro 2000.
time-sheet record with over 24 hours16 Dec 2004 06:24 GMT2
I want ot create a time sheet for my employees where I can have the first  
column be the start time, and the second be the end time, with the ability to
start at 10pm and finish the shift at 8am, which is over the 24 hour mark.  
Then have the hours totalled in the third column, ...
Making sound with Excel16 Dec 2004 06:06 GMT2
Can Excel make sound ?
I am ingesting real-time data into excel.  When certain criteria are met, I
want the computer to ring an alarm or play a sound file.
How can I do this?
Calculation order16 Dec 2004 05:36 GMT2
What order do calculations calculate in?
Are the first calculations created in the worksheet always calculated first?
If the calculations are in row 1, are they calculated from left to right?
If the calculations are in column 1, are they calculated from top to bottom?
Fix the order of the last name and first name16 Dec 2004 05:29 GMT8
How do I fix the order of the names, when the last name is first and the
first name is second, separated by a comma.
 
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.