Dhruba Mondal 1. Excel trick 2 Automatically insert serial number after filter in Excel =SUBTOTAL(103,B$20:B20) Without filter: After filter: 2. Auto adjust serial number sequence in excel =ROW(B36)-34 After delete the Row: Select area > type any > then ctrl + enter for all area filup.
Excel Master Class- Basic to Advance 1. Interface Overview: Open excel file from window menu-> More templates Select any one templets. Quick Excess toolbar: Menu bar: Footer Bar: Cell, Rows, Column, Name box & formula bar: 2. Workbook & Worksheet: 3. Save File: 4. Movement Shortcut Key: 5. Data entry shortcut key: 6. Selection with … Read more
HTML code of Days Between Two Dates | Date Calculator <!DOCTYPE html><html lang=”en”><head><meta charset=”UTF-8″><meta name=”viewport” content=”width=device-width, initial-scale=1.0″><title>Date Calculator</title><style>body {font-family: Arial, sans-serif;margin: 0;padding: 20px;}h1 {text-align: center;}.calculator {max-width: 400px;margin: 0 auto;}.form-group {margin-bottom: 20px;}label {display: block;margin-bottom: 5px;}input[type=”date”] {width: 100%;padding: 8px;}input[type=”submit”] {width: 100%;padding: 10px;background-color: #007bff;color: #fff;border: none;cursor: pointer;}input[type=”submit”]:hover {background-color: #0056b3;}#result {margin-top: 20px;padding: 10px;background-color: #f0f0f0;}</style></head><body><h1>Date Calculator</h1><div class=”calculator”><form id=”dateForm”><div class=”form-group”><label for=”startDate”>Start … Read more
HTML Code of Random Password Generator | Strong Password Generator | Password Generator <!DOCTYPE html><html lang=”en”><head><meta charset=”UTF-8″><meta name=”viewport” content=”width=device-width, initial-scale=1.0″><title>Advanced Password Generator</title><style>body {font-family: Arial, sans-serif;margin: 0;padding: 0;background-color: #f0f0f0;} .container {text-align: center;} .options {margin-bottom: 10px;} .options label {margin-right: 10px;} .password-container {margin-top: 20px;} input[type=”text”], input[type=”number”] {width: 200px;padding: 10px;font-size: 16px;margin-right: 10px;} button {background-color: #04AA6D;color: white;padding: 10px 20px;font-size: 16px;cursor: … Read more
HTML code of Date to Day finder Tools | Date to Day Converter | Date Duration Calculator | Weekday Calculator <!DOCTYPE html><html lang=”en”><head><meta charset=”UTF-8″><meta name=”viewport” content=”width=device-width, initial-scale=1.0″><title>Weekday Calculator</title><style>body {font-family: Arial, sans-serif;margin: 0;padding: 0;background-color: #f0f0f0;}.container {max-width: 80%;margin: 50px auto;padding: 20px;background-color: #fff;border-radius: 5px;box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);}h2 {text-align: center;}form {text-align: center;}input[type=”text”] {width: 100%;padding: 10px;margin: … Read more
HTML code of Time Duration Calculator <!DOCTYPE html><html lang=”en”><head><meta charset=”UTF-8″><meta name=”viewport” content=”width=device-width, initial-scale=1.0″><title>Time Duration Calculator</title><style>.container {max-width: 400px;margin: 50px auto;text-align: center;} input[type=”time”] {margin-bottom: 10px;} button {padding: 10px 20px;background-color: #007bff;color: #fff;border: none;cursor: pointer;} button:hover {background-color: #0056b3;} #result {margin-top: 20px;font-size: 20px;}</style><link rel=”stylesheet” href=”styles.css”></head><body><div class=”container”><h1>Time Duration Calculator</h1> <label for=”start-hour”><b>Start Time:</b></label> <br><br/> <input type=”number” id=”start-hour” min=”1″ max=”12″ placeholder=”Hour”><br><br/> <input type=”number” … Read more
HTML code of URL Decoder And Encoder | Encoder And Decoder tool <!DOCTYPE html><html lang=”en”><head><meta charset=”UTF-8″><meta name=”viewport” content=”width=device-width, initial-scale=1.0″><title>Encoder & Decoder</title><style>body {font-family: Arial, sans-serif;background-color: #f0f0f0;margin: 0;padding: 0;}.container {max-width: 600px;margin: 20px auto;padding: 20px;background-color: #fff;border-radius: 8px;box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);}textarea {width: 100%;height: 150px;margin-bottom: 10px;padding: 10px;box-sizing: border-box;}.shift-input {width: 80px;margin-right: 10px;}.btn-group {display: flex;justify-content: space-between;flex-wrap: wrap;}button {padding: … Read more
Major Ports in India – Complete List with Facts 2025 India, with a 7,500 km-long coastline, is strategically located on the Indian Ocean, making it a hub for maritime trade. Its ports play a crucial role in import, export, and international commerce, contributing significantly to the economy. In this article, we provide a complete list … Read more
7 Continents of the World – Names, Area & Population 2025 The Earth is divided into seven continents, each varying in size, population, geography, and culture. Learning about continents is fundamental for students, geography enthusiasts, and competitive exam aspirants. In this article, we provide the names of all 7 continents, their area in square kilometers, … Read more
List of High Courts in India – Complete Guide 2025 India’s judicial system is one of the largest in the world, with a well-structured hierarchy. At the top is the Supreme Court, followed by High Courts in each state and union territory. High Courts play a crucial role in interpreting laws, protecting citizens’ rights, and … Read more