You have certainly noticed that with Microsoft Excel, the documents created are often very plain. This simplicity is nothing more than the direct result of the ease of use that its creators wanted to convey. However, you can go beyond that. There are ways to customize Excel both in form and content. This way, you can make your documents as impressive as possible. Among the wide variety of tips that can be used to achieve Excel customization, we present you with four quite interesting ones.
Add a slider to your Excel document
Yes indeed! What could be classier than having sliders (scroll bars) appear in your Excel document or presentation! Not only can quick simulations be performed with this feature, but it will surely help you to grow in reputation among your colleagues, as it will inspire the image of an Excel expert.
A lire également : Essential Tips to Optimize Your Mac Usage
A complete tutorial on how to achieve this is available on the site apprendreexcel.com. You will find many useful tips and tutorials on the Google+ page and on the Facebook page of the site, useful for novices, intermediates, and experts alike.
Lire également : Gas Lawn Mower: 4 Tips Before Buying
Change the color of the tabs
As you may have noticed, all the tabs in Excel workbooks appear in a grayish color. But knowing that a colorful presentation facilitates understanding, you can differentiate the tabs by assigning them different colors. To do this, the procedure is quite simple.
- Hover over the tab you want to modify and right-click.
- In the list that appears, click on tab color
- Then select the color that suits you best from the color palette that appears by simply clicking on it.
- And there you go! You will automatically see the color on the tab.
Protect your worksheet
With Excel, it is possible for several people to work on the same workbook or the same sheet. This is an option often used in companies to save time by making information accessible to all contributors at the same time. To ensure that there are no inappropriate additions, you have the option to restrict the permissions granted to different users. The procedure to follow is as follows: activate the Review tab and then click on Protect Sheet. A window will appear where you can define all the rights of the participants while inserting a password. That’s it, you have just protected your worksheet.
Create a stunning format for your Excel documents
The presentation of a document is often a factor that defines the reader’s enthusiasm to read it or not. With Excel, one might think that formatting our documents is not possible. This is completely false. You can already add a footer to your Excel documents. Start by clicking on Insert then on Header/Footer in the Text section. Depending on whether you want to insert a header or a footer, expand the corresponding list, select page 1 of? Then confirm by clicking OK, and that’s it, your pages will be numbered.