3.1M views · 33K reactions | Microsoft Excel Tips and Tricks l excel shorts #msexcel #advancedexcenewfunction #excel #famousfood | Ather Naqvi | Facebook

Passport size photo in MS Word . . . . . . . . #excel #microsoft #microsoftexcel #office #exceltips #word #powerpoint #data #msexcel #powerbi #dataanalytics #business #datascience #exceltraining #microsoftoffice #exceltricks #windows #accounting #python #o #cursodeexcel | of_success_and_

Use the following steps to highlight active row and column automatically. Step 1: Select the Data Range and click on "Conditional Formatting". Step 2: Click on "New Rules" and select "Use formula to determine which cells to format". Step 3: Write the formula in the box: =CELL("row")=ROW() Step 4: Repeat Step 1,2,3 and Add this formula in Step 3: =CELL("col")=COLUMN() Step 5: Right Click on the worksheet name and click on "View Code" Step 6: Select worksheet from the dropdown and then Write "Acti

Highlight the active row in Excel — automatically. 🔦 Click any cell and the whole row lights up like a runway. #ExcelTips #ExcelAutomation #ConditionalFormatting #ExcelVBA #ExcelForFreelancers #fblifestyle | Excel For Freelancers