shortcut for creating border in several highlighted cells
 

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

shortcut for creating border in several highlighted cells
 

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.

shortcut for creating border in several highlighted cells
 

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

shortcut for creating border in several highlighted cells
 

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.

shortcut for creating border in several highlighted cells
 

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