In this lesson, I’m going to be showing you how to:
- Understand what is GRIDLINES and ROW & COLUMN HEADINGS in Excel
- Display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Watch this tutorial directly on our YouTube channel and Subscribe
Thanks for watching!
Do you want to learn to create your own website?
If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.
CLICK HERE to read our review about this amazing learning platform, if you want to know more.
When you’re ready move onto:
Lesson 42: How to set and print rows & titles automatically at the top of each page in Excel
Or go back to:
Lesson 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel
Lesson 39: How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel
Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel
Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel
Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!
Lesson 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel
Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel
Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?
Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel
Lesson 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!
Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel
Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel
Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel
Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel
Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?
Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?
Lesson 24: How to SORT data in ASCENDING order in Excel
Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel
Lesson 22: How to RENAME a worksheet in Excel
Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel
Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?
Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?
Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor

I love your calm, patient, and thorough teaching style. Learning about gridlines, as well as row and column headings, is good knowledge to have. In this lesson, I also learned how to print gridlines, and row and column headings. Thank you, Habib.
You’re very welcome Michael. Thank you for the kind compliments, much appreciated, and it just carries on to continue to motivate me to make more videos lessons. Take care
Habib (ICT tutor)
Hi Habib,
It is a very useful video for me. I really don’t know how to print gridlines according to your method. In the past, I just added gridlines in the worksheet and then printed it out. Now I know how to print gridlines from the page setup option which is very convenient for me. Thank you for your sharing.
All the best,
Alex
You’re very welcome Alex. The beauty of Microsoft Office, is that you can do the same task using few different methods. We all just need to identify which method is best for us individually. Take care 🙂
Habib (ICT tutor)
Hi,
Love these tutorials you do. They are so helpful and have got me out of a mess so many times.
Can’t wait for the next one.
Your a life saver.
Hi,
I’m so glad these tutorials have been helpful for you. I’m planning on doing many more ICT video tutorials on Word, owerPoint, Plublisher and so on. So keep visiting our YouTube channel here https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg?view_as=subscriber for the latest contents.
All the best
Habib (ICT Tutor)
I thought I knew quite a lot about Excel but you´ve just proven me wrong lol. Something so basic and simple but extremely useful! Thank you again.
You’re welcome Susan. Thank you for your lovely feedback. Glad to hear you are finding my tutorials helpful. Please visit our YouTube channel for the latest video tutorials here: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg?view_as=subscriber
Best wishes
Habib (ICT Tutor)
Quite a collection, Habib! Thanks for another interesting possibility in Excel. It is always good to know all the tools of a program one works with. That way we can choose what suits us most. 🙂
Hi Hannie,
That’s exactly it! Thank you for your valuable feedback. Please share it with your family and friends so they can benefit from FREE lessons too. Also, you can visit our YouTube channel for more video like these here: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg?view_as=subscriber
Kind Regards
Habib (ICT Tutor)