Save excel as pdf changing its orientation to horizontal

0 votes

I have an excel sheet with too many columns, so when I save it as a PDF the file its in too many pages and its not easy to read . I need to save the sheet as pdf but before I want to change its orientation to horizontal so I can read the pdf with no problem. Is the same you can do when you print but I want it when I save an excel file as pdf. Is there any option I can choose?

 I dont mind if someone gives me a code for a macro using my selection as an object.

Mar 28 in Database by Edureka
• 13,640 points
13,864 views

1 answer to this question.

0 votes
To begin, go to the page layout ribbon and select 'orientation.' Choose a landscape. Then, from the file menu, choose 'Save as Adobe PDF.' Your spreadsheet has now been saved as a landscape PDF.

That's the short answer, however there are a few formatting considerations you should make. To begin, ensure that your spreadsheet columns do not exceed the width of your page. If they do, the 'overflow' columns will be duplicated on extra pages. Second, including grid lines in a spreadsheet output makes it much easier to read.

To do so, select the border tool from the Home ribbon's 'font' section. You may then add grid lines and even format them to make them easier to read. You can also utilise one of Excel's prefabricated layouts by going to the'styles' section of the home ribbon (these work really well if you have a colour printer).
answered Mar 30 by gaurav
• 22,040 points

Related Questions In Database

0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
798 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
563 views
0 votes
1 answer
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
144 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
501 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
63 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
110 views
0 votes
1 answer

Importing notepad data to excel (difficult split)

Excel: How to Use It On the Data ...READ MORE

answered Mar 14 in Database by gaurav
• 22,040 points
75 views
0 votes
1 answer

Java Apache POI Excel save as PDF

For the software to run, you'll need ...READ MORE

answered Mar 31 in Database by gaurav
• 22,040 points
2,151 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by gaurav
• 22,040 points
183 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP