How to create an easy-to-read Excel document What is the reason why "cell merging" is legal for the time being?

Photo: NIKKEI STYLE

How long are you in front of your computer during your day-to-day work? If you shorten it by 10 minutes a day, it will swell to about 43 hours a year (in the case of 105 days of holidays). What if I could spend that much time on other work? How to make it easy to understand for those who see the material. And which of Microsoft Word and Excel, which business people often use, can be finished faster and more beautifully? Let's hold down the basic points with Mr. Shizuko Shirei, a computer instructor. This is the first edition of Excel. What kind of table do you usually make in Excel? In some cases, the data copied and pasted from some material may be tabulated in Excel, or in other cases, a table may be created to collect various information and aggregate it into multiple items. Naturally, how to create a table and the functions you want to use will change depending on the application.

Learn "list table" and "summary table"

Photo: NIKKEI STYLE

Here are some words I would like you to remember. It is a "list table" and a "summary table". When creating these, be aware that the formats themselves are different.

The life of the list is accuracy and visibility.

Photo: NIKKEI STYLE

Lists Tables are important data as tables that are the basis of various aggregations. Therefore, it is required that there is no notational fluctuation or input error of the data, and that the data is easy to see in the format. First, let's talk about the format at the time of creation. In a list table, always create an item (field) in the first row of the table. It is easier to use if you do not arrange various items vertically (for example, in the same column such as the left end) and do not arrange the items in multiple rows. And it's best not to use cell merging in list tables. This is because aggregates and filters will not be available.

When creating a title using cell merging in the first row of the table ... If you press Ctrl + A to select one shot, the title row will be selected.

● Avoid merging cells in a list table Do you need a title row? If you put the name corresponding to the title in the heading part of the sheet displayed as "Sheet1" and "Sheet2" at the bottom, you can see what data is entered during the work. Also, by setting a title in the header when printing, it is not necessary to create a title line on the first line of the sheet. You should avoid the following creation methods that you often see.

1/4 page