Skip to content
Analytics Empire Logo
  • Excel Basics
  • Graphs & Charts
  • Excel Functions & Formulas
  • Excel Troubleshooting
  • Advanced ExcelExpand
    • Pivot Tables
    • Macros/VBA
  • About Me
Analytics Empire Logo

Author: Ahsanul Haque

Hi! I'm Ahsanul Haque, a graduate student majoring in marketing at Bangladesh University of Professionals. And I'm here to share what I learned about analytics tools and learn from you.
  • Excel Basics

    How to Show Gridlines in Excel (With 3 Shortcuts)

    ByAhsanul Haque September 9, 2022January 8, 2024

    Sometimes, it’s hard to recognize the contents in the cells without gridlines. Gridlines separate the cells’ contents to understand these better and make them more readable. So, you might need to know how to show gridlines in Excel. We can show gridlines in Excel from two places: the view ribbon and the page layout ribbon….

    Read More How to Show Gridlines in Excel (With 3 Shortcuts)Continue

  • Graphs & Charts

    How to Make Graph Paper in Excel (7 Easy Steps)

    ByAhsanul Haque September 7, 2022February 3, 2024

    There are several uses of graph paper. Whether you’re working in a statistical field, mathematics, or anything related to data, you might sometimes need to know how to make graph paper in Excel. First, we need to format the row height and column width. Then, enable the print option, customize the margins and gridlines of…

    Read More How to Make Graph Paper in Excel (7 Easy Steps)Continue

  • Excel Basics

    How to Show Gridlines in Google Sheets (In 3 Clicks)

    ByAhsanul Haque September 3, 2022August 18, 2023

    You can show gridlines in Google Sheets by clicking on the “View” tab, putting the mouse cursor in the show option, and ensuring that there is a tick mark beside the “Gridlines” option. Gridlines make the difference in the worksheets while seeing the content in those columns or rows. Sometimes you might need to hide…

    Read More How to Show Gridlines in Google Sheets (In 3 Clicks)Continue

  • Excel Basics

    Hide Gridlines in Google Sheets (Within 2 Clicks)

    ByAhsanul Haque August 29, 2022March 7, 2023

    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…

    Read More Hide Gridlines in Google Sheets (Within 2 Clicks)Continue

  • Excel Basics

    Hiding Gridlines in Excel (With 3 Shortcuts)

    ByAhsanul Haque August 29, 2022March 7, 2023

    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…

    Read More Hiding Gridlines in Excel (With 3 Shortcuts)Continue

  • How to Create an Input Message in Excel
    Excel Basics

    How to Create an Input Message in Excel? (3 Easy Steps)

    ByAhsanul Haque August 29, 2022March 7, 2023

    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…

    Read More How to Create an Input Message in Excel? (3 Easy Steps)Continue

  • How to Create Error Message in Excel
    Excel Basics

    How to create error message in Excel (3 Simple Steps)

    ByAhsanul Haque August 29, 2022August 18, 2023

    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…

    Read More How to create error message in Excel (3 Simple Steps)Continue

  • How to Delete Drop Down List in Excel
    Excel Basics

    How to Delete Drop Down List in Excel? [3 Easy Steps]

    ByAhsanul Haque August 29, 2022March 7, 2023

    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…

    Read More How to Delete Drop Down List in Excel? [3 Easy Steps]Continue

  • How to Edit Drop-Down List in Excel
    Excel Basics

    How to Edit Drop-Down List in Excel? [3 Easy Ways]

    ByAhsanul Haque August 29, 2022March 7, 2023

    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…

    Read More How to Edit Drop-Down List in Excel? [3 Easy Ways]Continue

  • Make a Drop Down List in Excel (3 Easy Steps)
    Excel Basics

    How to Make A Drop Down List In Excel? (3 Easy Steps)

    ByAhsanul Haque August 29, 2022January 8, 2024

    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…

    Read More How to Make A Drop Down List In Excel? (3 Easy Steps)Continue

Page navigation

Previous PagePrevious 1 2 3

Copyright ©2025  | Powered by AnalyticsEmpire

  • Contact
  • About Me
  • Privacy Policy
  • Excel Shortcuts
DMCA.com Protection Status
Facebook Twitter Instagram Pinterest TikTok
  • Excel Basics
  • Graphs & Charts
  • Excel Functions & Formulas
  • Excel Troubleshooting
  • Advanced Excel
    • Pivot Tables
    • Macros/VBA
  • About Me
Search