Tag Archive


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

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 […]

How to Create an Automated Shopping Cart in Excel Workbook

Take your customer satisfaction to the next level. Add your product information along with the price in an Excel workbook and create a shopping cart for your business. All you have to do is share this workbook with your customers and let them select their desired products with a quick preview of billing Download Now […]