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 / March 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formulas returning a blank if no data entered in one cell31 Mar 2005 16:37 GMT3
Very new to all this! I want to set up cells showing a percentage
difference. I've figured out how to get it to do that but want to have a
blank cell if no data has been entered into one of the other cells i.e price
before increase = A, price after increase = B and C = % diff. If ...
How do I Set up a Invoice in Microsoft Office 2000 Professional (.31 Mar 2005 14:45 GMT1
How do I Set up a Invoice Formate Template in Microsoft Office 2000
Professional (Excel)
With detailed one (Rate, qty,Discount,Total,Tax)
Empty Pivot Field using a Macro31 Mar 2005 14:13 GMT1
although I tried a couple of options, I do not seem to sucseed in making a
macro which actualy empties the PivotField as I want to.
I tried:
   ActiveSheet.PivotTables("PivotTable3").PivotFields("Count of Uren"). _
Open Hyperlink without Confirmation Message?31 Mar 2005 13:17 GMT1
Excel 2003 insists on opening a "Microsoft Office" message box whenever a
hyperlink that opens an external file (.mpg in this case) is clicked:
"Opening xxxx.... some files can contain blah blah blah. Would you like to
open this file?"
How can get Microsoft Excel on to my p.c31 Mar 2005 12:05 GMT4
Could someone help me as i do not have a clue as what i need to do all i have
been told is that i need Excel to beable to do my spreadsheets.
HELP!!!
Counting the number of coloured cells31 Mar 2005 09:37 GMT2
I would love to be able to count the number of cells in a row that are
coloured yellow or the number of cells that are coloured green.
Is this possible?
Mat
Excel Database31 Mar 2005 09:22 GMT1
I have a database I need to split equally in half by selecting every other
lead.  Is there a quick way to Select the odd numbered rows(or even numbered
rows) of data(each row comprises one lead with it's info) cut those selected
rows and then paste them to a new workbook, and ...
Page numbering - multiple tabs31 Mar 2005 07:54 GMT6
I have a workbook that has three tabs.  I update the workbook throughout the
month, adding the previous day's data, analysis, and comments to what is
already there.  I print the entire workbook each day and distribute hard
copies throughout the organization.  I need to have all ...
Formatig cells31 Mar 2005 07:06 GMT2
I created 50 similar TextBoxes containing numbers  1 to 50 with certain
color.
I wan to assign macrs to each TexBox so that:
1-   copy the number inside the textbox to another cell (say D100)
MAXIMUM NUMBERS IN CELL31 Mar 2005 05:15 GMT1
When entering more than 15 numbers in a cell, Exel automatically changes the
integers after 15 to a zero.
Example: 123456789123456789  entered into cell returns
             123456789123456000.
highlights31 Mar 2005 03:23 GMT1
Can you help me and tell me if this is at all possible using conditional
formatting or a formula
I4 is to equal to  b4 times c4. If d4 is not the same as i4 then d4 needs to
highlight in red. However if d4 is a negative number then d4 should remain
Cell format switches to TEXT31 Mar 2005 03:02 GMT1
Whenever I edit a cell it changes format to TEXT.  Then I have to set
the cell format back to GENERAL, type a CR in the formula bar, and then
I see my calculations.  This is only happening in one workbook so
there's something fishy about it's properties.  Is there a default cell
Filter (do not want the ugly drop-down button)31 Mar 2005 01:12 GMT3
ExcelXP
I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the ugly
Excel things my spreadsheet is much bigger than it is31 Mar 2005 01:02 GMT7
I'm having a problem with certain spreadsheets where if I do a ctrl-end
to go to the end of the sheet, I am taken much further than I should be
if it were only going based on blank cels. Even if I do a "clean
contents" for that cel, or delete the entire row, I still get taken
How do I convert Excel 2003 to Excel 98 format?31 Mar 2005 00:48 GMT8
How can I convert an Excel 2003 spreadsheet to an Excel '98 format?
 
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.