[Excel] Create vertical writing with Excel!? Convenient technique for creating a vertical ceremony

I was asked to make a ceremony, but I have never written vertical on my computer!

The boss who took care of me was transferred to another department at the end of this month, and my colleague told you, "I want you to make the ceremony of the farewell party next week in vertical writing ..."

I'm not confident in handwritten letters, and I feel like it's the fastest and beautiful finish to make it on a personal computer, but I've never written vertically on a computer.What should I do in such a case?

In fact, Excel can easily create vertical documents.This time, I will explain how to create a vertical writing with a familiar Excel.

Make it in horizontal writing and change it to vertical writing

Now, let's make the ceremony depending on the Excel.If you want to make a vertical writing with Excel, it's easy to change it to vertical writing after entering it in horizontal writing.The first cell to enter is a cell A1, just like when you usually make a horizontal writing table.Enter "Reference party ceremony" (①) in cell A1.In this article, the sheet name has been changed to [up to the formula] so that it is easy to explain the operation after this, but it does not have to change the sheet name in actual operation.。

After entering the cell A1, enter the same line from left to right to cell B1, cell C1, etc. (②) (②).In such cases, the content to be entered in the cell is longer than the cell width, so I think the letters will protrude from the cell, but there is no need to adjust the cell width.Enter all contents without worrying.The point is to move to the next cell at the position you want to line up when you write vertically.

After entering all contents, drag all entered cells (here, cell range a1: h1) and select (③), and at the bottom right of the [Home] tab (④) → [Place] group.Click the arrow (⑤).

The Cell Formatting dialog box is displayed.Click the [Place] tab (⑥), and in the [Direction] column on the right side of the screen, click the part (⑦) where the [character string] is written vertically.Select [Upto (Indent)] (⑧) from the [Vertical position] column displayed afterwards, and click [OK] (⑨).

Depending on the ceremony, it was displayed vertically (⑩).However, it is strange that it is written from left to right even though it is a vertical writing.In the future operation, let's fix it so that it is displayed from the right to the left, and finish the ceremony.

Fix it from the right to the left, and finish the ceremony.

In the initial settings of Excel, columns are arranged in order from the left, column A, column B, C.Let's fix the "up to the farewell party ceremony" created in the previous section.Click the File tab (①).

The [Information] screen is displayed (the screenshot of this article is scrolled a little below the screen, so the top of the screen is out.)Click [Options] (②) at the bottom of the menu on the left side of the screen.

The [Excel Options] screen is displayed.Click [Detailed Settings] (③) on the left side of the screen, scroll down the screen (④), and then display [Display the sheet from right to left] in the [Display settings when working with the following sheets].Turn the check mark to (⑤) and click [OK] (⑥).

If you first name the sheet, the specific sheet name will be displayed in this [Display Settings for Working in the following sheet] column.There are many similar items on the [Excel Options] screen, so if you display the specific sheet name here, it will be easier to find a place to check marks.

The [Excel Options] screen closed, and the line was lined up in order from the right side of the seat, and the ceremony was a natural vertical writing (⑦).

In this state, it feels like it was made with Excel, so let's devise a little.Just as when creating a horizontal writing table, operate the [Font] group (⑧) button on the [Home] tab to change the type and size of the font, it will depend on the look better (⑨).

However, you need to be careful when you want to set an indent (character down) while writing vertically.Clicking on the [Home] tab indent button in the vertical writing state does not set the indentation.Depending on the formula you are creating, let's set an indent in the part other than the title.Drag the cell range b1: h1 where the part other than the title is entered, select (⑩), and click the arrow (⑫) at the bottom right of the [Home] tab (⑪) → [Place] group (⑫).It is the same as the place you clicked when you first change to vertical writing).

The [Cell Format] dialog box is displayed again. Click the upper and lower arrows in the [Place] tab (⑬) → [Indent] column to set the number of characters to be lowered (⑭), and [OK].Click (⑮).

The indentation has been set, and the easy -to -understand and good -looking formula has been completed (⑯).

By the way, is there no effect on other books by setting the columns from right to left like this?Some readers may have thought.Since this setting is made for each sheet, there is no such thing as writing a single sheet vertically, the lined up of the cells from other Excel books and seats.Please be assured.

With a little technique, you can make vertical writing documents with Excel!

This time, I explained the technique of creating a vertical expression with Excel.In Excel, many people may be surprised that the arrangement of characters can be surprisingly easy to change.

In the article, I created a vertical writing document by writing the entire cell input vertically, but it is also a technique that can be applied in various ways, such as when I want to write only a part of the table vertically.

By all means, please use the contents described this time in various situations in business.