Turn footer sideways

[DFDGirl]

Am I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle? If not I just need to know. Thank you

 

[Jim Cone]

No, but you can insert an image in some xl versions.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html

..
..
..

"DFDGirl" <melissa.perusse@gmail.com>
wrote in message
Am I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle? If not I just need to know. Thank you

 

[DFDGirl]

No, but you can insert an image in some xl versions.
--
Jim Cone
Portland, Oregon  USAhttp://www.contextures.com/excel-sort-addin.html

.
.
.

"DFDGirl" <melissa.peru...@gmail.com>
wrote in messageAm I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle?  If not I just need to know. Thank you

Jim what kind of Image? I am looking to put the Page # on there? Is
there a way to do that in a text box?

 

[Jim Cone]

You would have to find or create and then save the pictures as separate files on your computer.
Formats such as .jpg, .gif, .bmp, .png or ?
Vba code would be required to add a particular picture to each page as it was printed.
It could result in a slow printing process.

Example: The following code adds a picture of a padlock to the left footer...
'---
ActiveSheet.PageSetup.LeftFooter = vbNullString
With ActiveSheet.PageSetup.LeftFooterPicture
.Filename = "F:\Icons\vista_toolbar_c\BMP\Lock.bmp"
End With
ActiveSheet.PageSetup.LeftFooter = "&G"
---
Jim Cone
Portland, Oregon USA

..
..
..

"DFDGirl" <melissa.perusse@gmail.com>
wrote in message

No, but you can insert an image in some xl versions.
--
Jim Cone
Portland, Oregon USAhttp://www.contextures.com/excel-sort-addin.html

.
.
.

"DFDGirl" <melissa.peru...@gmail.com>
wrote in messageAm I able to turn footer sideways like I do when I select a cell and
ask for a -90 percent angle? If not I just need to know. Thank you

Jim what kind of Image? I am looking to put the Page # on there? Is
there a way to do that in a text box?

 

[Jim Cone]

Further...
I tried a "sideways" font in the footer but it printed conventionally (straight up).

 

[DFDGirl]

Further...
I tried a "sideways" font in the footer but it printed conventionally (straight up).

Well I appreciate your efforts. I could not get the side printing to
work either. Thank you.

 

[DCG-jaeson]

Hi DFD,

Maybe you can use my idea, set ur View into a "Page Break View" then
merge each last coloumn, for the first column use Ctrl+1 (Format
Cell), then go to NUMBER TAB in CATEGORY=Costum, in TYPE just type...

"(Text) Page"0

Then in ALIGNMENT TAB, Horizontal=Center, Vertical=Center, Degrees is
90, Then enter.

Copy the first page last column into next page last column, then use
this formula =i1+1 (lets assume ur "i1" is ur last column in page#1.
Then do it into ur next page so forth and so on........

This one does not need some HeadAche codes but it works, need only to
copy those columns into next.

Hope this will help, hehe!
~jaeson