Excel Tricks with Tejraj

What are Gridlines? In our very first blog post “ Introduction to Excel ” we have learned about cells which are intersection of rows and columns . There are multiple cells placed adjacent to each other in single excel sheet. These adjacent cells are separated by single line called as “Gridlines”. Gridlines will help us to read the data easily. In below image, Gridlines are shown with the arrows. Why to Hide & Unhide Gridlines? Some people will like to hide the gridlines while some people will prefer to work with gridlines. This will be complete choice of individual based on their requirement. Some people will prefer to always work with gridlines which will help them to read the data entered in excel sheet easily. Some people will prefer to hide the gridlines to make their excel template beautiful and attractive. At the end it’s the excel user who have to decide whether he/she want to work with the gridlines or work without gridlines by hiding them. You can easily identify the dif...

Previously we have posted blog post on “Formula Bar” in excel. Formula bar can be used for below things: 1. To see formula applied in active cell 2. To see data entered in active cell. Sometimes we want to hide this formula bar to maintain the confidentiality of the data. For example, we have prepared one excel file where we have applied various formulas but we don’t want to show these formulas to other people. In this case we can hide the Formula Bar. Let’s learn about how we can hide or unhide “Formula Bar”. 1. Go to “View” tab. 2. Once we go to “View” tab, we can see “Formula Bar” command under ‘Show’ group. We can either check or uncheck the checkbox for this command. By default this checkbox is checked. 3. We have to just uncheck this checkbox and with this we can hide “Formula Bar”. 4. To unhide this formula bar we have to again check this checkbox. In this way, we can hide or unhide checkbox in excel.

In this blog post we will learn to Freeze & Unfreeze Panes in excel. Whenever we are working with large volume of data we may need to scroll our screen top-down or left-right to refer the data which is located at top of our sheet or on the left side of our sheet. Scrolling the excel screen will consume lot of time. To tackle this situation excel has provided one excellent feature in which we can freeze the desired rows or columns. This feature is called as “Freeze Panes”. Freeze Pane command we can find in “View” tab under “Window” group as shown in below image. Once we click on “Freeze Panes” command, we can see 03 more options as below: 1. Freeze Panes 2. Freeze Top Row 3. Freeze First Column We will see all these 03 options one by one. Freeze Panes: This option will freeze the rows which are on top and which are on the left side of the selected cell. All the other cells can be scrolled top-down or left-right. This will help us to lock all the rows above and all the columns on th...

In this blog post we will learn to “Insert Comment in Excel”. To explain this topic we have prepared raw data where we are collecting information of few students. The information which we are collecting is: 1. Name of Student 2. Age 3. Gender 4. Date of Birth But there might be chance that if we share this excel sheet and ask each student to fill up their data by their own then the completed sheet may get mess us due to non-uniformity. This is one example how student may end up filling the data. There is no uniformity at all in this data. Some students have entered their gender with just initials while others have entered the full word. Same thing happened with DOB as the date format entered in last column of table is not uniform. To maintain the uniformity in the database we must provide some instructions about how to fill the information in this table. For this we can insert comments for the header cells (as shown in below image) which will provide instructions about how to fill up ...