When we enter data in a table, we often need to edit them in a ascending or descending order. In other words, sorting them. Excel offers quick sorting, according to the content of the first column in the table, as well as advanced sorting where it is possible to set several criteria and select multiple sorting methods. The following text will detail the sorting of data, and I’m sure you will learn something new.
Subject of one of the previous posts was using styles in Excel. Themes can be viewed as their upgrade that allows us to define color palettes, fonts and effects. The most useful is, I think, the ability to change color palettes. This option allows you to adjust completely different colors than usual in the color or font colors of the font formatting menus. Let’s explain how this is done.
Comments are graphic objects and therefore we can change their appearance. Why should we do it? Perhaps to be original, that the reports we made look different from the others? In this case, we can change the form of comments. And then, we can change the style of the text in the comment or the color of its background. Let’s show you how to comment with certain comments on certain parts of the report!
More people working together on one document is a common practice. Sometimes it is necessary to leave a comment for harmonization of work with other users or easier understanding of the data and procedures during the budget creation. The comment should be visible, include the name of the person who commented on content and can, if necessary, be easily removed from the screen or not printed along with the data in the tables. Welcome to the world of Excel comments!
Each user of the Windows operating system should be familiar with the Cut, Copy and Paste commands. In addition to cropping, copying, and pasting content, Excel also offers “advanced paste“ options that are enabled with Paste Special option. With it, we can choose whether we only copy a content, format, content and format, or something else. The many options it offers make it easy to format existing tables.