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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Multiple conditions in MATCH and INDEX functions07 Dec 2007 22:51 GMT4
Hi, I am too dumb to work this out on my own.
I have an array of given values of:
TypeA  Ver1  Price
TypeA  Ver2  Price
Problem opening an.xls or xlsx file07 Dec 2007 21:59 GMT2
Excel 2007 (Office 2007), WinXPSP2, 1.56GigRam, 60Gbt free,
2.1GHz processor.
When I select an .xls or .xlsx file from the file manager
(Windows Explorer), Excel immediately starts, instead of a
how much is too much data for a cell?07 Dec 2007 21:15 GMT11
a cell should hold 32,000 characters if i am not mistaken.  i have a
large spreadsheet that has codes, their use, description and the # of
times they have been 'hit'.  most of the information fits in a cell
very easily but i have one description that is huge.  i made the cell
Why does the change change to a number?07 Dec 2007 20:20 GMT3
I've noticed something wierd and always wondered WHY it happens.  When you
type a date into a cell, and then change the Formatting of it to a 'general'
cell, it turns into a number.  How does it come up with that number?  What is
the significance?
Adding Blank Cells ?07 Dec 2007 20:15 GMT2
Lets say I have a page of data pretty well filled up.
I am in column, e.g., D, and would just like to add a few blank cells
between some existing data in this column only.
I can't do a Insert a line as that would mess all the other columns also.
Trouble Saving07 Dec 2007 18:15 GMT1
There is an Excel spreadsheet that is kept on a network drive. It was
orginally created in Excel 2000 but is saved by users using Excel 2003.  Most
people experience no problems, but I have this problem when I save it:
Every time I save it a new file is created in the folder where ...
Page Break each Row07 Dec 2007 17:52 GMT1
Is there a way to force Excel to put a page break after every row that
contains something (anything) is the A column of that row.  I don't need
Excel to put breaks on all the rows, just the ones that have information.
Excel 2002
Is it posible?07 Dec 2007 16:59 GMT3
I have a client who is using excel spreadsheets for a Product List,
Customers Orders, Customer Details and Purchase Orders.
He wants to be able to enter a product code in to the Customer Orders
spreadsheet, and have all the rest of the Product Information filled
Unable to add/delete/clear content of a row07 Dec 2007 16:26 GMT3
My 2007 excel workbook has several sheets.  One of them doesn't allow
me to add, delete, or clear content of rows.  This means when I right-
click on a row,  the "insert", "delete", "clear content" is grey
out.   Same thing when I use the ribbon.
replacing the Macro name with a variable07 Dec 2007 14:26 GMT1
I have a sheet which contains 1 main macro and 19 sub macros.
from the main macro i need to call any one of the sub macros using the
call function.
However is there any way i can write the names of those 19 sub macros
how paste real forumula, not "relative"07 Dec 2007 04:13 GMT1
When i copy a formula from one cell to another Excel adjusts any relative
cell references in whatever you are copying.  How do i get it to paste the
EXACT forumula without adjusting it?
(I know I can copy/paste the actual text of the forumula but I'm sure
array formula to provide all values associated with a given value07 Dec 2007 03:48 GMT1
From an Access Query.  I've got a list with the unique ID's for reports, and
the next field indicates what Language they were written in.
This was from a Many - Many relationship in Excel, and many of the reports
were written in many different languages.
copy range from one workbook to another07 Dec 2007 03:21 GMT2
Excel 2002 SP3
Win XP Pro SP2
Hi,
Even though I saw the documentation a while ago, I cannot remember how
vanishing buttons / follow-on question06 Dec 2007 23:59 GMT1
That was nicely resolved as noted, but:
Example, one of my macros starts like this:
===========================
Sub MainLogFindLastEntry()
Isdate, checking Formatting too e.g. dd/mm/yyyy06 Dec 2007 23:53 GMT1
I've used the IsDate successfully to check if a date within a text box is
valid.
When you enter the textbox the date is set to todays date and formatted
dd/mm/yyyy
 
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.