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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
The active AutoFilter changes property cells (color)?14 Apr 2006 06:30 GMT2
Please, help me with Excel.
There is the autofilter (AF) be established on the sheet in 100
columns.
It is possible to make on VBA that at use AF a cell in which the
tab bar orientation14 Apr 2006 04:59 GMT1
Is it possible to display the worksheet tabs along the left or right
(preferable) margins much like the tabs in a 3 ring binder rather than along
the bottom?
Help with Addresses13 Apr 2006 22:54 GMT8
Is this possible and if so how do I go about it.  I am typing addresses
into fields in excel and I was wondering if I could get excel to fill
in the zip code cell once the town cell was typed in??   Somewhere I
would tell it what town goes to what zip code??
Moving Chart x Axis13 Apr 2006 22:41 GMT1
How do I move the x axis of a chart?
Right now, the chart I am working on has the x axis in the middle of the
chart.
I would like it at the bottom of the chart.
Excel 2003 crashes when trying ti open a file from the lookdown me13 Apr 2006 21:51 GMT1
Excel opens with no problem but, click on 'File\open' the program hangs.
Highlighted13 Apr 2006 21:31 GMT5
I would like to create a new sheet from an existing sheet,  but I only want
to see the highlighted rows.
Is this possible?
Thank you.
Grouping In Pivot Tables13 Apr 2006 21:18 GMT5
I have a pivot table linked direct to an access query. In the pivot table I
have grouped the date field by year & month and set the start date as 1 Apr
2005 and end date as 31 Mar 2006. Some of the months have no data so I set
the field settings to 'include items with no data' ...
Accounting format13 Apr 2006 21:14 GMT4
I have completed a spreadsheet in accounting format.  For transaction that
need to be deducted I have entered an '-' thinking that it would be
subtracted in the total which is the sum of all the rows, however this does
not happen - Double the number is deducted. Does anybody know ...
Array Function Question13 Apr 2006 21:09 GMT1
I have little knowledge of Array Function.  I'm updating a spreadsheet
developed by someone else. One array formula trying to lookup data in another
spreadsheet looks like below:
{=SUM(IF([Data]Data!$A$3:$A$70>=DATEVALUE("01/01/2006"),IF(Data]Data!$A$3 ...
Conditional read-only13 Apr 2006 20:05 GMT2
I have a data entry spreadsheet.
I want to set the conditional formatting of a series of cells (target
cells), such that if a value is entered in a specific cell, no data
entry is allowed in the target cells.  Any suggestions?
Help: AutoFilter not 'hiding' data from other formulas13 Apr 2006 19:29 GMT6
I'm using AutoFilter on a columns of personal data for which I've set
up other calculations (averages, percentiles, etc). I was hoping that
if I filtered, say, just for women, then the other calcualtions would
reflect only the women's data, but they still seem to reflect the whole
Data Validation from a List13 Apr 2006 19:07 GMT4
I am building a xls sheet for client data entry.
For one of the fields, there are a series of choices for which I have
a named range in a different sheet.  However, I wish the clients to be
able to enter ANY value OR the ones from the list..how do I accomplish
Auto Filter13 Apr 2006 18:49 GMT4
In some xls files, when I filter using the auto filter feature, in the
lower right hand of the screen I get a message 2 of 300 records (for
example)
In other xls files, I do not get this message when I apply auto
how do I change the text size of a form check box13 Apr 2006 17:28 GMT1
I am making a large form and I need to know if there is a way to modify the
size of text in the check boxes
Cannot get a simple stock price13 Apr 2006 16:45 GMT2
I have a simple spreadsheet in Excel 2002/XP.
Column B is a group of stock ticker symbols.
I would like (each time I open the spreadsheet) to have Excel put the
current (last) price for each of the stocks in column B into another column
 
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.