I'm a newcommer to Excel and have a sheet with a long row of data (ove
1,000 entries).  It would be nice if there was a way to wrap the lis
into columns on a sheet so that the actual report isn't so many page
with emty space around the data.  Is there a way to do this?

Is there any way that I can create a hyperlink inside a pivot table?
Thank you kindl
--
Message posted from http://www.ExcelForum.com

I write new data to a sheet in a spreadsheet from Access that varies i
size that is the source for a pivot table in the same spreadsheet. Whe
I go to refresh the data in the pivot table I have this problem,
sometimes all the new data won't show up

I have a cell where the user must enter a date time like this
5/1/2004 6:35 PM
How can I force them to enter a proper Date and Time?  Are there an
Input Masks like you can use in Access?  When I've tried and use

Please help.  I need to do an advance filter within a certain column.
When filtering using the autofilter, it allows you to select "contains
to find anything within that column that contains a particular word.
Because I need a more elaborate filter I cannot use autofilter and mus

Hope someone can help me again! I have a spreadsheet with severa
columns. The first contains email addresses - the rest are results fro
a survey.
I need to pull out the data but must hide the email addresses (dat

I have a spreadsheet that when I open it, the font in cells A1:C4 changes
from Arial size 10 to a different font.  When I click on the cell, the cell
still says it is formatted Arial and size 10 but the letters are about size
48 and the font is different.  I then have to change the ...

Dear Expert:
How can i protect my data from being copied i.e. xlnoSelection. I have
changed the property 'EnableSelection'=xlNoSelection' but it only works
while workbook is open.

Greetings all, I wish to evaluate a list of customers.
I have 500 orders from approximately 30 unique customers.
I wish to create a list such as "Top Ten" and then place the remainin
20 or so in a row called "All others" and have their count noted.

How do I manually display words on the next line inside a cell?
I always put extra spaces until the word is shifted to the next lnie.
(Not using 'wrap' option and adjust the width of a cell)

Wondering how I go about something like this:
I have a spreadsheet that has a daily accumulation of cash receipts with
many
different account numbers.

I was wondering if anyone knows how to make a macro run faster.
Currently, I run a macro to do a VLOOKUP for 20,000 lines and th
VLOOKUP is getting information from a report that is 50,000 lines long
Every time that I run this macro, it takes almost an hour to run.

This may be more correctly an Outlook problem and if so then please accept
my apologies for being off topic but it only happens in Excel not Word so I
am thinking that it is a setting in Excel that is causing it.
One particular user at my work attaches a workbook, (XL 2002 on ...

How do you stop excel from trying to automatically enter text from the cell above it?  I know you can simply "break the chain" by insering a row, but I don't want to do that.  Is the trick in the formatting of the current cell

I have a spreadsheet that contains  a bunch of financial data.
Say I have 10 columns
In column H if it does not contain BLANK I want to copy
that row into a new worksheet?