View Single Post
  #7   Report Post  
Ragdyer
 
Posts: n/a
Default

When you say:
<"I made a border around several cells"
Just exactly what "set-up" do you mean?

Are they in a single row, across columns - D10:G10
Or a single column, down some rows - D10:D13
Or a combination D10:G13 ?

Depending on the configuration of your selected cells, there are different
procedures that you could perform to display differing results.

If you used (selected) D10:G13 for example,
Surrounded it with a border,
And maybe added a pattern color of White or Lt.Blue,
You wouldn't see any of the grid lines within the selection,
And you could enter your text in D10, to have it displayed in the top left
corner.

As far as moving it:
Just select the entire "box" (D10:G13),
And then hover the cursor just outside any one of the borders until the
cursor changes to an arrow.
Then, simply click and drag the entire "box" to whatever location you wish.

You could also *name* this selection, so that it could be more easily
selected.
Select D10:G13, and click in the "name box", which is just to the left of
the formula window.
Type in a short name, such as "box" (no quotes), and hit <Enter.

You could then click the name in the name box, and have the box selected,
where you could easily drag it to wherever.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"PeterM" wrote in message
...
Happy New-Year to all of you, and thanks for the answers to all of you as
well. It worked of course. I have another question. I made a border around
several cells, and put the word serial number in the top most left corner.
If I like to move this box, how do I make it a movable box, by just
grabbing it and moving it, and how can I keep the writing in that left top
corner. I tried different things, like combining the cells. (I know it is
not the right syntax) when I combined the cells the writing went some

other
place, and I could not find the place to click for the writing to be on

the
top left. Would you help me again

please..........Grandpa.............Peter

"Tom Ogilvy" wrote in message
...
If there is no overlap betseen your internal borders and the border
around,
just delete each side of the border as an individual step. Select the
cells
associated with that side, then do Format=Cells=Border and click on

the
appropriate border to toggle the border off.

--
Regards,
Tom Ogilvy



"Tom Ogilvy" wrote in message
...
Undo only works in a single session of excel. The undo history is not
stored in the workbook. Also, even within a session, the undo history
can
become cleared. The "depth" of undo can be set with a registry

setting
as
I recall (believe the default is 16 actions).

each cell has a border property. a large border such as you described

is
just attained by going through each cell in the selected border area

and
setting the appropriate border. If you want to clear the larger

boarder,
you will have to go to each cell where you don't want a boarder and

turn
that border off. This is best done in Cells=Format=Border Tab where
you
have more control of the individual borders in a cell. As you have

learned,
it is much easier to add multiple borders than to remove them.

--
Regards,
Tom Ogilvy



"PeterM" wrote in message
...
I made a form with several individual areas that have borders. At the

end
I
decided to try a border around the whole form. Now that I don't like
it,

I
was trying to delete the form border, but it deletes all the borders

in
the
form as well. How can I just delete the border around the form and

not
the
rest of the individual borders? I'm actually on a different computer,
because of the printing, will I be able to undo my way out of it

maybe,
or
do I have to be on the computer where I made the form. One more

question,
will the form retain the undo feature for ever, or will it stop at

one
point
or another? Many thanks in advance.........Peter