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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Bring in Word table30 Aug 2007 03:19 GMT2
I am using Office XP and need to bring a Word table into Excel. I have no
problem copying and pasting the table, but if a Word cell contains multiple
lines, every line in the Excel sheet has it's own cell.  Is there a way to
tell Excel to keep all text that is in a single Word ...
Change export delimitor?30 Aug 2007 03:18 GMT16
My Excel data contains both commas and tabs so I need to change the export
file.csv delimator to "~".  How can I do this?  (I tried Excel's suggestion
to go into the PC's control panel and change the txt list separator to ~ but
that didn't work.)
Combine data that spans two rows, preserving cells?30 Aug 2007 03:14 GMT1
I have inherited a spreadsheet containing "records" that are split over two
rows.  For example:
A                 B           C                      D                      
E           F         G
How to graph columns from different worksheets30 Aug 2007 02:56 GMT1
I tried to use the hold-CTRL method to select columns on different worksheets
and graph them, but it doesn't work.
Any ideas?
Sort range must change with added lines30 Aug 2007 02:46 GMT7
Others will be using this workbook so I need to build in the ability to add
new names (lines).  I have a worksheet called "Names" and one called "Data".  
The name field (defined as a group) becomes a drop down box on the Data
worksheet for easier data entry (one name may have ...
Why does File Size increase with reducing spreadsheet information?30 Aug 2007 02:24 GMT7
I get a spreadsheet about 4.6 MB, and try to delete any useless formula for a
table A2:K1000, but I get no idea why the file size for this spreadsheet
increases from 4.6MB to 5.6 MB, which does not make any logical sense.
Will I create some garbage information when I delete those ...
Linking Questions30 Aug 2007 01:56 GMT1
Hope someone can help me with this.. If you have a Doc A listings names in
column A and you want each sheet name in another DOC B to be the names on the
list in Doc A. Is that possible with a formula? I know you can highlight all
the sheets in DOC B link to one cell in Doc A and ...
Hyperlinking two different pieces of text in a single cell30 Aug 2007 01:36 GMT1
I am creating a curriculum based master calendar in which certain cells will
have multiple meeting times by different departments for the same day. I want
to be able to link one department (X) to Y document and (Z) department to A
document
Sheet protection on MAC30 Aug 2007 00:56 GMT3
When you protect a sheet On the PC Windows platform
you are given 15 to 20 seperate Check-boxs for different
things that you can Include/exclude..  How is this done on a
MAC?  When I do the Tools, Protection... ProtectSheet...
IF then statement+ condiditonal format30 Aug 2007 00:36 GMT4
I am trying to color text white (to essentially hide it) if it meets a
certain condition.  However, it isn't as simple as if the cell =x.  My If
statement includes recognizing text.  =IF(H12="Independent", color text
white, color text black).  Is there a way that I can use ...
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ?29 Aug 2007 23:46 GMT2
Dear Sir,
I understand that there is a download from MS for converting the format for
Excel 2007 in order for it to open and edit using Excel 2002.
May I know after downloading the format converter, the Excel 2007 file that
Formula help29 Aug 2007 23:28 GMT2
Is there a formula that would help me calculate the following:
      A         B
1  45,000    .50
2  50,000     0
Unprotecting Worksheets29 Aug 2007 23:06 GMT3
I have a file that has multiple worksheets, each are protected (locked) with
a similar password for each worksheet.  Is there a way to unprotect all
worksheets all at once without having to click on each sheet and unprotect it
that way?  Is there a Macro?  Or something?
Conditional Drop Down Boxes29 Aug 2007 22:38 GMT1
I am trying to set up a worksheet for a pipeline report.  I need to set up
Conditional Drop Down Boxes that are contingent upon the drop down Choice in
a previous Drop Down Box.  The problem is that I have to set up more than one
Dependent Drop Down Box for the same master Data ...
Please help. Remove dups automaic of same name,price,month.29 Aug 2007 22:24 GMT6
I have a spreadsheet called Book1 with 2000 lines.  
Where there is a dup in rate , name and month I want to remove the dup  
lines from the spreadsheet.  Keeping just one line.
If the price is diff but same month, name and rate i want to keep in the
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.