Is there a shortcut or easy way to create a border for several cells at one
time? When I highlight a group of cells and choose a border only the outside
of the cells shows a border. If this can't be done, how can I easily have
each cell in my rows and columns all to have a line border? I guess I'm new
at this.
--
emprof

Easiest would be to click on the "borders" icon on the formatting toolbar
and select the appropriate style.


Gord Dibben MS Excel MVP

On Tue, 2 Sep 2008 13:54:58 -0700, emprof
wrote:

Is there a shortcut or easy way to create a border for several cells at one
time? When I highlight a group of cells and choose a border only the outside
of the cells shows a border. If this can't be done, how can I easily have
each cell in my rows and columns all to have a line border? I guess I'm new
at this.

Click both the Outside and Inside buttons on the Border tab of the Format
Cells dialog box.

--
Rick (MVP - Excel)


"emprof" wrote in message
...
Is there a shortcut or easy way to create a border for several cells at
one
time? When I highlight a group of cells and choose a border only the
outside
of the cells shows a border. If this can't be done, how can I easily have
each cell in my rows and columns all to have a line border? I guess I'm
new
at this.
--
emprof

Thanks, much! I cannot believe the answer was right under my nose all the time.
--
emprof


"Gord Dibben" wrote:

Easiest would be to click on the "borders" icon on the formatting toolbar
and select the appropriate style.


Gord Dibben MS Excel MVP

On Tue, 2 Sep 2008 13:54:58 -0700, emprof
wrote:

Is there a shortcut or easy way to create a border for several cells at one
time? When I highlight a group of cells and choose a border only the outside
of the cells shows a border. If this can't be done, how can I easily have
each cell in my rows and columns all to have a line border? I guess I'm new
at this.

Thanks, much! Your method worked, too!
--
emprof


"Rick Rothstein" wrote:

Click both the Outside and Inside buttons on the Border tab of the Format
Cells dialog box.

--
Rick (MVP - Excel)


"emprof" wrote in message
...
Is there a shortcut or easy way to create a border for several cells at
one
time? When I highlight a group of cells and choose a border only the
outside
of the cells shows a border. If this can't be done, how can I easily have
each cell in my rows and columns all to have a line border? I guess I'm
new
at this.
--
emprof