Tag Archive


accdb repair access recovery access repair Contacts corrupt Outlook corrupt PST damaged Outlook damaged PST Data Backup Data Loss Data Recovery excel recovery Excel tips Excel VBA Hard Drive inbox repair tool mdb repair mdf recovery MDF repair Ms Access outlook contacts Outlook corruption Outlook Email Outlook fix outlook recovery Outlook repair outlook VBA PST corruption pst recovery pst repair Quick Access Toolbar recover outlook recover PST recover sql repair access repair excel repair outlook repair pst ScanPST SQL recovery SQL Server sql server recovery VBA View Settings Word Macro

2 Easy Ways to Consolidate Rows in Your Excel

When analyzing the data in Excel, you may find it contains multiple duplicate rows. In this case, perhaps you’ll want to quickly consolidate the rows. This post will offer 2 quick means to get it. Many users frequently need to merge the duplicate rows and sum the according values in Excel. For instance, I have […]

How to Standardize the Texts in Your Spreadsheet with Excel VBA

We’ve all seen spreadsheet names and addresses with a mix of formats like JAMES JONES, sARAH bERNARDT or clint eastwood, all of which look amateurish on a report. This article shows how to standardise text in the proper way in a worksheet. This article assumes the reader has the Developer ribbon displayed and is familiar […]

How to Easily Set the Print Regions for Your Excel Worksheets

When saving data on Excel sheets it is a good practice to set print regions. Otherwise, we will end up with a huge task of adjusting column positions. Using Excel macro, you can easily set print regions for all your worksheets. Let’s learn about that in this article. Download Now If you want to start […]