Microsoft Excel

Inserting Rows & Columns In Protected Worksheet (Excel)

In order to allow for inserting columns and/or rows in a protected worksheet you start by knowing how to lock and unlock fields. To lock/unlock a cell, right-click a cell and choose “Format Cells”. Go to the “Protection” tab. To lock the field so that the end-user cannot enter data into that cell, make sure… Continue reading Inserting Rows & Columns In Protected Worksheet (Excel)

Microsoft Excel · Microsoft Word · SharePoint

SharePoint Opening Online Version Instead of Desktop Version

If you are trying to edit documents that you’ve opened in SharePoint but it keeps opening them up using the online version of WORD, Excel, etc., you may be getting a bit frustrated if you prefer using the desktop versions. Here’s how to change the default to open the documents using your desktop version. First,… Continue reading SharePoint Opening Online Version Instead of Desktop Version

Microsoft Excel

PERSONAL.XLSB is locked for editing

How to disable this message: PERSONAL.XLSB is locked for editing Open ‘Read-Only’ or click ‘Notify’ to open read-only and receive notification when the document is no longer in use. In Excel, go to the View tab and choose¬†Unhide in the Ribbon under the Windows group. When the¬†dialog box appears, choose “PERSONAL” and click OK. Go… Continue reading PERSONAL.XLSB is locked for editing

Microsoft Access · Microsoft Excel · Microsoft Word

Mail Merge Many-To-One Add-In

This is one of my favorite Word add-in I came across trying to solve a problem I was having. I had an Access database where I wanted to create invoices. I’ll make up an example because mine’s a little harder to explain. Say you have a construction job and everything you purchase you apply to… Continue reading Mail Merge Many-To-One Add-In