Excel Tips and Tricks

How to split worksheet in Excel

How to split worksheet in Excel

As data grows in a worksheet, it gets harder to manage it. Even a large monitor doesn't help while dealing with thousand rows and hundreds of columns. Fortunately, Excel allows you to split the window up to 4 panes which you can focus on different parts of the...

How to spell check using VBA in Excel

How to spell check using VBA in Excel

Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. [button...

How to spell check in Excel

How to spell check in Excel

Neither Excel is a word processing software, nor most of Excel users do care about spell checking in their workbooks. However, Excel does have a spell check feature even though it is not as powerful as Word or PowerPoint offers. In this guide, we’re going to show you...