how to put gridlines back in excel

Reveal Hidden Gridlines in Excel: A Simple Step-by-Step Guide

By Amanda Thomas
AD

Ever found yourself staring at a seemingly blank canvas in Excel, only to realize that the gridlines have vanished, making it challenging to work? Don't worry, bringing them back is a breeze. Let's explore how to restore those vital gridlines in Excel in just a few simple steps.

Gridlines are these fine lines that run vertically and horizontally, helping us navigate and align our data. They're not visible by default to prevent clutter, but they're easy to display when you need them. Let's dive right in and learn how to put gridlines back in Excel.

Displaying Gridlines in Excel

The process to show gridlines is nearly identical across all Excel versions, so whether you're using Excel 2010, 2016, or the latest version, these steps will guide you.

AD
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
Courses and Tutorials in Templates | Envato Tuts+
Courses and Tutorials in Templates | Envato Tuts+
How to show gridlines in Excel; hide (remove) lines
How to show gridlines in Excel; hide (remove) lines

First, let's ensure that the Developer tab is visible in your Excel ribbon. If it's not, you can enable it by following these steps:

Enabling the Developer Tab

1. Right-click on the Excel Ribbon and select 'Customize the Ribbon'.

How to Hide Gridlines in Excel Step by Step
How to Hide Gridlines in Excel Step by Step
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!

2. Check the box next to 'Developer' and click 'OK'.

Displaying Gridlines Using the Developer Tab

Now that the Developer tab is visible, you can display gridlines in just two clicks:

AD

1. Click on the 'Developer' tab in the Excel ribbon.

2. Click on 'Show Gridlines'.

Instantly, your Excel worksheet will be filled with gridlines, making it easier to work with your data.

AD

Displaying Gridlines in Other Excel Views

Gridlines aren't just useful in the Normal view; they can also be helpful in other Excel views like Page Layout and Page Break views. Let's see how to display them in these views as well.

Remember, these views are particularly useful when you're preparing to print your worksheet or saving it as a PDF. The gridlines can help you anticipate how your data will look on the final printout.

Page Layout View

1. Click the 'View' tab in the Excel ribbon.

AD

2. Click 'Page Layout'.

3. Click 'Show' in the 'View' group, then select 'Gridlines'.

Page Break View

1. Click the 'View' tab in the Excel ribbon.

2. Click 'Page Break'.

3. Click 'Show' in the 'View' group, then select 'Gridlines'.

And there you have it! Gridlines are a fundamental tool for working with data in Excel. By learning how to put gridlines back in Excel, you're equipping yourself with a powerful navigational aid that can significantly boost your productivity. So go forth and make every worksheet a sparser, more manageable place!

AD