ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel indenting a group of rows (https://www.excelbanter.com/excel-discussion-misc-queries/148152-excel-indenting-group-rows.html)

[email protected]

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.


Max

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.




[email protected]

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.


Max

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