↓ Skip to Main Content
Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course
Excelabcd

Off Canvas Menu

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Author: Pushpendu Roy Karmakar

Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#217: Fixing Excel Sheet That Won’t Scroll
Excel Features, Excel general tips

Lesson#217: Fixing Excel Sheet That Won’t Scroll

Pushpendu Roy Karmakar Sep 1, 2023 Tagged with Corrupted Workbook, FREEZEPANE

Microsoft Excel is a powerhouse for data analysis and manipulation, widely used in offices and businesses …

Lesson#217: Fixing Excel Sheet That Won’t Scroll Read more →

Lesson#216: Solving Excel Formula Errors – Demystifying #VALUE and #REF Errors
Excel general tips

Lesson#216: Solving Excel Formula Errors – Demystifying #VALUE and #REF Errors

Pushpendu Roy Karmakar Aug 31, 2023 Tagged with IFERROR, ISERROR

In the world of spreadsheet software, Microsoft Excel stands tall as one of the most widely …

Lesson#216: Solving Excel Formula Errors – Demystifying #VALUE and #REF Errors Read more →

Lesson#215: Troubleshooting Excel Formulas Not Calculating
Excel Features, Excel general tips

Lesson#215: Troubleshooting Excel Formulas Not Calculating

Pushpendu Roy Karmakar Aug 27, 2023 Tagged with CIRCULAR REFERENCE, FORMULA AUDITING

Excel, the powerhouse of data analysis and financial modeling, is every professional’s go-to tool. However, there …

Lesson#215: Troubleshooting Excel Formulas Not Calculating Read more →

Lesson#214: Deleting Blank Rows in a Specified Range Using VBA
VBA and Macro

Lesson#214: Deleting Blank Rows in a Specified Range Using VBA

Pushpendu Roy Karmakar Aug 27, 2023

Excel, the workhorse of data manipulation and analysis, thrives on automation. When working with vast datasets, …

Lesson#214: Deleting Blank Rows in a Specified Range Using VBA Read more →

Lesson#213: How to Fix Circular Reference Error in Excel
Excel general tips, VBA and Macro

Lesson#213: How to Fix Circular Reference Error in Excel

Pushpendu Roy Karmakar Aug 21, 2023 Tagged with CIRCULAR REFERENCE, FORMULA AUDITING

Excel is an indispensable tool for data analysis, financial modeling, and various other tasks. However, as …

Lesson#213: How to Fix Circular Reference Error in Excel Read more →

Lesson#212: Copy Text to Clipboard with VBA button
VBA and Macro

Lesson#212: Copy Text to Clipboard with VBA button

Pushpendu Roy Karmakar Aug 12, 2023

Are you tired of the mundane routine of manually selecting and copying text in Excel? Wouldn’t …

Lesson#212: Copy Text to Clipboard with VBA button Read more →

Lesson#211: Expert ChatGPT prompts to make a Personal Finance Sheet
AI Prompt techniques

Lesson#211: Expert ChatGPT prompts to make a Personal Finance Sheet

Pushpendu Roy Karmakar Aug 9, 2023 Tagged with ChatGPT

Almost everyone knows about ChatGPT which is an AI GPT model created by OpenAI. You know …

Lesson#211: Expert ChatGPT prompts to make a Personal Finance Sheet Read more →

Lesson#210: 5 Essential Excel Features Every Beginner Should Know
Excel Features

Lesson#210: 5 Essential Excel Features Every Beginner Should Know

Pushpendu Roy Karmakar Jul 23, 2023 Tagged with CHART, CONDITIONAL FORMATTING, FILTER, FORMAT CELLS

Microsoft Excel is a versatile and extensively used spreadsheet program that provides a wealth of tools …

Lesson#210: 5 Essential Excel Features Every Beginner Should Know Read more →

Lesson#209: 5 Effective Ways to Lock Data in an Excel Workbook
Excel general tips

Lesson#209: 5 Effective Ways to Lock Data in an Excel Workbook

Pushpendu Roy Karmakar Jul 9, 2023 Tagged with PROTECT SHEET

Microsoft Excel is a powerful tool for data management and analysis. When working with sensitive or …

Lesson#209: 5 Effective Ways to Lock Data in an Excel Workbook Read more →

Lesson#208: 5 Effective Ways to Hide Data in an Excel Workbook
Excel general tips

Lesson#208: 5 Effective Ways to Hide Data in an Excel Workbook

Pushpendu Roy Karmakar Jul 9, 2023 Tagged with PROTECT SHEET

Microsoft Excel is a strong data-organization and analysis application. To preserve sensitive information or to simplify …

Lesson#208: 5 Effective Ways to Hide Data in an Excel Workbook Read more →

Posts pagination

Previous 1 … 5 6 7 8 9 … 37 Next
Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Loading…