I have a pdf with tables of data.  I converted it to Word with Acrobat.  The
data for each column is in one cell.  Ex: All the costs for each item is in 1
column - but 1 cell instead of 1 column several cells.  When I copy and paste
to excel it does the same thing. (Each column ...

Is it possible to group worksheets where the format is all exactly the same.
Then ungroup to make a change on worksheet without affecting the other
worksheets.

I'm working on my book collection listing, and one column I have is for
the ISBN number.  Most books have a zero in front of the number, like:
0451526775
However, when I input that, the zero is removed.  How do I make it so

Im self employed - and bill day rates for my servies.  Currently,in
excel I do all my invoice creation.
How I am doing it now, is  I make a new file (not using the tabs at the
bottom left of the sheet) for each invoice - and I have multiple exl

I know how to do this in Access, but I can't figure out how to do it in
Excel.  Not sure if it's an IF statement, LOOKUP, INDEX, or something
else...
Here's the scenario -

I would like to set up a spreadsheet intended for Montecarlo simulations to
iterate a number of times (say 1000), while saving the frequency of each
outcome on a separate table or graph. I know that pressing F9 recalculates
the spreadsheet, generating a new outcome each time. ...

            Can you help me, I wish to input a date in one column and have
a date six months ahead in the next column.
I then want the date to change colour depending on the date i.e. if the date
was 120 days from the original date it would be green and if it was 150 days

I can't open an excel document because whem I try to open it says that too
many different formatting cells.
How to resolve this and open this document?

Is there a way to add a superscripted number beside a number or formula in
cell that refers to a note at the bottom of the page?

I would like to format the lowest figure in a range to a chosen color.
Can anyone provide a formula or conditional formatting that will do
this. The range will cover about 20 rows.
Thanks

What's the easist way to select all the data in two columns, with up to 1500
rows, without having to click, hold & drag?  I guess I could record the
action as a macro that would cover the extreme range, but I'm looking for
something a little more defined.

Excel 2002.  My workbook has 37 worksheets.  If I go to Tools>Options,
View Tab, and check Sheet Tabs, the tabs are shown only on the first 29
sheets.  Has anyone else experienced this problem or have a clue as to
what's wrong?  Thanks.

I am trying to design a staff duty rota template for a shop open 7 days per
week. We have between 4 ­ 6 staff (depending on seasonal fluctuations) and
each member of staff has two days off per week.
I have searched the Microsoft database of templates and found nothing that

I searched the forum and couldn't quite find what I need.
I have a column with dates in the format 1/3/06 and need to have the
column next to it show the month in format 200601.
What I have tried is building a table that lists the last date of each

I need to compare two cells and color them if different, but not
compare spaces.
I've tried the following:
Conditional formating: