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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
One big column to lots of small columns01 Jul 2006 00:00 GMT7
Howdy Excel experts,
I have one big column of data, each chunk of values separated by a
space of blank cells.  I'd like to take all the data chunks and put
them each in their own column, beginning at the top of the worksheet.
Copy the "Title" Field from windows explorer to excel?30 Jun 2006 21:58 GMT1
Im trying to copy the "title" field along with the "filename" into
excel. Im able to copy the filename field via a batch file using the
Dir command, but it doesnt allow you to copy the other fields that are
in the explorer window. Is there a a way to do this?
Make a 'Print button'30 Jun 2006 21:57 GMT2
How would I make a cell into a 'print button' (radio button?)
I need to be able to mouseover and either click or press enter on
cell, and doing so would cause a range of other cells to be printed. S
cell A1 would be my button, click on it or hit enter once it wa
count the number of caracters in a cell30 Jun 2006 21:32 GMT2
How can I count the number of caracters including spaces in a microsoft excel
worksheet
Separated data in one column to multiple columns30 Jun 2006 21:00 GMT2
Howdy Excel experts,
I have one big column of data, each chunk of values separated by a
space of blank cells.  I'd like to take all the data chunks and put
them each in their own column, beginning at the top of the worksheet.
Import from scanned page into excel30 Jun 2006 20:49 GMT1
I have been asked to take a printed document that contains a list o
phone numbers, scan it, and import the list into excel. What is th
easiest way to do this?
Thanks,
0ffice 2003 Objects Shift?30 Jun 2006 20:47 GMT1
I just got office 2003, and I am noticing that when I have an arrow in
an excel file, that it sometimes shifts when I print it out.  It looks
fine on screen, but for some reason, it is in a different location when
i print?  Has anyone else experienced this?
Looking up corresponding entry in table?30 Jun 2006 20:25 GMT2
I am wondering if I can combine the MIN()/MAX() and *LOOKUP() functions
to perform the following task.  Suppose I have a table of data (2D) and
want to use the MIN()/MAX() functions to pick out the min and max
values in the Y-column respectively.  Furthermore, suppose I want to
Activating a Macro30 Jun 2006 19:46 GMT5
How do I activate this Macro?
Sub sigma_to_cell()
   Selection.Font.Name = "Symbol"
   Selection.Value = "S"
alias for the INDIRECT function30 Jun 2006 19:41 GMT10
Gang - I'm using the INDIRECT function lots of times in my cell formula
and it is taking up a lot of space.  Is there a way to assign an alias
"IND" e.g., to a function and use that in a cell reference instead of
the actual function name?
Formula for determining number of hours?30 Jun 2006 19:23 GMT1
Does anyone have a formula which would determine number of hours like for
9:00-12:30, or 1:30-3:00 etc. so that I could use result and multiply it
times number of days and have total hours? Guess it would involve conversion
to 24 hr clock?
This should be simple30 Jun 2006 18:41 GMT3
I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?
locking excel documents in a folder30 Jun 2006 17:49 GMT1
Is it possible to have a folder with numerous excel documents in it; that can
be accessed by anyone and modified by anyone, but No-one can remove them from
the folder?
Regards
Auto change formula in cells when source is changed30 Jun 2006 17:13 GMT5
Good day experts;
If specific cells have the same formula for example:
C1 = Product( A1;B1)
C16 = Product(A16;B16)
Change fill color after input automatically30 Jun 2006 15:37 GMT2
Do you have any suggustion for the following task.
I will make new entries to the excel list frequently. I hope that after I
input something in column A, the fill color of the entire row will change
automatically to indicate that it is a new enter. And before I close the
 
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.