Posts

Showing posts from February, 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 Lock an Excel File with a Password

Image
  SCAN How to Lock an Excel File with a Password       How to Lock an Excel File with a Password (Using Save As) Protecting your Excel file with a password helps keep your data safe from unauthorized access. Microsoft Excel provides a built-in option to add a password at the time of saving the file. Follow the steps below to secure your Excel workbook easily.   Steps to Set a Password in Excel 1. Open the Excel File    Open the Excel workbook you want to protect. 2. Click on “File” Menu     From the top menu, click on File and select **Save As**. 3. Choose Save Location    Select the folder where you want to save the file. 4. Open Tools Menu    In the   Save As dialog box, look at the bottom and click on **Tools**. 5. Select General Options From the Tools dropdown, choose **General Options**. 6. Enter Your Password    * Enter a password in **Password to open** (to prevent opening the file), or  ...
Post a Comment
Read more