Navigate to the File menu and select Options. The Excel View Preference's Window options has "Show Gridlines" checked, withOpen the desired Excel Worksheet. Some background: I have a 2013 MacBook Pro with Excel for Mac 2011 Version 14.7.7 (170905). Change the gridlines: In the Gridlines section of the sidebar, click the buttons to add or remove gridlines from the table body, from the header rows and columns, This topic has been raised before, and not satisfactorily answered in my opinion. Do any of the following: Change the outline: In the Table Outline section of the sidebar, use the controls to change the line type, thickness, and color. Click the table, then in the Format sidebar, click the Table tab.More about tools that help you align and place text and objects: Snap charts, pictures, and objects to a grid to align them in Word. To hide the gridlines, clear the Gridlines check box. To show the gridlines, in Excel, PowerPoint, or Word, click the View tab, and then check the Gridlines box. Click OK to disable lines in the current sheet.If you want to print gridlines in Excel, see Print gridlines in a worksheet. Uncheck the Gridlines checkbox. Scroll down to Display Options for this Worksheet.
Show Gridlines In Excel Mac 2011 VersionClear the Gridlines check box in the Show/Hide section of the ribbon. Using these options, when printing a table that includes cells that have borders with the lightest weight line border selected (see the "Alex" column),Turn off gridlines in your Excel applications TechRepublic. The Excel "File>Page Setup>Sheet>Print" option has "Gridlines" checked. The "Color" set to "Automatic". Most charts include major gridlines to show where bars or columns meet or surpass a. Using these options, when printing a table that includes cells that have borders with the lightest weight line border selected (see the "Alex" column), the difference between the line weight of the borderedCells is essentially identical to the line weight of the table's gridlines. The Excel "File>PageSetup>Sheet>Print Options" has "Gridlines" checked. The Excel View Preference's Window options has "Show in Workbook - Gridlines" checked, with the "Color" set to "Automatic". Here is an illustrative example, from a PDF print copy of the file:The next example shows the same excel file, but on a 2019 iMacPro with Excel for Mac 2019 Version 16.33 (20011301). If the background color (15) Titus is a global leader in delivering software and solutions that help organizations meet their data identification, classification, and protection needs.The difference between the line weight of the bordered cells is clearly distinguishable from the line weight of the table's gridlines. One user ("Gary") stated " PleaseAllow us to reduce the weight of Gridlines in Excel 2016. This is clearly a problem that only the developers can resolve.In following your suggestion to provide feedback to the Excel developers via UserVoice, I discovered that several other users have complained about Excel (for Mac) having an excessively heavy line weight. This is not a user-correctable fix, and should be investigated and resolved by the Microsoft ExcelThanks Chitrahaas for confirming my observation that the gridline weight in Excel for Mac is inappropriately too high, and cannot be corrected by the user. The gridlines should be lighter in line weight than the lightest weight selectableBy the user on the border options window, and the gridlines should also be lighter in weight than the lines that form the border of the excel table itself. This isQuite clear when viewing the entire documents rather than just a portion of the tables as in the screen shots above.The bottom line is that there is a distinct difference in the line weight of the table's gridlines between the 2011 version of Excel for Mac and the 2019 version of Excel for Mac. It looks very unprofessionalWith no class to it when we submit a printed copy to clients with bold lines all over it. (November 06, 2018)* It annoys the **** out of us. Why would they change something so basicThat effects everything previously built? Please reverse the change that was made to the 2011 version. (October 12, 2018)* I agree. Was not like this in 2011 - please reverseThe change that was made. Here's an example of some of the UserVoice comments that were posted:* When you print there is no difference in line weight between a grideline and a border line. When projected on screen, the gridlines by default are invisible. When I saved as PDF in 2019 my gridlines by default were really dark, but not as dark as yours.I went to Excel > Preferences > Gridlines and chose a shade of gray, which improved the situation a lot.Your question caught my eye because I am having an opposite problem with Excel and projection. (November 04, 2018)I have just submitted my comments and suggestion at the UserVoice forums, and am hopeful that between both this site and the UserVoice site, someone with accountability and concern for the user base of Excel for Mac will take action and not let this problemFinally, I would like to request that my question here on the "Answers" forum not be marked as "Closed" or "Solved" until such time as the developers take the action needed to implement the necessary coding update and successfully deploy it.I was sort of able to reproduce the issue you've described. Consequently,This shared printer uses the same print driver for documents whether printed from the iMac Pro or the MacBook Pro. I send print jobs to this printer from my iMac Pro via a USB cable, and from my MacBook Pro wirelessly, using the printer sharing feature on the iMac Pro. Here are the preference selection window screenshots for both Excel 2011 and Excel 2019, reflectingThis description in the yellow highlighting:I only have a single printer, a HP LaserJet MFP M426FDW, which is not a color printer. In the Excel preference window (for both Excel 2011 and Excel 2019), if the userSelects the option to "Show gridlines" and leaves the Color selection as "Automatic", then the color of the gridlines, both on screen and when printed, will be gray. I had never mentioned that I was selecting the color black for my gridlines, and in fact, I use Excel's default color selection of "grey gridlines". The only difference is with the versions of Excel that are being used. It's the same documentWith the same Excel Gridline preferences, using the same printer. Cell borders that appearTo be virtually identical to gridlines is problematic in printed Excel documents, even when the user selects the "Automatic" gray gridline color.As I mentioned in my initial post, there is a distinct difference in the appearance of gridlines when the same Excel document is printed from the iMac Pro using Excel for Mac 2019, versus from my MacBook Pro using Excel for Mac 2011. Printing very narrow line weights such as the Excel gridlines is not quite as predictable. With variable dot size and variable dot placement technology, printing grayscale photographs is possible. International holidays calendar for macFingersYour suggestion for me to provide feedback via Office applications and reference to the article " How do I giveFeedback on Microsoft Office?" was entirely appropriate. I attempted to provide a concise description of the issue, but also added a link to this website/page that has many more details and screen shots. The resulting online form does not allow the user to add verbose comments and is limited to attachingA single screen shot of an Excel document that is "a work in progress with a bug or issue" apparently. However, the best way is to add feedback via Office applications as it will report to the related developing team directly.The best way to send feedback is using the Send Feedback feature in thePowerPoint app by clicking the Smile button.Thanks for your suggestion Jim, and I just sent feedback by selecting the Smile button in the upper right corner of the Excel 2019 application screen. Finally, users of Excel for Mac 2016 have reported the same issue (assuming they were not AI bots).Thanks for taking your time and adding your comments to the related idea in Excel for Mac UserVoice. There is no similar problem with Excel for Mac 2011. Relatively few of the posts on the 50 pages had status updates about suggestionsThat were being worked on, or deployment dates for fixes, despite many having received upvotes from other users who visited the forum. The form also limits the type and quantity of screen shots that can be attached to a single screen of an in-progress Excel page.Finally, this latter developer team forum lists 50 pages of suggestion and requests, some of which included similar comments about gridline weights dating back to Excel for Mac 2016. Consequently, I used Excel's Help menu link (shown below) to submit my comments.Once I accessed the iMac Pro and the Excel for Mac 2019 application, I could see the Smile icon in the upper-right corner of the window as shown below.I posted my comments at the online form that appeared after clicking on the "unsmiley" face, and noted that the comment box had a character restriction that prevented me from giving a significant amount of feedback (compared to the UserVoice and AnswersForums allow). However, because my MacBook Pro is my primary computing device and it has Office for Mac 2011 installed, I didNot see the "Smile" icon at the upper-right corner of the Excel 2011 application window.
0 Comments
Leave a Reply. |
AuthorKevin ArchivesCategories |