Print in Top Right of printable space (instead of Top Left)

[eibi]

Hey everybody -- a page layout question:

When printing, Excel (by default) aligns the print area with the Top Left page margin.

The Page Setup->Margins menu gives the option to Center the print area Horizontally or Vertically, which I find a helpful function.

Today, though, I want my print area to be pinned to the Right Margin.

But How?

(I'm not really interested in 'faking' it by increasing the left margin, because then if I change the cell width or print scale, I'll have to go back and jiggle it again.)

Always appreciate this forum!

 

[Chihiro]

I had same issue. What I did was paste data onto MS Word and printed from there.

 

[eibi]

Uh-oh. I was afraid I'd have to do something like that...Maybe a linked table in Word...

Meantime -- still open to suggestions.

 

[Chihiro]

Only other option I can think of is to insert blank columns to the left of your data and select area including blank columns and "Print selection".

I decided against it in my case.

 

[Deepak]

If you are interested in flipping the page then let me explain how could you achieve it.

Click File > Options > Language.

Now Click on Add [additional editing language]

Select any Arabic language as i selected Arbic(Iraq) & click add




Now restart excel & you will find following additional options under page layout.




Just click on the same & voila done.

or by VBA

In immediate window just hit the following.

ActiveSheet.DisplayRightToLeft = True

 

[Deepak]

One more thing that can be done is

First flip the page & paste the data column by column to it > Now print it.

 

[eibi]

Deepak -- you pointed me in the right direction: Thanks!

I was able to customize my ribbon without adding or changing the language settings:

Giving credit where credit is due, with your direction, I found this site that answered my question almost exactly: http://www.extendoffice.com/documents/excel/1763-excel-change-sheet-direction.html