Skip to main content

Posts

Excel: Unmerge cells and automatically fill the unmerged cells with the content of the merged cell

Unmerge all cells in column A and B Select all rows in column A and B from your first row of data to your last row of data. Press CTRL+G to open the Go To box Click Special Choose Blank Cells In the formula bar enter = then press the Up arrow. You'll end up with a formula like =A1. DO NOT PRESS ENTER Press CTRL+ENTER and this will populate your formula to all selected cells and simulate a "fill down". Copy-paste as values as required.
Recent posts

Change default audio track from Android

 Change default audio track of Video from Android itself! It is very annoying to select your desired audio track or language every time after playing a video.  Looking for a way to force play the audio track after playing the video? Here is the solution.  Download termux Follow steps for changing 'track 2' to default audio track. After downloading, type following commands in termux. pkg update && pkg upgrade pkg install ffmpeg -y termux-setup-storage   (android window will open. Search and allow termux for enabling storage access) cd /sdcard (file must be in internal storage) ls (this will give list of folders, navigate to folder containing video file) ffmpeg -i "name of your video file with extension" -map 0:v:0 -map 0:a:1 -map 0:a:0 -c copy "name of your output file with extension" Done!

Check BNPL (Buy Now Pay Later) accounts on credit report

Here’s a list of Loan Accounts that you might find on your Credit Report: Amazon Pay Later: CapFloat Financial Services / IDFC First Bank Ltd. / Karur Vysya Bank. Flipkart Pay Later: IDFC First Bank Ltd. PayTM Postpaid Lite: Clix Finance India Pvt. Ltd. PayTM Postpaid Delite: Aditya Birla Finance Ltd. OlaMoney Postpaid: Aditya Birla Finance Ltd. Mobikwik: IDFC First Bank Ltd. CRED Stash: IDFC First Bank Ltd. LazyPay: PayU Finance. Simpl: ICICI Bank. MPockket: Jalan Chemical Industries Pvt Ltd. Postpe: SBM Bank. Bharatpe: Hindon Mercantile. ZestMoney: InCred / DMI Finance / Nahar Slice: DMI Finance Private Limited Quadrillion Finance Private Limited Fairassets Technologies India Private Limited Aphelion Finance Private Limited Northern Arc Capital Limited Vivriti Capital Private Limited Freecharge Pay Later - Axis Bank. UniCard - NDXP (Northern Arc, DMI Finance, Liquiloans, Lendbox) StashFin - AKARACAPL. MoneyView - WHIZDM Finance. Red Carpet - DMI Finance. SI Creva Capital - Kissht Bra...

Mutual Fund SIP suggestions for 2023

Here are some of the best SIP plans to consider for investment in 2023: Axis Long Term Equity Fund Canara Robeco Equity Tax Saver Fund Mirae Asset Tax Saver Fund Invesco India Tax Plan Fund DSP Tax Saver Fund Quant Tax Plan Bank of India Tax Advantage For a 1-year investment, some of the best SIP plans include: ICICI Prudential Short-Term Fund Baroda BNP Paribas Liquid Fund Sundaram Liquid Fund Mirae Asset Cash Management Fund For a 15-year investment, some of the best SIP plans include: Tata Digital India Fund ICICI Prudential Technology Fund Quant Infrastructure Fund Parag Parikh Flexi Cap Fund *Source: Internet search; Consult your financial adviser before investing, information provided here for educational purpose only.

Execute SAP Program in Background as Background Task

 Go to desired transaction Input the variables (F9) Program --> Execute in background background print parameters --> properties immediate --> tick periodic job (F5) period values --> desired frequency (Ctrl+S) Save Go to transaction SM37 and select the job you want to download. Click on the Spool button. Select the spool request and click on the Display Contents button. From the System menu, select List > Save > Local File. Choose the Spreadsheet option and save the file.

Download view only videos from sharepoint or teams

To Download view only videos from sharepoint or teams, where only link sharing option is visible. Using Google Chrome => Chromium / (latest) Microsoft Edge / Safari should follow approximately the same flow. Open the  Sharepoint page  with the video you want to download Press  F12  or  Ctrl + Shift + C  on your keyboard to open the browser inspector. ( Cmd + Option + C  on Mac OS X) In the top part, click on the  Network  tab In the top left part - right below the Network tab - you should see a field with the word " Filter " inside it. Click it to gain focus and type:  manifest Refresh  the Sharepoint page After a few seconds you should now see  1 result in the browser inspector's network part . That should be something looking like: videomanifest?provider=spo...  => that right there is the manifest URL you will need later on.  Right-click on it and copy the link address . Step 7) The method I described in my ea...

How To Enable DLNA Server in Windows 10

DLNA is a special software protocol which allows devices such as TVs and media boxes on your network to discover media content stored on your computer. This is quite useful, as it allows you to browse your media collection stored in one place with various devices. With a couple of clicks, you can enable the built-in DLNA server in Windows 10 and start streaming your media files. DLNA (Digital Living Network Alliance) is a non-profit collaborative standards organization which is defining interoperability guidelines to enable sharing of digital media between multimedia devices. DLNA uses Universal Plug and Play (UPnP) for media management, discovery and control. UPnP defines the type of device that DLNA supports ("server", "renderer", "controller") and the mechanisms for accessing media over a network. The DLNA guidelines then apply a layer of restrictions over the types of media file format, encodings and resolutions that a device must support. Windows 10 i...