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 / General Excel Questions / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to subscribe to this list in hotmail?  slightly off topic18 Jan 2008 00:03 GMT3
I need this list at work.  does anyone know how/if you can subscribe to the
excel list through hotmail?  It seems at work that I can't get the lists
through this page.  It doesn't allow a popup for me to respond to a question
or ask a question.  I have popups enabled.  This ...
#N/A18 Jan 2008 00:00 GMT4
Is there anyway to return "0" when a cell receives the #N/A error?  Not in
the same cell, but another one so it can be used in a new formula.
Ex: =IF(C81="#N/A", "0")
This didn't work.
Inserting several new rows17 Jan 2008 23:13 GMT1
I have a spreadsheet with about 1500 rows.  I want to insert 18 black rows
after each existing row.  Is there a quick way of doing this without having
to do this after each row?
Table of Tabs17 Jan 2008 22:39 GMT3
Trying to create a "table of contents" of all my tabs in a worksheet.  I've
seen this on other worksheets as a hierarchy list of tabs on the left of the
screen... like a folder view... any suggestions?
vlookup cell reference17 Jan 2008 22:35 GMT2
What formula can I use to return a cell number that a vlookup output
references.
For instance:
Data in A1:A3 = X,Y,Z
Column Heading 2 Lines17 Jan 2008 22:34 GMT3
How would I put "One Two Three Four" in a column Heading with "One Two" on 1
line and "Three Four" under it or on a 2nd line?
Thanks
NotGood@All
sort by color17 Jan 2008 22:10 GMT3
is therer a way to group or sort so all my cells that have a blue color will
go to the top?
Having issues with exporting17 Jan 2008 22:09 GMT3
I am trying to export a spreadsheet out to a file type that is compatible
with my GIS.  In older versions of Excel, one could export out to a .dbf
file, which was usable.  Now, that option has been removed, so I'm stuck
having to use a text file.  However, when choosing .csv as ...
Excel files don't open until a click on blank worksheet17 Jan 2008 22:07 GMT1
I'm having a weird Excel problem that I can't figure out the origin
of.  It's been happening ever since I installed 2007 many months ago.
If I double-click an Excel file to open it, Excel opens and a
worksheet called Personal appears.  However, the file I clicked on
averages that ignore #VALUE! cells17 Jan 2008 21:43 GMT7
I am making a spreadsheet in excel that will add subtract times and then
average the totals of multiples of these.  My problem is that some of the
tiems do not need to be entered causing a # VALUE! in teh line where my
subtraction formula.  This is fine and needs to stay this way ...
Replacing formula with round multiple times17 Jan 2008 21:42 GMT1
I have a spreadsheet that has around 12000 lines, in column D there is
a formula that creates a value such as 2000.123524. The value needs to
be exported to another application but I have to remove the decimal
places first.
The color of gridlines17 Jan 2008 21:22 GMT1
I am having a problem seeing the gridlines in excel, I am used to Excell 97
and in this new form the colors are to light. I would like to make them
darker and have them stay that way. I can change them for the current project
but would like to have that be the norm. If anyone ...
Formula Won't Work after 10 Cells17 Jan 2008 21:09 GMT4
At my job we do reports where there is a list of 10 items that use formulas.
These 10 work great, but if we add any more to the list and copy down the
formulas, the formulas don't work!  Has anyone ever heard of this before? Any
suggestions?  We keep having to manually calculate ...
excel search formula17 Jan 2008 20:49 GMT10
I'm trying to create a formula that searches a column for the last cell that
contains data, and then returns that value to a cell in another worksheet.  
Could anyone help me out with this? Thanks
Profress Indicator17 Jan 2008 20:42 GMT2
I have this bit of code but I'm having problems with it, could you take a
look and point me in the right direction? I can't seem to get the form to
update.
Thanks
 
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.