+ Reply to Thread
Results 1 to 3 of 3

Remove Excel's default gray cell borders permanently [Sharing Tips]

  1. #1
    Registered User
    Join Date
    06-21-2023
    Location
    Hanoi, Vietnam
    MS-Off Ver
    Office 365
    Posts
    1

    Remove Excel's default gray cell borders permanently [Sharing Tips]

    Any Excel freaks here? Then you'll probably hate the gray cell borders that appear by default when you start a new workbook. It took me a while to get rid of those lines for good, so I'd like to share the method with you.

    https://www.youtube.com/watch?v=PiE5_m8PDT4
    Last edited by 6StringJazzer; 06-21-2023 at 11:07 PM. Reason: made the video link clickable

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,704

    Re: Remove Excel's default gray cell borders permanently [Sharing Tips]

    Welcome to the Forum jubitips!

    First to clarify terminology, you are talking about gridlines, not borders. This method applies a white fill to all cells in the sheet. Excel does not show the gridlines for cells with fill color, so you are forcing Excel to suppress the gridlines. This is not exactly the same thing as removing the gridlines because white fill is not the same thing as no fill; if you clear the fill later the gridlines are right back again.

    The easiest way to remove the gridlines is go to View in the Ribbon and uncheck Gridlines.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    10-27-2023
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Remove Excel's default gray cell borders permanently [Sharing Tips]

    Thanks for sharing.
    Thanks
    James

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] remove the gray formula in a cell
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2021, 02:21 PM
  2. Replies: 1
    Last Post: 06-24-2021, 04:45 PM
  3. [SOLVED] VBA: Remove vertical borders if cell is blank
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2019, 07:36 AM
  4. [SOLVED] Excell 2010: How to set/reset the default color for cell borders
    By batman in forum Excel General
    Replies: 2
    Last Post: 08-11-2012, 04:23 PM
  5. Permanently Changing Excel 2003 Default Color Templete
    By earthworm in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-01-2010, 01:58 AM
  6. [SOLVED] How can I permanently change the default page margins in Excel?
    By squeegee in forum Excel General
    Replies: 1
    Last Post: 08-09-2006, 02:24 PM
  7. [SOLVED] Cell borders print default rather than custom setting.
    By Phil Hageman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1