Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Saint
 
Posts: n/a
Default Free rotate cell content?

I need to know how to free rotate the content of a cell in Excel. I also
need to know how to free rotate an imbed in Excel.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Contents of cells can be rotated using Format/Cell/Alignment. It's not
free-rotation, but is limited to plus or minus 90 degrees.

You can get free rotation if you copy a cell as a picture (hold the
shift key down as you select Edit/Copy Picture) and paste as a picture
into the worksheet (Edit/Paste Picture). You can then use the Free
Rotate tool on the Drawing Toolbar to rotate the picture as desired.



In article ,
"Saint" wrote:

I need to know how to free rotate the content of a cell in Excel. I also
need to know how to free rotate an imbed in Excel.

  #3   Report Post  
Saint
 
Posts: n/a
Default

This will rotate the cell contents, but it leaves the cell borders as a box.
I need clean lines. It does work for the imbed.

"JE McGimpsey" wrote:

Contents of cells can be rotated using Format/Cell/Alignment. It's not
free-rotation, but is limited to plus or minus 90 degrees.

You can get free rotation if you copy a cell as a picture (hold the
shift key down as you select Edit/Copy Picture) and paste as a picture
into the worksheet (Edit/Paste Picture). You can then use the Free
Rotate tool on the Drawing Toolbar to rotate the picture as desired.



In article ,
"Saint" wrote:

I need to know how to free rotate the content of a cell in Excel. I also
need to know how to free rotate an imbed in Excel.


  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

It doesn't leave any lines when I use the "as viewed on screen" I also
turn gridlines off when I copy and paste picture.

In article ,
"Saint" wrote:

This will rotate the cell contents, but it leaves the cell borders as a box.
I need clean lines. It does work for the imbed.

  #5   Report Post  
Saint
 
Posts: n/a
Default

My gridlines are off. Where or what is the "as viewed on screen"?

"JE McGimpsey" wrote:

It doesn't leave any lines when I use the "as viewed on screen" I also
turn gridlines off when I copy and paste picture.

In article ,
"Saint" wrote:

This will rotate the cell contents, but it leaves the cell borders as a box.
I need clean lines. It does work for the imbed.




  #6   Report Post  
JE McGimpsey
 
Posts: n/a
Default

When you copy picture, at least in XLv.X, XL03, and XL04, a dialog pops
up asking if you want the picture as it appears on screen, or as printed.

In article ,
"Saint" wrote:

My gridlines are off. Where or what is the "as viewed on screen"?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
borders not aligned with cell content when printed andy g Excel Discussion (Misc queries) 2 June 5th 06 04:33 PM
can't delete a cell content in excel Mark B New Users to Excel 3 May 6th 05 06:42 PM
cell content miamac Excel Discussion (Misc queries) 0 April 18th 05 06:56 PM
How can I make the bar that shows the content of the cell visible. ZG Excel Discussion (Misc queries) 1 January 8th 05 07:27 PM
Transferring cell content between workbooks using cell references Kiwi Mike Excel Discussion (Misc queries) 2 November 27th 04 11:31 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"