[Excel] If you hide the leftmost columns and rows, you can no longer return!A technique to redeemed columns A and 1 line with Excel

I don't know how to redeemed the first line at the left end and the top of the top!

　"If you take over the book from other people, the column A and the first line are hidden, so I do not know how to re -display it, so I was in trouble."I don't know ... "

　Since the previous article explains how to redeemed hidden columns and rows, many readers may already be used in business.If you select the entire column (line) with a hidden column (line), you can redeemed it.However, if the column A on the left side of the table or the first line at the top is hidden, the row (line) of the hidden column (row) is a column (line).), I feel like I can't do this in this way.

　This time, I will explain the technique to be redesified when the first line at the left end of the table and the first line at the top of the table is hidden.

The usual way cannot be used for re -displaying column A!?

　For example, we consider a situation that "I want to redeemed the hidden part because I inherited the aggregation table (①) of the new product questionnaire results in which A to C columns are hidden." Let's.

　In the usual way, drag the row heading on the left and right of the hidden part and select two columns, but this time there is no column on the left side of the hidden part.To click, right -click (②) the column heading of column D and click [Rede display] (③) in the menu displayed.

　However, column A to C is not redesigned (④).

　In this operation, column A to C cannot be redesified.How can I redeemed it?

Multiple columns and rows, including columns A and first lines, are redesified by stepping on two steps

　As in this example, if some columns, including column A at the left end of the table are hidden, are re -displayed in two steps.

　First, use the [Name] box to select column C from column A.This is the point of the technique described this time.

　Enter "A: C" (①) in the [Name] box where the cell number of the active cell is displayed on the left side of the mathematical bar and press the [Enter] key (②).

　It may be difficult to understand in the image, but a thick green line (③) is displayed on the left side of column D.This has now been selected from column A to column C.

　With this state, click [Home] tab (④) → [format] (⑤) → [Hide/Reverse] (⑥) → [Redege column] (⑦).

　Then, column C (⑧) is redesified from column A.

　If some columns, including columns A, are hidden, first use the [Name] box to select a hidden column and then redeemed the column.That's good.

　The method of entering "A: C" in the [Name] box and selecting column C from column A can be applied when some rows, including the first line at the top of the table, are hidden.increase.For example, when selecting the first line to the third line, it is OK to enter "1: 3" in the [Name] box.

　In addition, the story is a bit off the selection of rows and columns, but if you enter the cell number in the [Name] box, you can immediately move to a specific cell.It is a useful trick when dealing with a large table, so it is convenient to remember this.

Freely switch display and hide everywhere in the sheet to improve business efficiency

　This time, we explained techniques that redeemed some columns and rows, including the hidden columns A and the first line.

　If you use the technique described this time, you can switch between display and hide anywhere on the sheet, and you can handle books in various tasks.

　If you can switch to display and hide, your work will be much more efficient!Please learn the techniques described in this article and use it for various tasks.

This month's Exceltips