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 / January 2009

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can't get update to work31 Jan 2009 22:40 GMT7
I am running Windows XP Home, and recently updated to SP3. The Windows
updater is now trying to install the following update:
Security Update for Microsoft Office Excel 2003 (KB951548)
However, every time it tries, I just get the message, "Some updates could
Field list in Pivot tables31 Jan 2009 22:07 GMT7
I have a problem with the field lists. I have a field for Year. How
can I update the field list to include new year like 2009? Please
help, Thanks
How to automatically populate a cell?31 Jan 2009 21:02 GMT4
Is there a way to automatically populate a cell with the same data that is
entered into a different cell?
Say for example I have a 20 column wide spreadsheet. When I enter data into
the cell at row 1, column 'A', I want that data to automatically be entered
Smaller left indent ?31 Jan 2009 18:23 GMT3
When aligning text within a cell, a left indent of 1 is too large.  In fact,
it is often the equivalent of two character in the font of the cell.  Is
there anyway to specify and indent of 1/2 a character or some other way to
reduce the left margin?
Different colors within on cell.31 Jan 2009 17:01 GMT3
1 ; 45 ; 0
I want to change the color of each of the above numbers to bold green, 1,
then bold black 45 and finally bold blue 0. Each number in the one cell is
from the following formula: =TEXT(C4,0)&" ; "&TEXT(D4,0)&" ; "&TEXT(E4,0)
If percentage is 10% when y or 0% when n31 Jan 2009 14:47 GMT6
I am trying to apply 10%tax when tax needs to be applied (i.e. when next to
the item I have placed a y. If there is no tax to be added, (i.e. displayed
by an n, then I want it to display 0%. I have placed the 10% tax amount in a
cell on it's own, in this case B2,
grid lines31 Jan 2009 13:18 GMT3
i come tables from the net and paste them into Word to format -- removing
certain columns.  when i paste the tables into excel, i get white spaces in
the excel sheet around the information i've pasted in.  no matter what i do,
i cannot get the original excel grid lines back on ...
How do i add data to the side of a line gragh31 Jan 2009 12:35 GMT1
I cant figure out how to add the data to the side of the graph.
Filtering problem31 Jan 2009 06:17 GMT2
I have run into filtering problem I could use some help with. (using Excel
2003)
I have 3 columns of data with about 40,000 rows. Based on a condition of one
cell in the rows, a value of Yes or No is set in another column. (there are
Adding a Percentage to a Number (EXCEL 2003)31 Jan 2009 05:56 GMT2
I think I did not explain myself very welll in my first question.
I want to add a percentage like 10% to number in column A1
I want to show the total in column A4 - however the formula shows in the A4
field everytime I put my curser over it.  I want to hide the formula and show
Range referencing in VLOOKUP function, string concatenate?31 Jan 2009 05:36 GMT4
I am attempting to perform a vlookup in an array, located among a
group of 21 other arrays.  So, each array has a name beside it, but
the arrays all contain Similar, and sometimes identical data.  I first
use a MATCH function to find the name and its location on the
how to automatically populate a cell?31 Jan 2009 03:50 GMT1
Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'.
When I enter data into the cell at row 1 / column 'A', is there a way to
have that data automatically populate the cell at row 1 / column 'T'?
And if it can be done with cells, can it also be done with entire rows and
Bug in Excel handling exponents31 Jan 2009 01:44 GMT7
If I type -10^6 in a cell, the resulting number is 1,000,000. However,
shouldn't the exponent take precedence over the sign? Specifically,
shouldn't the result be -1,000,000?
Minus Zero31 Jan 2009 01:32 GMT11
I'm probably missing something obvious, but I have a worksheet where some
cells are formatted for currency to two decimal places, with negative
numbers showing in red with a leading 'minus' sign.
The problem I have is that when the result is zero, the number is displayed
I need to show the last number in a rows in the total pending row30 Jan 2009 22:30 GMT2
I have a column where I list pending cases each month and I need to show the
last number in the total pending cell at the bottom of the row. I can use an
offset fomula which works if the pending cases begin in row 1. However, I am
not able to get it to work if the pending cases ...
 
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.