Solutions

2 Methods to Sort the Columns in a Column Chart in Your Excel Worksheet

It is easy for you to sort data in a range in the worksheet. Furthermore, now you can also sort data in a column chart by the 2 effective methods that are introduced in this article. When you demonstrate data and information in a column chart, the order will be the same as in the worksheet. The image below shows such a typical column chart that has the same order with the original range in the worksheet. When you need to change the order, or sort the columns in the chart, you may find...

Read more »

How to Use the Windows Username to Limit Access to Worksheets

In a company environment we might wish to control what a user can and can’t see within a workbook, depending on their authority level. Windows usernames and levels are stored in a database (preferably) or, as in this case, a hidden sheet within the workbook. This article assumes the reader has the Developer ribbon displayed, and is familiar with the VBA Editor. If not, please Google Excel Developer Tab or Excel Code Window. Open a blank workbook. In testing our code, Sheets 1, 2 and 3...

Read more »

10 Tips to Eliminate Distractions while Working in Your Word

In the following text, we will make a summary of 10 tips to help you eliminate distractions while working in Word. In Word, we know there are a bunch of features enabling users to accomplish multiple different tasks fluently. Yet, sometimes there can be occasions when we just want to focus on the texts. Therefore, some of the functions may become distractions. Here are 10 tips to help you stay away from interruption. Tip 1: Minimize the Ribbon For Word 2007 and later versions, there is...

Read more »