In our blog today let’s talk about Borders and Gridlines. Starting with:
Gridlines in Excel
Do you have the assumption that if you print an Excel file, the gridlines will also appear in the final print?
Answer is NO, Gridlines are only present for your convenience and better viewing of the document while editing. So, you can quickly locate cell numbers and use them. Gridlines also help you to see the data inside the worksheet clearly.
If gridlines are disturbing to you or your workflow requires gridlines to not be shown, you can always turn them off.
They are just a visual identifier so that you have an approximation of the cell height, width and other characteristics which can be easily determined by turning on the gridlines.
To turn on/off the gridlines:
Go to the View Tab -> Under the Show section -> Check/Uncheck the Gridlines option to turn on/off the gridlines view.
Without the gridlines your worksheet will look like this
And with the gridlines, it looks something like this.
NOTE: It will not affect the print layout of your page.
Borders in Excel
As discussed in the earlier section we know that anyways gridlines will not appear in the final print of the worksheet.
To make them appear you need to explicitly define borders over tables and cells.
A border gives emphasis over the element it surrounds and it’s always a good idea to add borders over simple tables in your worksheet.
Also, if you want to print the documents with outlines such as borders to make them stand apart in paper, you have to apply borders.
Borders are a great personalization tool which can help you to differentiate data in a single worksheet.
How to apply borders in Excel?
- Select the cells to apply border
- Under the Home Tab, inside the Font Category click on this button’s drop-down list
- You’ll see many options requiring you to choose from a variety of border options.
We’ll select the all borders option. Just click on your desired border option
- Now you’ve applied border to your data
You can verify the above by going to the Print Preview (CTRL+P) of the Sheet.
You can see for yourself no gridlines are appearing in the Print Preview but the applied borders are present.
You can now practice excel online with TechnoExcel without installing any software. Want to try? Click here.
At TechnoExcel :
You can upskill yourself with:
Why us?
Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately
Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!
Class-room of your choice
Upskill yourself by attending classroom or online class.
Flexible timings
Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.
Class-Room Size
With limited students in class, attention to each student's performance will be given.
Industry Ready Curriculum
The course is designed for people who want to work in the industry.
Book your free consultation now
If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.
