While Excel is great for manipulating large amounts of data, it can take time to learn how to use the program effectively. If you’re struggling to distinguish one cell from another, or perhaps just feel the formatting is missing something, you might want to try enhancing your gridlines.
Solution:
- Open your Excel spreadsheet
- Highlight the area you’d like to utilise gridlines/borders for
- Click the border icon
- Setup your grid
- Choose a thicker line
- Choose a darker line colour
- Confirm with OK
In this post we’re going to utilize the display settings for Excel to ensure your gridlines are enabled and visible- whilst also showing you how to set a darker color for your gridlines. Don’t worry if you’re not too adept with Excel, it will all be explained within a step-by-step guide featuring various images.
   |
Quick links:
Enabling and changing the color of your Excel gridline to make it bold or darker
 |
Step 1 – Open your Excel spreadsheet
- Once you have your spreadsheet open, ensure you have some form of table set up. We’ll be placing a grid around said table afterwards.
Step 2 – Select the area you’d like to border
- Click and hold from the top left corner of the grid, drag your cursor to the bottom right to select the entirety of the table.
Step 3 – Open more borders via the home tab
- From the Home tab select the grid icon (as shown in the image below). Using the dropdown created, scroll to the bottom and select More Borders.
Step 4 – Select a colour a colour and style
- To make your bordered gridlines stand out more, we recommend using a thicker line style, combined with a darker colour to create the effect of having bold lines.
Step 5 – Configure border layout and confirm changes
- Simply click the boxes corresponding with where you’d like the enhanced lines to appear. If you want them everywhere within the selected area, simply select all boxes, excluding the two diagonals (bottom left and bottom right). Confirm your changes by selecting OK.
Step 6 – Review your changes
- Have a look at your spreadsheet. If you’re unhappy with the produced effect, try again with a different style and colour — or consider playing around with the grid configuration.
End note
Recap
Excel provides a border function that can be utilised to format and customise your spreadsheets. This can be utilised to create a bold effect on your gridlines by altering your border’s colour to be darker, whilst also making the border appear thicker.
Farewell
As usual, this section is dedicated to thanking readers for their support. We’d be pleased to know you found this post useful and/or informative. If you have any more Office 365 related queries, please consult our related articles (listed below). However, if you have other queries, consider looking at the rest of the site. We’re frequently posting new stuff each week and may just have the guide or troubleshooting tips you need. Regardless, we wish you a good day/night. Farewell readers.
Our related articles:
- A complete guide to using OneDrive to transfer files to a new computer – OneDrive is a cloud storage platform offered as part of the Microsoft 365 suite. With it, your various folders and files may be stored online and downloaded for use from anywhere with an internet connection. As such, OneDrive is very useful if you’re looking to get files from one computer to another without wanting to mess around with storage devices.
- A complete guide to fixing OneDrive sync issues on Mac – OneDrive sometimes has issues, and many users have claimed that OneDrive isn’t synchronizing on their Mac OS devices, however, there are solutions available. In this blog, we will cover the most effective approaches to help users fix sync issues on their OneDrive devices. We will address some of the causes of why OneDrive won’t sync correctly and what users can do to help resolve these issues. Use the guide below to see how you can resolve OneDrive sync issues on Mac OS devices.
- Ways to delete a OneDrive shared library – OneDrive’s Shared libraries (or SharePoint sites) serve as large collections of various documents, media and content for your team/organization. In this post we’ll be giving you a short image guided walk through on deleting your OneDrive shared libraries. Additionally, to ease any potential confusion, we’ll also go over why you may still be seeing your shared library afterwards.
- Guide to deleting document libraries in SharePoint Online – SharePoint Online uses document libraries to store various files and folders created by you (the user). If a user for some reason decided they no longer required a document library, they could exercise the ability to delete it. Albeit, that requires actually knowing how to go about it. Fortunately for us, it’s quite straightforward. In this short post we’ll be guiding you through deleting document libraries with an image assisted walkthrough. We’ll additionally let you know why you may be unable to delete a certain library and under what circumstances your lost data can be restored.