Gridlines are borders that help us identify the contents in different cells or columns. We can apply borders, but the worksheets’ gridlines make it easier. We can remove or hide gridlines in google sheets in the graphs. Even we can hide the gridlines in google sheets from mobile as well. Let’s go through all the…
Gridlines make the contents in the cells more visible and readable. But sometimes, we might want to hide the gridlines. Without the gridlines, the workbook might look clean. Besides, we don’t always need to divide the contents. So, there are a few ways to hide the gridlines in excel. We can hide or remove the…
One of the primary purposes of excel is to make our work effective and efficient. Now, to do that, we need to avoid making fewer mistakes when working with tons of data in excel. We can insert a message in a data range or column where we might see a message. That will give us…
To create an error message in Excel, go to the ‘Data’ tab, and click the ‘Data Validation’ option. Or press “Alt + A + V + V”. Then, go to the ‘Error Alert’ tab. And create your error message using the ‘Style,’ ‘Title,’ and ‘Error Message’ boxes. Creating an error message for data validation is…
You created a drop-down list in your worksheet. There are blank cells in that column from where you want to delete the drop-down list. Maybe you want to remove the drop-down list from the whole column or from specific cells where you don’t need that drop-down list anymore. Now you might be wondering how to…
There might be some situations where you need to add or remove an item from your drop-down list. In this situation, you might need to learn how to edit drop-down list in excel. Select the cells/column/row or range you want to edit. Then go to the “Data” ribbon. Click on the “Data Validation” option under…
There are many situations where we need to sort items by category. We might need to put each category name beside those items. Now, it might be very time-consuming to write every category name every time or copy-paste the names. The practical solution could be creating a drop-down list. You might be asking how to…