I inherited a spreadsheet.  In a cell is text.  Some of the text is red and
some is black.  How did she do that?  I can't figure out how to do that!

,In 2003 it was possible to clear all formats from a cell/range of cells by
going to Edit, Clear, Clear All. Is this still available in 2007 and, if so,
where? If not, is there something that will do the same thing?
Thanks

I would like to set up an excel file that has several tabs that send data to
one table, but on a daily basis clear the data in those tabs to enter new
info while continuing to add/store that data to the master data table.
First three being, say 1, 2, 3.  Data will be entered into ...

Hi can someone please help  I am trying to calculate a cell but it references
to to a number of different sheets.
=IF(Template!R29="","",(H5-Template!R29!))
I keep getting an error message about the the fact that the calculation is

I have a fairly large PowerPoint file, approx. 100 slides that are linked to
6 different Excel workbooks. The workbooks are updated monthly, renamed and
then I open the PowerPoint file and update the links via Edit>Links, and then
save the file. When I reopen the PowerPoint file ...

I want to choose 50 random rows from 10,000 lines of data and paste it into a
new sheet. The only way I know is to use a random number generator to
randomly select the records and then copy/paste the data out out, row by row,
fifty times, which is time-consuming. Is there a way ...

I have created a database in Excel 2003 of organisations that provide
services. I have the list of organisations on sheet 2 with column headings of
name, address, phone number and ten other columns that have the name of a
service type ie respite, accommodation etc. On sheet 1 I ...

Howdy,
I´ve got a small guesthouse, and use the excel to manage the bookings.
In sheet one, I type the following:
Cell a: date of arrival

(previously posted in microsoft.public.excel.programming, to no
response)
I have a rather large (in terms of code, number of controls, and data
stored in cells) spreadsheet in Excel 2007 which intermittently fails

I am working off a document created by someone else in Visio.  They have
create a 'spreadsheet' using lines and individual text boxes.  I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.

I have concatinated two cells to create a function and I can cut and past
special the values for that function but it is not until I select the cell
contents and press enter that the function works.
example:

need a macro, anyone know how to find a text in the worksheet and delete
range rows from the text it fund. sample: text in column A row 12, I want to
delete rows from rows 3-12 or text in rows 50, I want to delete from rows
50-58. pls help.

I am using XL 2007 in Vista
...Lisa

I have created a tracking chart which uses a drop down menu to assign task to
team members.  Now I want to separate each person's tasks onto a separate
sheet using the name in the first sheet to separate the tasks.
Meaning : the items everyone is responsible for go onto the ...