Online Home of Yash Kapoor: January 2026

Thursday, January 22, 2026

Sorting in Excel - Unique records in Excel

For Sorting

> First Select the columns

> Click on Data Menu

> Click on Sort

> Select the Column (Sort By)

> Click on OK

==============================

For Unique Records

> First Select the column

> Click on Data

> Click on Advanced

> Check on Unique Records

> Click on OK

ref:- https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

Pin codes from govt sites - PINCODE of india from official sites

https://dac.indiapost.gov.in/mypincode/home

https://dmsouthwest.delhi.gov.in/std-pin-codes/

https://www.data.gov.in/datasets_webservices/datasets/6818292

https://www.pib.gov.in/PressReleasePage.aspx?PRID=2131707&reg=3&lang=2

Know Your DIGIPIN: https://dac.indiapost.gov.in/mydigipin/home

Know Your PIN Code: https://dac.indiapost.gov.in/mypincode/home

DIGIPIN GitHub Repository: https://github.com/CEPT-VZG/digipin

Georeferenced PIN Code data set: https://www.data.gov.in/catalog/all-india-pincode-boundary-geo-json

Wednesday, January 21, 2026

How to create an image with random number and random alphabets with Javascripts

HTML

<body>

Your browser does not support the HTML5 canvas tag.

</canvas>

</body>

JAVASCRIPT

function generateRandomLetters(length) {

let result = '';

const characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';

for (let i = 0; i < length; i++) {

result += characters.charAt(Math.floor(Math.random() * characters.length));

}

return result;

}

// Example usage to get a 6-letter string:

const randomLetters = generateRandomLetters(6);

// Get the canvas element and its 2D context

const canvas = document.getElementById("myCanvas");

const ctx = canvas.getContext("2d");

// Draw a rectangle

ctx.fillStyle = "#FF0000";

ctx.fillRect(0, 0, 150, 75);

// Draw some text

ctx.font = "30px Arial";

ctx.fillStyle = "#000000";

ctx.fillText(randomLetters, 10, 50);

// Optional: Convert canvas content to an image data URL

const imageDataUrl = canvas.toDataURL("image/png");

console.log(imageDataUrl); // You can use this URL as the src for a new <img> element

document.write(randomLetters);

// Get the canvas element and its 2D context

const canvas = document.getElementById("myCanvas");

const ctx = canvas.getContext("2d");

// Draw a rectangle

ctx.fillStyle = "#FF0000";

ctx.fillRect(0, 0, 150, 75);

// Draw some text

ctx.font = "30px Arial";

ctx.fillStyle = "#000000";

ctx.fillText(Math.random(), 10, 50);

// Optional: Convert canvas content to an image data URL

const imageDataUrl = canvas.toDataURL("image/png");

console.log(imageDataUrl); // You can use this URL as the src for a new <img> element

document.write(Math.random());

ref:- https://codesandbox.io/p/sandbox/random-word-generator-ijlgj?file=%2Fsrc%2Findex.js%3A7%2C44-7%2C50

a to z alphabets in chrome with notepad with powershell

#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "chrome.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

# Activate the WinWord window (adjust the title if necessary)

$wshell = New-Object -ComObject wscript.shell

#$wshell.AppActivate("Document1 - Word") # Or the actual document title

(New-Object -ComObject "wscript.shell").SendKeys('data:text/html, <title>Notepad</title><body contenteditable style="font-size:18px;line-height:1.6;font-family:sans-serif;">')

(New-Object -ComObject "wscript.shell").SendKeys("{ENTER}")

Start-Sleep -Seconds 1

(New-Object -ComObject "wscript.shell").SendKeys("{TAB}")

for ($k = 1; $k -le 50; $k++) {

for ($i = 1; $i -le 55; $i++) {

$j = [char](65 + $i)

(New-Object -ComObject "wscript.shell").SendKeys("$j")

}

(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")

}

Tuesday, January 20, 2026

Scroll Button Meaning

> In Excel , Click on Cell, If scroll Lock is OFF than You can left and right the Cell.

> IF scroll Lock is ON than you can scroll Down or up scroll bars.

Thursday, January 15, 2026

How to copy and paste in Powershell from one notepad to another notepad - CTRL + C and CTRL + V in Powershell - CTRL C in Powershell and CTRL V in Powershell

#Note This first line is mandatory

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "notepad.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

Start-Process -FilePath "notepad.exe"

Start-Sleep -Seconds 3

# Activate the WinWord window (adjust the title if necessary)

[System.Windows.Forms.SendKeys]::SendWait("123")

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("^{a}")

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("^{C}")

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("%{TAB}")

Start-Sleep -Seconds 3

[System.Windows.Forms.SendKeys]::SendWait("^{v}")

Note: ctrl C and Ctrl v , c and v are in small letters.

Wednesday, January 14, 2026

Fireworks in JS - Crackers Javascript

https://fireworks.js.org/

https://www.npmjs.com/package/fireworks-js

> https://github.com/crashmax-dev/fireworks-js

https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js

https://codepen.io/mr__khushal/pen/yLobQEP

https://stackblitz.com/edit/js-ubfdjg?file=style.css,package.json,index.js

https://www.myprograming.com/how-to-add-crackers-animation-effect-to-my-html-page/

Confirm button in Javascript

if (confirm("Press a button!")) {

txt = "You pressed OK!";

} else {

txt = "You pressed Cancel!";

}

How to view two books in Excel - How to view two books in excel

> In excel, there are books.

> And In books there are sheets

------

> At the top, you have restore option.

> In View Menu, You have arrange all button. You can click on that button.

> You can also used split button

How to add new themes in window 11 - Windows 11 theme - window 11 theme

https://vsthemes.org/en/themes/windows11/71137-windows-xp-2025.html

Monday, January 12, 2026

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Error

Friday, January 9, 2026

How to add macros in Google Sheets

>Click on Extensions Menu

>Click on Macros and Add Scripts

Two filters in excel - Two Columns filters in excel - Multiple Columns filters in excel

> Open Excel

> Click on Data Menu

> Select the columns in sequence, not using CNTL(Column 1,2,3,4) will be used for Multiple columns. (Columns 4,6,9) will not be used for Multiple Columns.

> Click on Filter

Thursday, January 8, 2026

How to enable text cursor in Chrome - Highlight on object in Chrome

> In settings of Google Chrome

> Click on Accessibility

> Click on navigate pages with a text cursor

---------

Click on HIGHLIGHT ON FOCUS OBJECT

Friday, January 2, 2026

Powershell a to z alphabets 50 times

#Note This first line is mandatory [void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")

# Start WinWord (if not already running)

Start-Process -FilePath "notepad.exe"

# Wait for WinWord to open and become active

Start-Sleep -Seconds 3

# Activate the WinWord window (adjust the title if necessary)

$wshell = New-Object -ComObject wscript.shell

#$wshell.AppActivate("Document1 - Word") # Or the actual document title

Start-Sleep -Seconds 1

for ($k = 1; $k -le 25; $k++) {

for ($i = 1; $i -le 55; $i++) {

$j = [char](65 + $i)

(New-Object -ComObject "wscript.shell").SendKeys("$j")

}

(New-Object -ComObject "wscript.shell").SendKeys("{Enter}")

}

Sound effects mouse in windows - mouse Sound effects in windows

https://www.lifewire.com/set-mouse-click-sound-in-windows-10-5193086

Online Home of Yash Kapoor

Slider

Carousel Example

LinkList

Thursday, January 22, 2026

Sorting in Excel - Unique records in Excel

Pin codes from govt sites - PINCODE of india from official sites

Wednesday, January 21, 2026

How to create an image with random number and random alphabets with Javascripts

a to z alphabets in chrome with notepad with powershell

Tuesday, January 20, 2026

Scroll Button Meaning

Thursday, January 15, 2026

How to copy and paste in Powershell from one notepad to another notepad - CTRL + C and CTRL + V in Powershell - CTRL C in Powershell and CTRL V in Powershell

Wednesday, January 14, 2026

Fireworks in JS - Crackers Javascript

Confirm button in Javascript

How to view two books in Excel - How to view two books in excel

How to add new themes in window 11 - Windows 11 theme - window 11 theme

Monday, January 12, 2026

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Error

Friday, January 9, 2026

How to add macros in Google Sheets

Two filters in excel - Two Columns filters in excel - Multiple Columns filters in excel

Thursday, January 8, 2026

How to enable text cursor in Chrome - Highlight on object in Chrome

Friday, January 2, 2026

Powershell a to z alphabets 50 times

Sound effects mouse in windows - mouse Sound effects in windows

Total Pageviews