How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!

--
Dan Walters


"Ed" wrote:

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed

Hi Dan,

Thanks for answering. I draw engineering drawings in excel and I use text
blocks and word art for text so that I can move things around easily in case
the text gets in the way of what I am drawing.
--
Ed


"DanielWalters6" wrote:

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!

--
Dan Walters


"Ed" wrote:

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed

If you're creating engineering drawings then I suggest you use a more suited
program really.

I use OmniGraffle For Mac, which is brilliant, I am sure there is a Windows
Equivilent.

It allows you to export drawings to a million different formats, ie, jpg,
bmp, pdf, .doc, .ppt, not 100% sure on Excel, I'm away from my main computer
at the moment, so couldn't tell you.

But it's worth checking it out.

It's sooo simple my 9 yr old brother's using it for science diagrams and
homework.

Best of luck


--
Dan Walters


"Ed" wrote:

Hi Dan,

Thanks for answering. I draw engineering drawings in excel and I use text
blocks and word art for text so that I can move things around easily in case
the text gets in the way of what I am drawing.
--
Ed


"DanielWalters6" wrote:

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!

--
Dan Walters


"Ed" wrote:

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed

Hi Dan,

I must use Excel because that is what is required at work. I draw the
sketches in Excel and then put them on a server so that others can look at
them and make changes. If there is a program that is compatible with Excel
that is easier to use, I would be interested. The program would have to be
capable of being pasted into Excel and also changes would have to be made
under Excel rules because my peers only have Excel on their computers.


Ed


"DanielWalters6" wrote:

If you're creating engineering drawings then I suggest you use a more suited
program really.

I use OmniGraffle For Mac, which is brilliant, I am sure there is a Windows
Equivilent.

It allows you to export drawings to a million different formats, ie, jpg,
bmp, pdf, .doc, .ppt, not 100% sure on Excel, I'm away from my main computer
at the moment, so couldn't tell you.

But it's worth checking it out.

It's sooo simple my 9 yr old brother's using it for science diagrams and
homework.

Best of luck


--
Dan Walters


"Ed" wrote:

Hi Dan,

Thanks for answering. I draw engineering drawings in excel and I use text
blocks and word art for text so that I can move things around easily in case
the text gets in the way of what I am drawing.
--
Ed


"DanielWalters6" wrote:

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!

--
Dan Walters


"Ed" wrote:

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed

I understand the situation you're in.

I do however still find it hard to understand what qualities of excel you
and your peers have seen that has made you adopt it as your format.

It's not brilliant for drawing lines, textboxes, word art, the only use I
can see is math functions built into it?


--
Dan Walters


"Ed" wrote:

Hi Dan,

I must use Excel because that is what is required at work. I draw the
sketches in Excel and then put them on a server so that others can look at
them and make changes. If there is a program that is compatible with Excel
that is easier to use, I would be interested. The program would have to be
capable of being pasted into Excel and also changes would have to be made
under Excel rules because my peers only have Excel on their computers.


Ed


"DanielWalters6" wrote:

If you're creating engineering drawings then I suggest you use a more suited
program really.

I use OmniGraffle For Mac, which is brilliant, I am sure there is a Windows
Equivilent.

It allows you to export drawings to a million different formats, ie, jpg,
bmp, pdf, .doc, .ppt, not 100% sure on Excel, I'm away from my main computer
at the moment, so couldn't tell you.

But it's worth checking it out.

It's sooo simple my 9 yr old brother's using it for science diagrams and
homework.

Best of luck


--
Dan Walters


"Ed" wrote:

Hi Dan,

Thanks for answering. I draw engineering drawings in excel and I use text
blocks and word art for text so that I can move things around easily in case
the text gets in the way of what I am drawing.
--
Ed


"DanielWalters6" wrote:

I'm not sure you can...?

Could you not just use a blank worksheet and set the colour of all the cells
to WHITE, this way it wouldn't show the gridlines or anything? Then just put
the text into cells that work for you.

If you need more than one line of text per cell, you can always use the ALT
and ENTER to make a return within a cell.

Hope one of these helps,

Good luck with finding a proper answer!

--
Dan Walters


"Ed" wrote:

How do you use the "Find and Replace" block when everything is in text
blocks or word art?
--
Ed