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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Pasting MS word tables into Excel10 Jun 2005 19:00 GMT2
I have a MS Word doc that contains a table.  In the each cell of the table
are multiple lines of text (an address).  I want to get that information to a
spread sheet.  The key is that I want to paste all the contents of a cell in
the Word table into a single cell of the spread ...
rotate an Excel chart pasted into Word10 Jun 2005 18:53 GMT6
I created a chart in Excel that is best viewed and printed in landscape
view.
But after pasting it onto a page of my Word document, I can't figure out
how to rotate it 90 degrees to better fit the page.
Excel files not showing read-only10 Jun 2005 18:36 GMT2
We have users who share files working with Excel and they are sometimes able
to open an Excel file and edit it even when it is already open. - A
read-only alert does not pop-up.
Already checked out the Share Workbook option and it sin't set to allow
Worksheet functions10 Jun 2005 18:25 GMT2
How do I create a function that will add an amount according to the date?  
Like a late fee?
Setting a dynamic range in a formula10 Jun 2005 18:13 GMT3
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
=(PRODUCT(1+D1:D12/100)-1)*100
Any suggestions?
Change part of data within a cell.10 Jun 2005 17:53 GMT2
I have a long list of data in the format:
a-bb-ccc-yyy-zz
Where all letters are numbers, i.e:
     1-01-100-200-00
MsgBox in footer10 Jun 2005 17:25 GMT1
I have a spreadsheet that I would like to put the message, "Last
updated on: xx/xx/xxxx" in the center section of the footer.  The date
is never consistent, so the user would need to be prompted to enter the
date. I am envisioning something like a message box.??
Sorting specific data10 Jun 2005 17:14 GMT3
I need help to sort the contents of a cell.
Cell A1= 01201
I wish to sort the numbers in A1 into descending numerical order. The
Help with an array function10 Jun 2005 17:10 GMT4
okay, I've got a worksheet (Individual Week Totals Tracking) that uses
an array function to call on another worksheet (Lantigua) and sums the
cells in each column holding a specific date in the Lantigua
worksheet.
how to sort cells with sheet reference10 Jun 2005 16:02 GMT1
i an unable to sort the data in cells containing a reference to anothe
sheet.  it seems as though excel is treating this reference as absolut
and not relative.  is there any way to do this, such that thes
equations adjust to the sorting?  any thoughts would be appreciated.
Entering Formula into Merge Cells Question10 Jun 2005 15:54 GMT1
:)  Here is the situation.
Merged S6 through u6 into one cell.
Merged s7 through u7 into one cell.
Merged s8 through s8 into one cell.
Validation Lists?10 Jun 2005 15:26 GMT3
I have made a drop down using the List in Validation with two options,
say X and Y.  95% of the time either X or Y will be chosen but I would
like to give the user the option to type into the same cell any value,
not necessarily X or Y.  I could take out the Validation and let the
pivot table adding in a formula10 Jun 2005 13:30 GMT2
I have a pivot table and i want to add a cumulative total going down
the pivot table.
example
part number | total parts | cumulative total parts to here
Multiple Pivot Tables, Same Worksheet, Single Page Field10 Jun 2005 13:30 GMT2
I have an Excel spreadsheet with multiple worksheets in it, each with
different data.  In all the worksheets there is a common element (Year).
I would like to create a master page that has multiple pivot tables in it.
However, at the top of the page I would like a single page ...
Back up data directory10 Jun 2005 13:11 GMT1
Excel wants to access a backup directory on my d-drive which is my CD-DVD
removable drive.
When I go to the Tools-Options panel and select any tab I get a pop-up
saying that "cannot access 'd:\data\Excel' ".
 
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.