In Excel, all cells are locked by default. It is, however, important to activate the lock by protecting the worksheet. Follow the easy steps below to do this; How to lock all cells 1. Highlight all cells you want to lock 2. Use your mouse to right-click 3. Select the Format Cells option 4. Alternatively, […]
How to Lock Cells in Excel: Simple Steps Tutorial Read More »
In this tutorial, I will show you how to extract, split or move Excel sheets from workbook. Use move or copy to Extract Excel Sheet from the workbook This is the first step. Follow the simple steps below; 1. Use your mouse to Right-click the name tab of the worksheet. 2. Select Move / Copy
How to extract Excel Sheet from Workbook: 4 easy ways Read More »
Excel read-only feature can be very useful. This is because it helps ensure that your document is not interfered with. The read-only feature provides security for the document so that the next user cannot perform changes. However, they can still read the data. It protects the document from both parties, those who might want to
How to take Excel out of read only: 5 easy ways Read More »
Are you looking for ways to change the letters in Excel to lowercase except the first letter? Look no further. Excel allows you to change all the letters to lowercase, apart from the first letter of the sentence. There are several ways to do this and easy steps to follow, as given in this article.
How to lowercase in Excel except first letter: 6 easy ways Read More »
When working with an Excel sheet you might want to add a background picture for a more interesting look. At times, when working with Excel, adding a picture can help you insert the logo of the company you are working under, for recognition. It is simple to insert a picture in Excel behind the text
How to insert a picture in Excel behind the text (Easy Guide) Read More »
In Excel, when you add the plus sign before a number, it disappears just like it was the case when you add leading zeros. This is because Excel assumes that the sign is redundant. However, it may be necessary at times to add the sign before numbers for example when showing changes, before a phone
How to add sign in Excel before a Number Read More »
There are documents in Excel that you may deem primate, hence should be restricted to only a number of people. This is due to how sensitive the content in the files may be. When you password protect Excel then users need to have a passo Using Excel File protection is among the most convenient methods
How to password protect Excel before opening Read More »
Whenever you try to add 0 in Excel before number, you will notice that Excel removes it automatically. This can inconvenience you, especially when you want your data to have leading zeros. However, Excel has steps that will help keep the zeros without deleting them, as shown by this article. Use Format as Text Method
How to add 0 in Excel before Number Read More »
There are different ways in which you can remove spaces before numbers in Excel. These are the trim formula, Excel Find and Replace, or special Excel add-in. Extra space in Excel can be found when you paste foreign data into Excel. The leading and trailing spaces can be in between the words and spaces thus
How to Remove Spaces before Numbers in Excel Read More »
