Hi, One of my worksheets (Excel X SR1) will not print all of the text within the cells even though it is visible onscreen (but not on print preview). It does not seem to be cutting of at a particular point (like 255 characters), instead it stops printing anywhere from 270 characters to 450 characters. As an alternative, Control+Command+Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015. As pointed out by Shameer in this answer, Alt+Enter now seems to work as well in the new Excel for Mac 2015. Fortunately you can enable gridlines when you print in Excel 2011 to help make it easier to read the spreadsheet. Show Lines When You Print in Excel 2011. Gridlines are the lines that you see in your Excel 2011 spreadsheet when you are looking at it on the screen. ![]() What am I missing? I know on a PC that pivot tables only display 255 characters per cell and so do copied worksheets, but there does not seem to be consistency as to when the text will not print. Thanks, Adam Cell text not printing. Posted:, 03:47 AM Hi If you look in Page Setup, are you printing at 100% or is Excel scaling? If you change the font or use a different font size does that have an effect? -Jim Gordon Mac MVP All responses should be made to this newsgroup within the same thread. About Microsoft MVPs: Search for help with the free Google search Excel add-in: ---------- In article, Adam Torgerson wrote: > 2. Posted:, 05:06 PM On 7/30/03 8:08 AM, in article BB4D2D7A.520%[email protected], 'Adam Torgerson' wrote: > Thank you. I have tried courier new and a couple of others since I know > that some fonts do not display onscreen the same way that they print; none > of them show the entire cell contents on print preview even though the cell > contents display correctly in either normal or page break view. > > The page setup is set for 100%. > Try making sure the print area is large enough. Even if the print area includes all cells with text, any text that goes outside cell boundaries (and outside the print area) won't be printed. ![]() This can happen if printed text ends up slightly larger that the text appears on screen. Let us know if that helps. Keyboard shortcuts for screenshot. -- Jason Kelly Mac Excel Testing. Posted:, 06:03 PM On 8/1/03 10:06 AM, in article BB4FEC0A.2130%[email protected], 'Jason Kelly [MS]' wrote: > On 7/30/03 8:08 AM, in article BB4D2D7A.520%[email protected], > 'Adam Torgerson' wrote: > >> Thank you. I have tried courier new and a couple of others since I know >> that some fonts do not display onscreen the same way that they print; none >> of them show the entire cell contents on print preview even though the cell >> contents display correctly in either normal or page break view. >> >> The page setup is set for 100%. >> > > Try making sure the print area is large enough. Even if the print area > includes all cells with text, any text that goes outside cell boundaries > (and outside the print area) won't be printed. This can happen if printed > text ends up slightly larger that the text appears on screen. > > Let us know if that helps. > Thank you Jason, that seems to have worked. It still cuts off a bit of the letters (like 'g' or 'p') but it is legible. Is there a specific font that I can use to avoid this disparity? By Before you can print your Excel 2011 for Mac spreadsheet, you need to be familiar with Excel’s print options. Head to the Print group on the Layout tab of the Office 2011 for Mac Ribbon, and you’ll find the printing tools you’ll use most often when printing from Excel 2011 for Mac: • Preview: Displays a preview of your document in the Mac OS X Preview application. Adobe Reader or Adobe Acrobat may intercept this action. • Repeat Titles: Displays the Sheet tab of the Page Setup dialog. • Gridlines: Selecting this check box prints all the lines between the rows and columns. • Headings: Prints row numbers and column letters. • Fit To: You can shrink the width and height of the printed output separately so that the content fits in a few less pages. You have several ways to adjust the way you print Excel files on the Sheet tab of the Page Setup dialog, accessed by clicking the Repeat Titles button: • Rows to Repeat at Top: If you want the first row (probably composed of column headings) to repeat on each printed page, use this setting. • Columns to Repeat at Left: This option is like setting a row to print, except you click a column instead. • Print Area: Type in a range, name of a table, PivotTable, query table, or some other named object.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |