Swap Two Cells in Excel , changed two cell values with each other

In Excel, there is a simple and quick way to swap two cells with each other. Let’s if you have a value in cell A2 and a value in cell B2, with swapping you can interchange the cells from A2 to B2 and B2 to A2.

1. First, you need to select cell A2.

2. Now, press and hold the Shift Key from your keyboard.

3. Next, hover your mouse cursor on the border of cell A2.

4. After that, click your mouse and drag the cell in between cells B2 and C2.

5.In the end, drop the cell there to swap the cells with each other.

for any query mail us

Thanks

Tech Help

Comments

Office 365: How to force users to change their password /O365

First we will see how to do it for one account then we will see how to do it for multiple accounts. 1. Install Prerequisites: We will need MSOnline module to connect to Office 365 with PowerShell. Open a PowerShell prompt with administrator rights : 2. Install MSOnline module : It will Also install NuGet Provider , accept and yes to continue. 3.Connect to Office 365 Use Connect-MsolService to open the Microsoft Office 365 sign in window : Now a Pop Up windows will open For Microsoft Oath2 Security , Name and password of Administrative user or Global admin must be given here for making any changes. 4.Reset user password : 4A.Force new password : With this command we can set a password for a...

How to Reset Forgotten Password on Kali Linux

Kali Linux is a Linux distribution used in the Cybersecurity domain. It is maintained and funded by Offensive Security. Kali Linux is Debian based and it uses the Debian repository for most of its packages. This Linux distribution is designed for digital forensics and penetration testing. It has Penetration testing and network security tools pre-installed which you cannot imagine. It is completely free and open source. So you can use it for free and even contribute to its development. Now forgetting login credentials is an annoying thing in the case of any operating system. Resetting forgotten passwords often comes with the risk of data loss and requires a lot of effort if you are not a technology enthusiast. This article will be a simple step-by-step guide on resetting forgotten passwords on Kali Linux. How to Reset Forgotten Password on Kali Linux? In this section, we will ...

How to create a “Let’s Encrypt” certificate on Windows ,

Cryptographic certificates are the digital equivalent of website validation, which enables you to encrypt connections using TLS protocol and thus provide a secure link between server and client. There are both paid and free certification centres. Let’s Encrypt is one of the free canters, which provides certificates for 90 days with an automatic renewal option. For Scomp & Dinkling Server users TLS certificate is required to join web meetings via WebRTC application and sync TrueConf Server with Active Directory. Table of Contents Step 1: Getting started. Step 2: Creating a certificate. Step 1: Getting started. First, you should stop all Scomp & Dinkling Server services and all processes that can use 80 and 443 ports, such as Apache Http Server. To create a TLS certificate on Windows, download the ACME Simple (WACS) program. Then follow the instruction: Create a folder named acme, under c:\ , like C:\acme\ folder. Extract the do...

Search This Blog