Flash Fill Recognizes patterns in data and fills out the rest of the fields for you. Look for the Flash Fill button is under the Data Tab in Excel! Fill out the first cell so that Excel will know the pattern it’s looking for (field C1 in the image above or D1 in the second… Continue reading Three Microsoft Excel Tips
I’ve got to give all props to Graham Mayor. His add-on was brilliant and did the job! If you need to have more than one record put on a Word document, based on a field’s value, Graham’s add-on is your solution. If you have several items that need billed to one account, for example, you… Continue reading Microsoft Access – Merge Many-To-One Records to Microsoft Word
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
There are many adjustments you can make that can really improve your quality of sleep. Getting up at the same time every day, going to bed around the same time, eating healthy, avoid caffeine, alcohol, nicotine, keep naps short if you take them, exercise, etc. I’m sure one thing you’ve also heard of is to… Continue reading A Setting On Your Phone That Will Help Give You A Better Night Sleep?
If you’re annoyed with your scroll bar disappearing every time you take a pause, here’s a fix. I have to start by saying I have Windows 10 and it worked perfectly for me. It may not work for all Windows versions. Click START on your computer and type “Notepad”. Paste the following code in Notepad. @-ms-viewport{width:auto!important}… Continue reading Stop Internet Explorer 11 Scroll Bar from Disappearing
Whether you did it on purpose or by accident, it can be very confusing on where to turn when you need to stop an auto-renewal subscription on an iPhone app. The good news is, it’s really easy! Here’s how: Go to Settings on your iPhone. Scroll down and select “iTunes & App Store”. Click on… Continue reading How To Cancel a Auto-Renew Subscription For An iPhone App
You want to change your email on your Apple ID on your iPhone. The problem is, your iCloud is still showing your old email address and now your account has been disabled! You’re getting more and more frustrated because it’s having you reset your password, only to then make you login. So you go back… Continue reading Apple ID Account Disabled on iPhone- Old Email Still Showing
Good luck easily finding any information on how to import data from Excel, Access. or SharePoint into Sage Timeslips. It’s not easy. What I can do in this post is help show you how to set it up. It may be different than your needs but hopefully you get enough out of it that you… Continue reading TSImport Sage Timeslips
This feature is used in a Microsoft Access form. You will create a hotkey, such as Alt+D, and no matter what field on the form you are in, it will drop-down the combo you set this up on so you can do a quick search/selection. Open the form you have created the combo box… Continue reading How to Add a HotKey to Combo Box Drop-Down
Microsoft Word – Suppressing Blank Address Lines On your Word document, put your cursor where you’re inserting your first field. Then go to the MAILINGS tab and click “Insert Field”. To Toggle back and forth to see this formula, highlight all of the section you want to see (it’s ok if you highlight more)… Continue reading Suppressing Blank Lines in Address
