Cannot See Gridlines In Excel 2010

Contents

Ads by Google 1. References (2) Microsoft Office: Support: Show or Hide Gridlines on a WorksheetMicrosoft Office: Support: Apply or Remove Cell Borders on a Worksheet Resources (1) Microsoft: Microsoft Excel About the Author Jacob Then choose Options and Advanced. But depending on the kind of a data a worksheet contains, it may not have the gridlines. http://trado.org/in-excel/cannot-see-gridlines-in-excel-2007.php

We thank you for understanding! Two or more nonadjacent sheets Click the tab for the first sheet. Name E-mail (not published) Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. Reply Laura says: January 9, 2015 at 10:43 pm I have a spreadsheet I received from someone else.

Excel Gridlines Missing From Some Cells

Click on clear and then select 'Clear Formats'. Reason for hidden gridlines 4: The gridlines have been colored white Click on the File tab. Follow these steps to change the color to default again:- Step 1: Go to File -> Options.

Sign in to add this to Watch Later Add to Loading playlists... Show Gridlines MS Excel provides an option to hide gridlines for users who do not like them. If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Excel Gridlines Not Showing On Some Cells Note: If you want to hide gridlines in the entire spreadsheet, just uncheck the Gridlines or View options.

There are 4 possible reasons that gridlines are no longer visible in Microsoft Excel. Gridlines In Excel 2013 Category Howto & Style License Standard YouTube License Show more Show less Loading... If you like, you can change the color of the gridlines for a particular worksheet. Thanks so much #2 by Nick on 10/25/12 - 12:26 PM Big help thank you!!! #3 by Relieved on 11/8/12 - 9:22 AM Much Appreciated - Thought my precious spreadsheet had

On the right hand side of the toolbar, you will see 'Clear'. How To Show Lines In Excel When Printing Sign in to report inappropriate content. Whether you decide to show gridlines in your worksheet or hide them, go ahead and find below different ways to fulfil these tasks in Excel 2010 and 2013. When you are satisfied with the look of the gridlines, click "OK" to apply the formatting changes to the cells that you selected.

Under the border tab, change the Color to Automatic. More about the author See our post on Printing Gridlines for additional information.Excel Formatting is covered in these Excel classes: Basic Intermediate Pivot Tables & Charts See our other Excel topics.

Related Blog Entries We have a shared Excel doc that everyone gets to screw with, so I never know what I'm going to encounter. #12 by Amy Moore on 8/12/13 - 10:38 AM Thank If you simply change the fill color to white, the gridlines will remain hidden. Excel Chart Gridlines

In the image below, you will notice that by going to the "View" tab and clicking the check box beside "Gridlines", you can toggle the lines on and off. Show / hide gridlines in Excel by changing the fill color One more way to display / remove gridlines in your spreadsheet is to use the Fill Color feature. For more information, see Apply or remove cell borders on a worksheet. http://trado.org/in-excel/cannot-run-macro-in-excel-2010.php Then hold down CTRL while you click the tabs of the other sheets that you want to select.

Step 1: Press Ctrl + A to select all the cells. Excel Gridlines Not Showing Up The Tech Train 61,095 views 1:42 Microsoft Excel 2013 Tutorial | Using Print Titles And Print Areas - Duration: 5:45. There i just clicked on black and white-not gridlines, and the gridlines I could see on my spreadsheet returned to my printed sheet like magic! #6 by gie on 5/7/13 -

Loading...

I discovered that the user had filled the cells with the color white. Sally Ulianich 1,775 views 3:18 How To Print The Gridlines In Microsoft Excel - Duration: 1:42. And you don't need to draw cell borders to make your data-table more readable. Excel Gridlines Disappear When Color Added To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet.

So, navigate to Home -> Styles -> Conditional Formatting -> Clear Rules. Subscribe to the Houston Chronicle | Shopping | Classifieds | Obits | Place an Ad | La Voz Register | Sign In Home Local In Local Neighborhoods Houston & Texas Traffic Also, remember that these settings apply to one sheet (selected sheet) at a time. news Make sure that you are on the Border tab in the Format Cells window.