When formatting the content of a cell, one of the items that we can set up is the way the content of the cell is displayed. Since the options for creating such formats are in the Number tab of the Format Cells dialog box, the settings to be addressed are often called “formatting the number”. Although the content of a cell does not have to be a number. It can also be text, date, time or other information. Have you ever wondered: how to create custom formats?
Switching the Excel spreadsheet to another application like, for example, PowerPoint can be an inconvenient job. If it hates you to deal with details, there is a very simple way to do this, that is to convert the final table into an image, and then copy the image to the desired destination. This can be done using the Paste Special option, as well as using the Camera tool, and the following text will explain how to make the most of this option.
Excel has been here for more than 20 years. Although it can not be said that in its world “there is nothing new in the sky,” numerous problems that have been encountered by the rich Excel community, since its inception, have long been solved, and solutions can be downloaded from the Internet in the form of templates. In this text, we will say a word-two on how to find the right template for generating a document that solves the problem.
When entering data into large tables, it often happens that some of the values that we enter are repeated. Excel offers two automations that make it easy to enter. The first one is called Autofill and starts automatically as soon as we start typing the text with a template that already existed in the current column. Flash Fill offers data filling based on forms that Excel recognizes in previous columns within the same table.
Often we fill out tables with data that are meaningful strings. This can be for example the days of the week, the names of months, and so on. Therefore, it would be convenient to have automation using just enough to enter only the first member of the string, for example, “MONDAY”, and when applying a fill-in technique to Excel, automatically fill in the other several selected fields with the names of the remaining days of the week. This automatics are the Custom Lists and will be referred to in the following text.