How to open browsers using batch files
• Open a notepad file. Paste the below mentioned code @echo off %SystemRoot%\explorer.exe "" • Open browser in search bar. Open fi...Read More
How to open Outlook using Batch file
• Open a notepad file. Paste the below mentioned code @echo off %SystemRoot%\explorer.exe "" • Open outlook in search bar ==> O...Read More
How to copy words from image file
• Open one note • Copy the image file and paste it in One note • Right click on the image • Select copy text from image • Now text paste the...Read More
How to convert italic fonts images to text
• Open online converter I2OCR https://www.i2ocr.com/ • STEP 01: Choose the language • STEP 02: Upload the image file or url which co...Read More
How to count days in MS Excel
• To check the number of days between two date period, use the below given formula • (=DAYS) Select the date • Now the number of dates has b...Read More
How to set password for Excel file
• Go to file==>info ==>Protect workbook • Click with protect workbook==> Encrypt with password • Now enter password and confirm it ...Read More
How to change all currency symbol
• Select the numerical which need to add currency symbol • Go to file==>HOME ==>NUMBER tab • Select the dollar sym...Read More
How to change Grind line color
• This will add more visual effect for MS Excel • To change the Grid line color follow the below mentioned steps • Go to file==>options =...Read More
How to remove the page breaks
• The page break may affect the Visual for MS Excel while using • To remove that page breaks follow the steps mentioned below • Go to file==...Read More
How to filter EVEN number separately
• For filtering EVEN number from a list use the below mentioned Formula • (=EVEN) • Select the number list • Now the EVEN numbers has been f...Read More
How to filter ODD number separately
• For filtering ODD number from a list use the below mentioned Formula • (=ODD) • Select the number list (Column) • Now the ODD numbers has ...Read More
How to add and remove hyperlink in Excel
ADDING HYPERLINK • Right click on the cell which need to add hyperlink • Click for hyperlink • ADD your required the URL link in address bar...Read More
How to spell check in Excel
• Select the words which need to spell check • Go to ==>review tab • We can see ABC Spelling • Once we clicked the ABC Spelling our spel...Read More
How to use color scale in Excel
• Prepare the data which need to project under color scale • Select the data's • Go to conditional formatting==> Color scales • Now w...Read More
How to add Welcome message in Excel VBA
• Go to developer tab • Click with visual Basic ==> insert and click with module • Paste the below given code in THIS WORKBOOK and modi...Read More
How to create excel macro
What is Macro? Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times ...Read More
How to Convert the numbers in millions in Excel
• Open MS Excel • Select the numbers • Give right click, go with Format cells • Enter the below given code and click OK. ...Read More
How to add bullet points in Excel
• Open MS word. Enter a bullet and add @ and copy it • Now Open MS Excel • Select the Column which need to add bullets • Go to format c...Read More
How to add blank cells between the serial numbers in MS Excel
In this will see how to add blank cells between the serial numbers in MS Excel. i) Fill the serial number in Excel by using below given shor...Read More
Subscribe to:
Posts
(
Atom
)