ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rotate a box with a cell's contents (https://www.excelbanter.com/excel-discussion-misc-queries/11219-rotate-box-cells-contents.html)

Circe

Rotate a box with a cell's contents
 
Can you change a box's alignment with a cell's contents in
Excel? I don't want the gridline to change, just the box
that the cell is in?
Thanks

Dave Peterson

I'm not sure, but if you mean you want to change the orientation of the text
within the cell:

Format|cell|alignment tab



Circe wrote:

Can you change a box's alignment with a cell's contents in
Excel? I don't want the gridline to change, just the box
that the cell is in?
Thanks


--

Dave Peterson

Gord Dibben

Circe

What kind of "box" is the cell in? Or do you mean the cell itelf?


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 11:54:37 -0800, "Circe"
wrote:

Can you change a box's alignment with a cell's contents in
Excel? I don't want the gridline to change, just the box
that the cell is in?
Thanks



Circe

The user wants the box that represents the cell to be
rotated -- strange request. He says he's done it before,
but I think he probably rotated a rectangle object?
That's the only thing I can think of at the moment.
Thanks for your response.
-----Original Message-----
I'm not sure, but if you mean you want to change the

orientation of the text
within the cell:

Format|cell|alignment tab



Circe wrote:

Can you change a box's alignment with a cell's contents

in
Excel? I don't want the gridline to change, just the

box
that the cell is in?
Thanks


--

Dave Peterson
.



Yes, the user says he wants to rotate the box the cell is
in -- he says he's done it before. My thinking is he may
have used a rectangle object and then rotated that.
Thanks for your input.
-----Original Message-----
Circe

What kind of "box" is the cell in? Or do you mean the

cell itelf?


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 11:54:37 -0800, "Circe"
wrote:

Can you change a box's alignment with a cell's contents

in
Excel? I don't want the gridline to change, just the

box
that the cell is in?
Thanks


.


Dave Peterson

I'd guess an object like a rectangle, too.

Or maybe WordArt. (Insert|object???)

wrote:

Yes, the user says he wants to rotate the box the cell is
in -- he says he's done it before. My thinking is he may
have used a rectangle object and then rotated that.
Thanks for your input.
-----Original Message-----
Circe

What kind of "box" is the cell in? Or do you mean the

cell itelf?


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 11:54:37 -0800, "Circe"
wrote:

Can you change a box's alignment with a cell's contents

in
Excel? I don't want the gridline to change, just the

box
that the cell is in?
Thanks


.


--

Dave Peterson

Dave Peterson

Or maybe a picture of the cell.

Select the cell/range
edit|copy
select another spot
Shift|Edit|paste picture link

Then rotate that object.

When I rotated a rectangle, the text didn't change.

Circe wrote:

The user wants the box that represents the cell to be
rotated -- strange request. He says he's done it before,
but I think he probably rotated a rectangle object?
That's the only thing I can think of at the moment.
Thanks for your response.
-----Original Message-----
I'm not sure, but if you mean you want to change the

orientation of the text
within the cell:

Format|cell|alignment tab



Circe wrote:

Can you change a box's alignment with a cell's contents

in
Excel? I don't want the gridline to change, just the

box
that the cell is in?
Thanks


--

Dave Peterson
.


--

Dave Peterson


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com