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 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to show 3% increase in hourly pay in each cell?27 Apr 2007 02:52 GMT2
want to be able to enter a hourly wage ie. $10.00 and when i enter $10.00 it
will automatically show the 3% increase added to the $10.00 showing $10.30.
thank you in advance.
Bookmarking Excel Files from within Excel27 Apr 2007 02:32 GMT3
I have a bunch of files that I frequently need to open from within Excel. Is
there a way to "bookmark" these files say by putting an icon for each file
on the Excel toolbar?
Seems like a very common need so I am hoping there is a solution.
Combine variable number of columns27 Apr 2007 01:54 GMT1
I have a single spreadsheet with a list of clients, addresses and their
product interests. This table will be used to drive a Mailmerge document. In
the document, I want to be able to refer to the products in which they
indicated an interest. The problem is that while one client ...
picture is not showing up in Excel27 Apr 2007 00:52 GMT1
I have a picture that is in an Excel worksheet. I can see the handles
and if I move the handles some, the picture will show up. However, it
will not show up in print preview at all or page break preview. I can
open the same file on another computer and it will show up fine.
How do I stop Excel from changing last digit in a number entry?26 Apr 2007 22:34 GMT1
Whenever I try to tpye in a line of 16 numbers in my Excel Spreadsheet, Excel
changes the last digit to a zero.  Anyone else have that problem?  If so, how
did you solve it?
Expand a Named Range in 200726 Apr 2007 22:08 GMT2
I'm actually an experienced user, but am now using Excel 2007 and can't find
how to expand my named range. It's been changed and I'm not able to find it
in the help section.
HELP!
Find missing item in series26 Apr 2007 22:01 GMT2
I have a spreadsheet showing the storage location of production tooling.
Locations are identified as A051, A052, A235, B543, C234.
The Series would be A001 through A200; B001 through B325, etc.
I need to be able to find an open slot - that is a number that isn't used.
#REF errrors using vlookup26 Apr 2007 21:02 GMT1
I'm getting #REF errors when using the vlookup function. It happens
everywhere! All of a sudden, vlookup just won't work.
Specifically, in cell Q2,  I used =vlookup(P2,$A$2:$A$1000,2) and got #REF.
The value in P2 is the same as the value in A2.
How to split up the data in one column26 Apr 2007 19:56 GMT2
I have a long list of full names, Spanish names at that, that need to be
separated into First Name and Last Name columns.
Sometimes, there are 2 or 3 or 4 words to the names so the first thing I
really need to do is figure out how to sort these so that all the names with
HELP!26 Apr 2007 19:12 GMT1
I am working in a document where I need to input data. I would like it to tab
from one cell to the next cell that needs data input. I looked at the change
the default tab order for controls on a form. I appears to be what I need,
however I do not know what they are talking about ...
Getting rid of selection26 Apr 2007 18:59 GMT7
How can I get rid of the selection rectangle? It seems that it's always
there, with a heavy black rectangle, or there's a light black rectangle
marking where it was.
I'm trying to get rid of it altogether, so I can capture an image of the
Sum of coloured cells in execel 200726 Apr 2007 18:10 GMT2
Please can anyone tell me if Excel 2007 has a function that will count the
number of coloured cells in a range,. I have a column with red, yellow and
blue coloured cells in it and I want to count the number of each colour.
Thanks
conditional cells26 Apr 2007 15:17 GMT3
We wish to make an employee timesheet with the condition that each required
cell must be completed prior to continuing to the next required cell.  For
example, a clients name must be typed in a cell before being able to type in
the date, and then the date must be typed in before ...
Help with Formula in excell 200726 Apr 2007 15:06 GMT2
I am using columns F3, H3 I3 and J3.  In column J3 my formula is =max(f3,h3)
which is what i need but I want a formula that if I3 has a value then J3
I3=max(f3,H3),I3_>0,blank)  but keep getting errors, I also tried 0 and none
where the word blank is in the previous formula.  Any ...
Excel 2003-Sp2 - Resize the formula box in the formula bar26 Apr 2007 14:23 GMT2
Resize annoying formula box, when e.g. Collumn A has very large text in
fields, and the formula field drowp down and covers the 1st row or more.
This were not an issue in Excel 2000 and in Excel 2007 you can hover the
mouse or use CTRL + SHIFT + U and choose number of lines / the ...
 
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.