Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| Publish Date not found | ![]() 0 Views |
Those iconic spreadsheet boxes are the gridline. gridlines are the faint lines that appear around cells on a worksheet. These lines help to visually distinguish and organize data in rows and columns. Gridlines make it easier to read and understand the layout of your spreadsheet, especially when you have a large amount of data.
If you want you can show, hide and print gridline in excel. But there is a problem. There is no built-in solution to remove gridline in excel but we are about to learn a workaround.
Follow the procedures below to remove gridlines from specific cells in excel without any formula and vba. Also, we’ll be able to remove those specific gridlines from the print also.
*Procedure 1:*
*Step 1: Select the cell or cells from where you need to remove the gridlines
*Step 2:* Under the home tab click on fill color dropdown.
*Step 3:* Select white as fill color.
Done. Now those gridlines are removed. You won’t be find those in your worksheet as well as printed copies.
*Procedure 2:*
*Step 1: Select the cell or cells from where you need to remove the gridlines
*Step 2:* Under the home tab click on /”Merge & Center/”.
Done. Now those gridlines are removed. You won’t be find those in your worksheet as well as printed copies.
This is how we remove gridlines from specific cells in excel
#Excel #Gridlines #Clear
Thanks for watching.
—————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
—————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd
Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.