Select and copy-paste the Microsoft Excel table to a Microsoft Word document with the source formatting. Now, copy-paste from Microsoft Word to Gmail. As you can see from the screenshot, the problem is solved. Print-to-PDF mysteries revealed. Thus making the format a first-class citizen for all Mac and iPhone/iPad users. Printing to PDF. It’s unlikely that you will have font problems.
![How to format excel spreadsheet for printing How to format excel spreadsheet for printing](http://legacyhelp.fsc.follett.com/content/resources/images/adobe%20print%20dialog.png)
Choosing a print area Before you print an Excel workbook, it's important to decide exactly what information you want to print. For example, if you have multiple worksheets in your workbook, you will need to decide if you want to print the entire workbook or only active worksheets. There may also be times when you want to print only a selection of content from your workbook. To print active sheets: Worksheets are considered active when selected. Select the worksheet you want to print.
To print multiple worksheets, click the first worksheet, hold the Ctrl key on your keyboard, then click any other worksheets you want to select. Adjusting content On occasion, you may need to make small adjustments from the Print pane to fit your workbook content neatly onto a printed page. The Print pane includes several tools to help fit and scale your content, such as scaling and page margins. To change page orientation: Excel offers two page orientation options: landscape and portrait. Landscape orients the page horizontally, while portrait orients the page vertically.
In our example, we'll set the page orientation to landscape. Navigate to the Print pane. Select the desired orientation from the Page Orientation drop-down menu. In our example, we'll select Landscape Orientation.
Keep in mind that worksheets will become more difficult to read as they are scaled down, so you may not want to use this option when printing a worksheet with a lot of information. In our example, we'll change the scaling setting back to No Scaling. To include Print Titles: If your worksheet uses title headings, it's important to include these headings on each page of your printed worksheet. It would be difficult to read a printed workbook if the title headings appeared only on the first page.
The Print Titles command allows you to select specific rows and columns to appear on each page. Click the Page Layout tab on the Ribbon, then select the Print Titles command. Click the East Coast tab at the bottom of the workbook.
In the Page Layout tab, use the Print Titles feature to repeat row 1 at the top and column A at the left. Using the Page Break Preview command, move the break between rows 47 and 48 up so it's between rows 40 and 41.
In B ackstage view, open the Print Pane. In the Print pane, change the orientation to Landscape. Change the margins to Narrow. Change the scaling to Fit All Columns on One Page. When you are finished, your print preview should look like this.
I am actually working on a simple macro to save the active sheet as a PDF file with a special name. The macro I have created is working but it is saving every sheets in several PDF and put the name of the sheet at the end of the file name. If you could help me it would be great, i cannot see what is the problem.
Here is my macro: Sub PrintPDF Dim wksSheet As Worksheet Dim strFile As String Set wksSheet = ActiveSheet 'strFile = Format(Now, 'yyyymm') & '.pdf' strFile = 'blabla' & ' & Format(Now, 'yyyymm') & ' & 'name2' & ' ' & Replace(Replace(wksSheet.Cells(1, 2).Value, ' ', '), '.' , ') & '.pdf' strFile = ThisWorkbook.Path & ':' & strFile wksSheet.SaveAs Filename:=strFile, FileFormat:=xlPDF End Sub. You have discovered a bug in Excel Mac 2011 VBA! Despite using your syntax of ActiveSheet.SaveAs or my preferred:- ActiveWorkbook.SaveAs Filename:=strFile, FileFormat:=xlPDF, PublishOption:=xlSheet Excel Mac 2011 VBA will always save all worksheets. If you turn on the Macro Recorder and save a sheet to PDF, it works as expected and writes out the ActiveWorkbook version to the code module. Now immediately re-run that very code that it generated and it yields a different result!
I can confirm that this bug does not exist in Excel Mac 2016 and that the worksheet syntax is no longer supported. You will need to change to the workbook syntax I included above.