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 / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
text18 Apr 2007 23:54 GMT1
Working in Excel 2007, I have a cell designated for text.  If text is
entered, I would like it to show up in another cell also.  If there is no
text entered, I'd like the other cell to be blank.  Using a formula like
"=b12" results in a zero in the second cell if the first is ...
patterns to cell18 Apr 2007 22:34 GMT1
I have an excel spread sheet that I want to assign colors to my 17 numbers
but condional formating only goes to 4 colors how can I assign a cell 17
different colors when I select a certain number
IF statements across Worksheets18 Apr 2007 22:18 GMT2
Novice excel user here.
I am trying to use the insert function feature to insert a IF statement to
make a cell a 1 or 0 based on the value of a cell on a different worksheet.  
The command I am using is as follows:
template18 Apr 2007 21:22 GMT2
If I save a template how do I use it without losing it.
If I use it to fill in blanks and need to save it. How do I know the
template will stay in its file and not change?
Kim
How do I set up a running balance worksheet ?18 Apr 2007 20:31 GMT2
I am trying to set up a worksheet where i put data into one cell and it is
added to the balance using only one cell continously.  How can i do this and
have a running total daily and weekly/
clipboard wont paste18 Apr 2007 20:04 GMT1
I have the items on the clipboard to paste. Use it often but it will not
paste today.
In exel what function does "^" perform?18 Apr 2007 19:36 GMT2
For example: (0.0532+1)^(1/12)-1=0.0043
How do I Import worksheet into a word doc.?18 Apr 2007 19:14 GMT1
I want to import a worksheet in to a word document.  In this case the
worksheet will be an entire page.  It will also be useful to be able to add
text and graphics on the same page as the worksheet.
Pick From Drop-Down List...18 Apr 2007 18:58 GMT3
I have created a list in cells A2 thru A13.  A1 has text 'Month & Yr'
entered.  When I right-click in A14, I do not have the option of Pick From
Drop-Down List... appear.  I have this in another file that was converted
over from Excel 2000 & it works fine.  What am I missing in ...
Changing the sorting order...18 Apr 2007 18:54 GMT5
Is there anyway to change to default sort order?  I am trying to sort in a
list percentage change from prior year, but in the case when there is no
prior year information the display is "N/A", which is fine, but I need it
sorted to the bottom of the list when I sort descending.  ...
Calculation Speed18 Apr 2007 18:36 GMT1
Anyone have tips on how to speed up the calculations in a workbook?  I've
moved most calculations, where possible, to take place in the same sheet as
the data resides as I seem to recall a tip that this would speed up
calculation.  Is there anything else anyone can suggest?
Removing concatenated colums after using them?18 Apr 2007 18:19 GMT2
I used the concatenation formula to join first and last names together into a
new cell.  However, I now need to delete the two original cells for
submission to a printer.  Of course, when I do that, I get "REF" in the third
cell because the references used to perform the ...
Inserting Number18 Apr 2007 17:55 GMT5
How do i insert number "Zero 0" in front of multiple numbers
     7775644619
     7764856857
     7932085127
Conditional Formatting?18 Apr 2007 17:50 GMT2
I am trying (unsuccessfully) to apply conditional formatting to a column of
dates
It needs to identify dates less than a fortnight old e.g.
Formula is <=TODAY()-14
Protecting portions of worksheet18 Apr 2007 17:40 GMT1
I have an excel worksheet that is used to calculate chemical quantities.  The
worksheet needs to have all the cells with formulas completely locked - so no
one can delete/change the contents of the cell.  I actually have a
very(relatively) small range of cells that I want to have ...
 
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.