Hello everyone, The Teacher here and welcome to another lesson from Excel 2016 Tutorial Series
In this lesson, we will learn that how to view and print Excel's predefined gridlines
that you see on every worksheet. My name is Rajiv and stay tuned for this short Excel 2016 Tutorial video as we will be right back
This is for your information that whenever you run Excel and start working with new workbook
the gridlines that you see on each worksheet doesn't get printed by default and you can
confirm this through Print Preview window. See no gridlines there. That not only apply to the blank workbooks but even if I fill some data here for your
reference and then you can notice that by default Excel is still not showing any gridlines
in the Print Preview window and those lines that you were seeing in the worksheet will
not be printed either. This default setting also apply to the saved workbooks unless you have changed the setting
for yourself. Let's see an example of the invoice worksheet. See no gridlines here in the Print Preview window
So how we can use this gridline feature more efficiently in Microsoft Excel
Let's move to the Project Planner worksheet first. You might sometime create a worksheet like a form or an invoice or something like this
Project Planner worksheet. Everything seems nice here except for the default gridlines
I don't want to view the predefined Excel gridlines for this specific worksheet
So what I do here is to go to the Page Layout tab and here under Sheet Options, you can
see two options under Gridlines, View and Print. By default, View is checked and as I said earlier it is checked by default for every
new worksheet. So as I don't want to see the gridlines in this worksheet, I uncheck this option and
you can instantly see that gridlines are gone for good and my worksheet looks more attractive
now without those unnecessary gridlines. Do note that the same View Gridlines option is also available in View tab under Show section
So to show or hide gridlines, you can either go to Page Layout tab or to View tab
On the other hand, if we look at the Invoice worksheet, here I have designed an invoice
and don't want to bother myself applying borders to the entire worksheet manually
I want Excel to print the predefined borders automatically to the entire worksheet where
contents have been written. To do this, I again move to the Page Layout tab and this time I make a check mark on the
Print under Gridlines. So if we see the Print Preview of this worksheet now, then you can see that the predefined
borders are now visible in the Print Preview window and these borders will get printed automatically
This saves me applying the borders manually and is very much useful for the larger worksheets
with a 100,000 records. The only difference between applying borders manually through Borders drop-down menu or
through Borders from Format cell is, you have choice to apply different border formatting
styles like you can apply border to a specific area and you can change the line style and colors
You can see an example in the Duplicate Invoice worksheet, where I had applied borders to
specific areas only. Whereas, if you go and print the default gridlines, Excel will print every border on your worksheet
doesn't matter you want it or not and only the outside border will be darker and the
inside borders will be lighter and dotted. So the choice is yours, these options might be helpful when you don't have time to apply
borders on larger worksheets. I hope the information in this lesson will be useful to you and you might learn something new
Don't forget to hit the Thumbs Up button and do share our videos with your friends
Subscribe to our channel for more upcoming tutorial videos. Thanks for watching and take care