Posts

Showing posts from July, 2026

Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment
Read more

How to Combine Multiple Cells into One in Excel

Image
    How to Combine Multiple Cells into One in Excel Sometimes you need to join the text from two or more cells into a single cell. For example, if a first name, middle name, and last name are stored in separate cells, you can combine them into one full name. Example Suppose you have the following data: A B C Ram Mohan Sharma You want the result to be: Ram Mohan Sharma Method 1: Use CONCAT (Newer Versions of Excel) If you are using Excel 2019, Excel 2021, or Microsoft 365, use the CONCAT function. Formula: The " " adds a space between each name. Result: Ram Mohan Sharma You can also add your own text. Example: =CONCAT(" Employee : ",A2," ",B2," ",C2) Result: Employee: Ram Mohan Sharma Method 2: Use CONCATENATE (Older Versions of Excel) If you are using an older version of Excel, use the CONCATENATE function. Formula: =CONCATENATE(A2," ",B2," ",C2)...
Post a Comment
Read more

Magic file sharing service

Image
 Functions of Send Anywhere FILE SHARING SERVICE Send Anywhere   is a fast, secure, and convenient file-sharing platform that allows users to transfer files between devices without using USB drives or email attachments. It supports Windows, macOS, Android, iPhone, and web browsers. Send files directly between nearby or remote devices without the need for a USB cable. Files are protected using a unique 6-digit security key, ensuring that only the intended recipient can access them. Send Anywhere is an efficient solution for transferring files of any size between devices. Its speed, security, and cross-platform compatibility make it an excellent choice for individuals and businesses looking for a reliable file-sharing service.   WHAT TO DO Open your browser and s earch for Send Anywhere . You'll see a simple interface where you can add the file you want to transfer. Once you upload the file, Send Anywhere automatically generates a unique 6-digit code . Share...
Post a Comment
Read more

How to Hide Formulas in Excel

Image
  How to Hide Formulas in Excel Hiding formulas in Excel is an easy way to protect your calculations while still allowing others to view and use your spreadsheet. When formulas are hidden, users can see the calculated results but cannot view the formulas in the Formula Bar. Step-by-Step Guide Step 1: Select the Formula Cells Select the cells that contain the formulas you want to hide. Step 2: Open the Format Cells Window 1.       Right-click the selected cells. 2.       Click Format Cells. 3.       Open the Protection tab. Step 3: Hide the Formulas 1.       Tick the Hidden checkbox. 2.       Make sure the Locked checkbox is also selected if you want to prevent users from editing the formulas. 3.       Click OK. Note: The formulas are now marked as hidden, but they will not be hidden until you protect the worksheet. Step 4: Protect the...
Post a Comment
Read more