In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet. Now, we will see how to get values from Random Columns using the same function. This is kind of applying the Rand function little bit different application that we usually do. These… [Continue Reading]
Select a worksheet, enter ‘=5-3’ in any cell and press Enter. Excel will calculate the difference and display result as 2. We have just entered a Formula in Cell that starts with ‘=’ sign. If we type anything in a worksheet starting with ‘=’ sign, Excel treats it as a formula, executes the formula and display the result only.
Select Range of Cells that you want Sum in Excel sheet & Click ‘AutoSum’ in Home Menu Right hand side end.
Type ‘=1+2’ in Excel Sheet and hit Enter. It will answer as 3
Type ‘=Sum(1,2,3)’ , press Enter to get result 6
Learn how this Excel VBA delete blank rows in Excel 2013 or below using the builtin option. Also, lean to remove empty rows using VBA Macro code.
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. From here, they can choose either “Smallest to Larger or A to Z” or “Largest to Smallest or… [Continue Reading]
Excel Macro to download file from website. Get fully functional VBA code to download file from website. Just copy paste this code in your Excel VBA project and Download files from web URLs.
How to Merge Multiple Files to one Output File? In our daily work routine we deal with lot of data & log files of different formats collected from different sources. To name a few .TXT, .EXE, .XLS, .XLSX, .PST, .DOC, .LOG etc., Well, am just rethinking “Should I be explaining… [Continue Reading]
Use this VBA Change Cell Color Excel macro, read Excel cell color & convert color index to RGB code. Learn how to change cell background color using VBA..
How to Create Worksheets Through Macro during run-time? Excel Macro provides option to create worksheets dynamically during run-time. Also, users can to other worksheet operations like copy, move, rename and delete though VBA. Let’s begin by creating a new workbook or try downloading the Sample File at end of this… [Continue Reading]