Rotating a print 90 degrees

Allenisto

New Member
Joined
Feb 16, 2015
Messages
12
Hi all,

I'm printing out some barcodes on my spreadsheet but I'm running into a problem: My labels that the barcodes need to go on are longer vertically than they are horizontally, but the barcodes need to print out horizontally. Rotating the text in the cells 90 degrees does something odd to the barcode text so it becomes unreadable by my barcode scanner, so I need to somehow rotate the print itself by 90 degrees, but not the cells themselves. Changing the print view to landscape only makes half the barcode label print.

If anyone here could give me a suggestion I would really appreciate it. I can provide pictures if needed, and explain further if something isn't clear. Thanks!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
It's the font itself that doesn't handle being tilted sideways in Excel, so I'm looking to fit the entirety of the print area on a print area that's been tilted 90 degrees, similar to the "rotate 180 degrees" option that flips the image upside-down, but 90 degrees instead.
 
Upvote 0

Forum statistics

Threads
1,224,943
Messages
6,181,915
Members
453,071
Latest member
Gizmo2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top