+ Reply to Thread
Results 1 to 4 of 4

How to clear the cell borders ?

Hybrid View

Zul How to clear the cell borders... 01-31-2005, 04:26 PM
cycling-rod To remove the gridlines,... 01-31-2005, 05:17 PM
Zul thanks, it worked perfectly... 01-31-2005, 05:28 PM
cycling-rod To remove gridlines... 01-31-2005, 07:02 PM
  1. #1
    Registered User
    Join Date
    01-31-2005
    Posts
    2

    How to clear the cell borders ?

    hello,

    how do i clear all the cell border lines for the whole worksheet, i mean the default ones, i wish to put lots of texts without any borders with only the calculation part covered with borders.

    i have this screenshot in the file attachment showing an excel worksheet without any borders, the problem is i dont know how to set them and i cant find any setting which enable me to do so

    thanks for any suggestion
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    To remove the gridlines, click on Tools, Options, untick Gridlines, and click on OK.

  3. #3
    Registered User
    Join Date
    01-31-2005
    Posts
    2
    thanks, it worked perfectly well

  4. #4
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    To remove gridlines selectively, say only where you want to put text, yet leave the rest of the gridlines showing, colour the gridlines with the background colour (white). Select a range or columns and rows where you want to put text and use the Fill Colour (bucket symbol) to fill the selected ranges, columns and rows with white. The gridlines will merge into the white background and disappear.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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