Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Turn footer sideways

14 views
Skip to first unread message

DFDGirl

unread,
Aug 25, 2010, 10:23:21 AM8/25/10
to
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

unread,
Aug 25, 2010, 11:29:45 AM8/25/10
to
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...@gmail.com>
wrote in message
news:792d21e2-72a9-4541...@j8g2000yqd.googlegroups.com...

DFDGirl

unread,
Aug 25, 2010, 1:43:04 PM8/25/10
to
On Aug 25, 11:29 am, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> 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 messagenews:792d21e2-72a9-4541...@j8g2000yqd.googlegroups.com...

> 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 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

unread,
Aug 25, 2010, 2:43:46 PM8/25/10
to
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...@gmail.com>
wrote in message

news:125eaab6-56a6-4629...@q1g2000yqg.googlegroups.com...

Jim Cone

unread,
Aug 25, 2010, 2:50:08 PM8/25/10
to
Further...
I tried a "sideways" font in the footer but it printed conventionally (straight up).

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Special Print Excel add-in)

DFDGirl

unread,
Aug 25, 2010, 3:03:46 PM8/25/10
to
On Aug 25, 2:50 pm, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> Further...
> I tried a "sideways" font in the footer but it printed conventionally (straight up).
> --
> Jim Cone
> Portland, Oregon  USAhttp://www.mediafire.com/PrimitiveSoftware
> (Special Print Excel add-in)

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

DCG-jaeson

unread,
Aug 25, 2010, 4:48:35 PM8/25/10
to
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

0 new messages