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
Excel: cells prepare to copy how I remove it23 Aug 2007 16:30 GMT3
When I select cells to copy with:    
Selection.Copy
What I must do to remove this selection?
I think it's easy but I cannot find how I remove this selection.
Display issues23 Aug 2007 16:29 GMT4
Ok, I've set up multiple work sheets in a work book and have referenced cells
from, we'll call it worksheet 1, on worksheet three.  I have them showing up
in the cell, however I am referencing three different cells from worksheet 1
into one cell in worksheet three and I am not ...
Validation note to comment note23 Aug 2007 16:27 GMT1
Is there a way to copy validation notes to a comment.
When you right click a high lightd text it doesn't give you a copy option
oldjay
Format Control dialog box  control tab23 Aug 2007 16:26 GMT1
I can not get the Control tab in the Format Control dialog box of a combo
box. How do I get my missing Control tab?
How to write/Remove some text (Like Page Number/ Confidential) @ s23 Aug 2007 16:16 GMT3
Hi,  
As  mentioned in subject.... I have to remove from one of my worksheets the
text Page 1 ,Page 2 etc... which are appearing in background over the content
in the sheet.
calculation23 Aug 2007 16:09 GMT6
Hi there,
Sometimes the formula in the cell dissapears eg
=890/1000
I get 0.89 instead. but I would like to see the formula so I can refer to in
Type in one cell and data copies into another cell23 Aug 2007 16:02 GMT2
I have two worksheets that will be holding the same information, but in a
different order.  I would like to be able to type the data into worksheet1
next a specific heading and on worksheet2 it copies next to the same heading
(although its on a different row).  Hope ya can help!
nested ifs not enough23 Aug 2007 15:58 GMT1
I have results in random days. This next formula works perfectly when i have
a maximum "hole" of  7 days. The problem is when i have gaps of more than 7
days.
E157=IF(D157=0;"";IF(D157-D156<D157;D157-D156;IF(D157-D155<D157;D157-D155;SE(D157-D154<D157;D157-D154;IF(D157-D153<D157 ...
Macro23 Aug 2007 15:42 GMT3
I have a workbook with two worksheets.
Worksheet 01 is the summary
Worksheet 02 is the form template.
I have a form button on Worksheet 02, I have tried to record a macro for the
Validation list boxes not working23 Aug 2007 15:22 GMT1
I have been setting up a spreadsheet using validation list boxes and for some
reason the validation is being set up but it does not give you usual dropdown
list. It was working first of all, but I have since set up check boxes and a
combobutton and now my validation boxes do not ...
List of numbers seperated by a colon23 Aug 2007 15:07 GMT8
I would like to transpose a vertical range of cells into a single cell so
that each number is seperated by a colon.  Here is an example:
    A    B    C
1   50        50:45:30
standard deviation23 Aug 2007 15:06 GMT2
i don't know how to find standard deviation for grouped data. this is for my
add maths project. pls help me. explain to me step-by-step coz i really don't
have a clue how to find it using excel. thnx.
Alternate selection methof for many tabs23 Aug 2007 15:03 GMT8
I have a workbook that will have about 30 or so sheets.  Using that
little scroll bar to choose various worksheets within is a pain in the but.
1) Is there a way to sort these tabs alphabetically and automatically?
2) Is there any way to pull up a list of them where one can be ...
FORMULA HELP any body23 Aug 2007 14:40 GMT4
I have the data with sales volumes of each customerwise for a financial
year. I have designed a format that is having three excel sheets. In
"sheet1", i have created a button and in that all months (i.e., apr-2007,
may-2007, like wise upto mar-2008)
Anniversary of a date23 Aug 2007 14:38 GMT4
Hi - I need a formula that will return the date of this years anniversary of
a date in the past.  My data is set out as follows:
      a               b                   c  
1  B Smith      25/10/02       25/10/07
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.