excel indenting a group of rows
Does anyone know how to indent a group of cells all at the same time.
For example I would like to indent the first 25 rows all with 10 spaces before the wording starts. Is there a way to do this all at once with out manually going into each cell and hitting the space bar 10 times. |
excel indenting a group of rows
Try this:
Select the range, click Format Cells Alignment tab Under Text alignment, Select Left (Indent) then click for the desired "Indent" # in the spinner Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... Does anyone know how to indent a group of cells all at the same time. For example I would like to indent the first 25 rows all with 10 spaces before the wording starts. Is there a way to do this all at once with out manually going into each cell and hitting the space bar 10 times. |
excel indenting a group of rows
On Jun 27, 11:11 am, "Max" wrote:
Try this: Select the range, click Format Cells Alignment tab Under Text alignment, Select Left (Indent) then click for the desired "Indent" # in the spinner Click OK -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik wrote in message ups.com... Does anyone know how to indent a group of cells all at the same time. For example I would like to indent the first 25 rows all with 10 spaces before the wording starts. Is there a way to do this all at once with out manually going into each cell and hitting the space bar 10 times.- Hide quoted text - - Show quoted text - Thanks! It worked. |
excel indenting a group of rows
welcome, good to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote Thanks! It worked. |
All times are GMT +1. The time now is 01:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com