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 / General Excel Questions / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Multiple selections30 Aug 2007 20:56 GMT3
Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?
Thanks
Sheet Background Color30 Aug 2007 20:46 GMT3
I've have a file in which the worksheet is completely colored in gray and no
gridlines showing.  There is no background color applied that I can find.  
The gray is exactly same color as the row and column identifier background
color.  How can I remove this color or change the ...
Zoomed in files30 Aug 2007 20:26 GMT3
Weird zoom/view issue.
We open any existing Excel file on one computer.
Sheet1 is at 75% zoom/view.
Sheet2 is at 100% zoom/view.
Possible to "Lock" border lines?30 Aug 2007 20:22 GMT2
Is it possible to "lock" cell border lines so that they are not erased or
modified when (for example) a pattern is cleared from the cell?
I'd like to set up a page with border lines, then lock the border lines so
that they are not effected by modifications to the cell - possible?
IF Formula not working30 Aug 2007 20:06 GMT12
On Sheet 1 have the following data
Column A                  Column B                  Column C                Column D
NEWPORT (COMM)                      LIVERPOOL              GATESHEAD (CAR)
NEWPORT (COMM)           
Excel 200030 Aug 2007 19:49 GMT3
I need the funtion to cube a number or the formula, what do I use?
How to merge monetary values from Excel to Word?30 Aug 2007 19:28 GMT7
I am trying to merge an excel worksheet to Word, but when I merge the
information, such as dollar amounts, i.e. 103,801,186, I lose the commas and
I have to go into each merge letter in Word and insert the commas.  Is there
a way to set this up in Excel so it will merge in true ...
Count if a cell has color shading30 Aug 2007 19:19 GMT2
Is there a way to count a cell if it has color shading? I have no
values in my cells, but they are either shaded a color or not. I only
want to count the cells that have color shading in the range I select.
Is this possible? I would rather not enter values or text in the cells
font and highlight standard colors30 Aug 2007 19:12 GMT1
My "standard" font color pallet changed to pastel colors.  I will go to a
page that I have worked on before and it's different. How do I fix this
problem? It happens  intermittently. It doesn't happen through out Excel
2003. I'm baffeled
Tally Survey Result in Excel30 Aug 2007 19:06 GMT1
I have a survey(in paper) that I need to tally in Excel. There are 22
questions and have a response of Poor to Excellent (1 to 5). I was thinking
of creating a spreasheet where:
                     Question 1  Question 2.... Question 22.
Looking to Expand on Text to Columns Macro30 Aug 2007 18:52 GMT2
Good Afternoon All,
I'm using a Text to Columns Macro and was just wondering how it can be
reconfigured to accommodate several workbook pages/tabs.
Right now, it can only used when you go to each specific tab with data (have
Macro for calculating30 Aug 2007 18:44 GMT3
please find below an example of the sheet that i'm working on:
ABC    -1,493,802.08
ABC    1,493,802.08
DEF    1,877,918.50
How do I stop email addresses from changing color, size?30 Aug 2007 18:41 GMT3
When I'm entering an email address into a cell in Excel, it changes the size
of the font and the color?  How do I stop this from happening.
Comparing data in columns30 Aug 2007 18:37 GMT6
Ok, so I understand conditional formatting basics, but this seems over my head.
I want to highlight the row of data if the following parameters are met
Col C (names) Col E (usernames)
If rowXCol C matches rowYCol C AND NOT rowxCol E matches rowyCol E then
Shorten a formula30 Aug 2007 18:34 GMT6
How can i shorten this?
IF(ISERROR(INDEX([NEAST2_1.XLW]Sheet1!$A$16:$A$25,MATCH(0,[NEAST2_1.XLW]Sheet1!$N$16:$N$25,0)))
IF(ISERROR(INDEX([NEAST2_1.XLW]Sheet1!$A$16:$A$25,MATCH(0-0.125,[NEAST2_1.XLW]Sheet1!$N$16:$N$25,0)))
IF(ISERROR(INDEX([NEAST2_1.XLW]Sheet1!$A$16:$A$25,MATCH(0+0 ...
 
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.