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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
office2007 beta12 Sep 2006 20:08 GMT1
how can i get product key ?
Cursor moves after enter, when it should not12 Sep 2006 20:04 GMT2
Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for
"move cursor after enter". Normally this is fine, but I made a sheet with a
few protected cells and now it moves to the next unprotected cell, in
whatever direction is greyed out. I don't often protect ...
How to take a list of cells and sort them into a new list12 Sep 2006 19:48 GMT6
Let's say I have a list of 20 student numbers, unsorted, in cells A3:A22.
How, if possible, can I set up my worksheet so that it will automatically
take the values in that range of cells, sort them, and display them in cells
C3:C22 in sorted order?
Months12 Sep 2006 19:48 GMT1
Is there a way (formula or whatever) to have the 12 months instead of typing
them.
I used Jan in cell B2 and Feb in cell C2, selected both cells and then used
the mouse to copy them to the range D2:M2.
Speading up my Excel calculations.12 Sep 2006 19:29 GMT9
In a nutshell:  I am putting together a database.  I created a search
"grid" that allows the user to choose a name from a data validation
list.  After selecting a name, the grid (shows 4 locations across, and
the 12 months down) uses Sumproduct to count the number of units the
Microsoft Office 200312 Sep 2006 19:29 GMT2
When I try to open an Excel file, nothing responds and I end up having to doa
ctrl. alt. delete and get a message 'you chose to close a non responsive
programme'.
It cannot find excel.exe and when I try to re-install or repair Office it
Help Debug Complex Formula (SUMPRODUCT? SUMIF?)12 Sep 2006 19:16 GMT3
Folks,
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in
A cell appears "######". What's this?12 Sep 2006 17:21 GMT16
I write down a type, for example "55,000", which is by default a general
type. From the menu Format, Cells, Number  , I try to make it as an
accounting type(in dollars), I press ok and then my type "55,000" disappears
and appears a "#####" instead. What is this and how can I ...
Opening Excel files in Works12 Sep 2006 17:06 GMT1
Is it possible to open Excel files in microsoft Works?
operaciones con comentarios de celdas12 Sep 2006 16:33 GMT1
Hola a todos ::
estoy trabajando con unas con multitud de comentarios, y quisiera saber de
que forma puedo "jugar" con ellos mediante macros
las dos operaciones que necesito hacer ahora son
More lines in Product Pricing Calculator12 Sep 2006 16:24 GMT1
Hello I am new to this site and I am hoping someone can help me. I am trying
to put together a pricing calculator so my staff can easily do quotes for our
client, I currently work out everything manually. I need to put three or four
more costs into this calculator and I am ttally ...
Consolidate and Lookup12 Sep 2006 15:52 GMT1
I receive 8 reports monthly, 1 for each area, with the all the activity
for that period. I would like to consolidate the data into one total
sheet. I have a master sheet with all the specialties where I would
like to have all the totals show. The activity will be different each
How do I enter a date typing 040906 and have it appear 04/09/06? I12 Sep 2006 13:44 GMT3
I would like to format a cell so that I can just type in the numbers in a
date and have the cell display the date with the forward slashes added
automaticly!  Example type in only 040906 and have Excel display 04/09/2006
in the cell.
unable to open excel file12 Sep 2006 12:19 GMT5
I cannot open an excel file on  the network, an error occur that
"filename.xls cannot be accessed.The file may be read-only,or you may be
trying to access a read-only location.Or, the server the document is stored
on may not be responding"
Changing a Number in a Column Using Arrays?12 Sep 2006 10:28 GMT3
I am trying to change a number in the left column to the number in the
adjacent column.  My setup looks like this.
            Number to Change    Change to this Number
            182001                                     182000
 
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.