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 / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Copying a formula question03 Nov 2006 19:54 GMT3
I am a novice Excel user and have a formula I would like to copy to
more than 100 cells in a column. I am hoping there is an easy way to
do this without entering it many times. The pattern of the formulas
are outlined below:
Stop excel from copying data from one sheet to another03 Nov 2006 19:53 GMT1
I have a workbook (actually 75 workbooks) and it has ten worksheets. In each
sheet I have a subtotal at the end of each row (34 in all) and at the bottom
of each column (25 in all)  I have copied this formula onto each sheet.  The
problem I am having is that in the blank cells ...
Auto formatting .CSV import data03 Nov 2006 19:19 GMT4
I'm a database programmer and I'm trying to parse out a sets of data to our
sales force.  They are all pretty proficient in Excel and what I've been
able to do at this point is create a .CSV file, email it to them and they
can open the data without any problems.  What I'd like to ...
Text Formatting within a cell03 Nov 2006 18:33 GMT2
I know there is a way, I've seen it before I just can't figure it out
or find it online. How in the world would I go about formatting a range
of cells to make all text within that cell proper. I am not talking
about the function "PROPER" but I need the same thing accomplished
Need IDEAs For hidding data03 Nov 2006 18:02 GMT1
I've had a request for a simple spreadsheet that will allow my company to
display the name and a few other bits of information on electrical items and
then they need to be able to access additional information if that is what
they are looking for. I've seen a spreadsheet with the ...
Need help formatting a cell.03 Nov 2006 17:08 GMT2
Can such a request be done using Excel?
I need to enter a time in Cell B18 of 2325 or 11:25pm
from that time i need it to calculate that cell
B17 is 15 minutes prior to B18 (2310 or 11:10pm)
Need solution for SendTo: Mail Recipient03 Nov 2006 10:52 GMT9
I have developed a small tool to aid our salespeople in preparing sales
proposals. One feature is a button they click that sends all of the
details of the proposal to an expert in our firm for approval and so
that he can keep tabs on everyone's activities and catch any errors.
Running out of room in Microsofts Checkbook Register03 Nov 2006 09:49 GMT3
I downloaded the checkbook register1 template from Microsoft and am now out
of space to add anything else.  I have tried to drag the columns and rows
down bur nothing happens.  In the Excel spreadsheet I made this works to
extend the form but it will not in the one made by ...
2 questions regarding count formula03 Nov 2006 05:44 GMT8
If I have the following data
          A                            B                    C
1    Personnel     group type       p't number
2    Melinda           1                   4
Checking for Dupes03 Nov 2006 03:43 GMT4
I am entering data to column B, a 5-digit number.  Is there a formula
that I can put in column D that will tell me if the number is a
duplicate.  The numbers batch numbers from the accounting system.
There should be only one.  But since I am entering the batchs with them
Check colume if it is not blank03 Nov 2006 03:16 GMT3
I want to check another columes if one of columes are not blank.
For example, I need to check B2,C2,D2,E2 & F2. If B2 is not blank, then A2
will show "1". If D2 & F2 is not blank, it will show "3" in A2.
Thats mean A2 need to show the first item which is not blank.
Multiple Entries from Validated Data03 Nov 2006 01:22 GMT1
On an excel spreadsheet that I have, I have a column which I want
locked so only validated data can be placed in the cells.  However,
there are multiple acceptable choices (ie column 1 could include choice
a and choice c).  Is there any way to allow for this?
CSV files03 Nov 2006 01:16 GMT1
I try to open .CSV files from excel but they open in a single column.
Help
Tks,
Gaby
Elegant way to restrict data entry to list of values03 Nov 2006 00:54 GMT2
I need to provide a way to restrict data entry on a large range.
For example, I need the first 100 rows of column 1 to only provide
'yes, no' as possible entry values. The first 100 rows of column 2 to
provide 'yes, no, maybe'; the first 100 rows of column 3 to provide
Getting rid of the grid02 Nov 2006 23:16 GMT4
I have finished a spreadsheet and I would like to make it look a little
slicker. If there any way to remove the cell edges so It is just white.
 
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.