Excel 10 Tutorial

The most powerful feature that Excel offers are functionsand formulas . It's like a text editor without the functions, or even less. We can use functions to create our own formulas and use them wherever we desire. However, there are situations when we don't want people to see our formula. If this is the case, the excel formula can be readily hidden. You can use this method to hide formulas in excel cells with or without a password. In this video, I'll show you both alternatives. 1 st step: You must select the full worksheet to show or conceal formulas. You can either press CTRL+A or click the button in the top left corner to select the entire worksheet. Above the first Row and before the first column. 2 nd step: Right-click and click "Format Cell" after you've selected the entire worksheet. 3 rd step: Next, go to "Protection" and uncheck the "Locked" checkbox. Click the OK button. 4 th step: Now you must pick all of the cells...

Every one of us requires a lot of folders on our computers for various functions. And we do so in a seamless manner. It's simple and quick. Until the day comes when you need to make a large number of folders at once. As you are reading this, that day has arrived. I've written an article about how to generate several folders from a list . If you already have a list in Excel and need to create folders based on it, that tutorial is for you. However, in this lesson, I'll take a different method to solve that problem, as well as provide some additional benefits. Here are some of the things you'll find: Excel will create a folder on your PC whenever you type something in a cell. If you paste a list into Excel, it will generate all of the folders based on that list on your computer at once. The cell values in your excel file will be used to name the newly generated folders. This workbook can also be used as a template that you can use anywhere. I hope I've piqu...