Excel File Recovery

2 Useful Tips for Worksheet Tabs in Excel

Excel is highly customizable for users. And today we will introduce 2 useful tips for worksheet tabs. The sheet tabs lie in the bottom part of the interface in Excel. Every time you need to edit in a certain sheet, you will click the tab of that sheet. And now we will introduce 2 tips to change the default size and color of sheet tabs. Tips1: Change the Size This is the default size in Excel. If you find that the default size of the sheet tab is a little small, you can make adjustment...

Read more »

How to Save Your Time by Utilizing Auto Text Expansion in Excel

Excel has many hidden functions that enable this software to be a good helper. Thus, here we will discuss about the auto text expansion in Excel. In Excel, you will find that sometimes you will misspell some words. However, if you press “Enter” button or click other cell before you want to correct it, the word will automatically change into the right form. Therefore, you don’t need to enter the word for twice due to the small typo. This is achieved by the feature replace text in...

Read more »

How to Password Protect Specific Ranges in Your Excel Worksheet

The protected worksheet can protect data security very well. In addition, we will show you how to edit specific ranges in a protected worksheet. In our previous article, we have talked about protecting worksheet. And you may refer to it to see how it works: How to Protect Your Excel Worksheets with Passwords. But sometimes you need to send this file to other people, and they will modify certain area. For example, in this file, you need those sales representatives to check their sales...

Read more »