Excel "Rows" Question

D

Dermot

I use Excel to generate document forms instead of Word.
In many situations I prefer Excel for this purpose.

Is it possible to move the rows left or right independantly of each other.
For example assumming I have text in row 2, is there anyway to slide row 2
to the left of right horizontally independantly of the other rows above or
below it.
I know this is unlikely, but could it be done?

Thanks
Dermot
 
D

Dermot

Please ignore this posting.
I was thinking out loud!!!!
I can achieve what I want with Cell merging.
 
K

Ken Wright

Merging - YUK.

You can move rows left or right independently by inserting or deleting
cells. You might also find the use the indent feature useful for what you
are after

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
G

Gord Dibben

Dermot

Try "Center across selection" rather than merging.

You may get the same result without the problems merged cells can create.


Gord Dibben MS Excel MVP
 
D

Dermot

Thanks for this Ken,
It never entered my mind that I could enter a single cell.
I may never merge again!!!
Thanks
Dermot
 
D

Dermot

Hello Gord,
Do you mean centre the text within a selected cell?
Please explain a little further.
Thanks
Dermot
 
G

Gord Dibben

Dermot

Text is in A1

Select A1:E1 and Format>Cells>Alignment>Horizontal.

Select "Center across selection"

Text will slide to the right, lining up with column C

Can't slide left with CAS.


Gord
 
D

Dermot

Thanks for this Gord
I knew, I didn't pick up correctly.
This too is a nice option.
Thanks
Dermot
 
J

Jaleel

Can slide left with Centre Across Selection in the case of Right to Left
option. For example, Arabic. Arabs prefer this option.

Jaleel
 
G

Gord Dibben

Dermot

Stick with that resolution to never merge cells again.

They have their place I suppose, but can cause many problems when sorting,
filtering, copying, pasting.


Gord

LOL - You're welcome :)

Regards
Ken.....................
Click to expand...

Gord Dibben MS Excel MVP
 
Top