How do I display a large number of Excel form names in one table?

on error resume next

for j = 1 to 1000 'This 1000 indicates the number of worksheets to be registered, and you can set it to a larger size depending on the number of worksheets you want to process.

filename:= & "\" & j & ".xls" 'Here means that the worksheet you are working on is in the same directory as the worksheet you want to open; In addition, j here is the name of the worksheet you want to open for operation, provided that you change the name of the worksheet to j first, that is, rename it from 1 to j.

That's the key. for i = 1 to

workbooks("Create a new Microsoft Excel worksheet. xls").sheets(1).

cells(j, i) = 'Here"Create a new Microsoft Excel worksheet. xls"Replace the contents in quotation marks with the name of the worksheet you want to put all the data into.

next j 'Next worksheet.

Paste the above program under the macro you created, but be sure to pay attention to the notes written on the side, 1 is to change the name of the worksheet, 2 is to be"Create a new Microsoft Excel worksheet. "Swap a few characters with the name of the worksheet where the macro is located. If it's not clear, you can leave a message in my space.

There seems to be no solution to this problem.

Summary. Hello, according to the question you said, the answer: 1. First open Excel**, you can find that the "name box" is not displayed in **, first click the file in the upper left corner.

2. After entering the file page, click "Options" in the bottom left corner. 3. Then click "Advanced" in the pop-up options dialog box. 4. Enter"In the "Advanced" column, find the "Display" item, select the checkbox in front of "Display Bar", and click OK.

5. You can find that the "name box" in ** has been displayed.

In Excel, the name is displayed below **, how can I make the name appear above **?

Hello, I am very happy to serve you, I know the high-quality answer, I have received your question, I will reply in time after reading, and ask after the gesture shooting, because there are too many lists in turn, which life will not be Li Zhu limb, please be patient!

Hello, according to the question you said, the answer to the eggplant is broken: 1. First open excel**, you can find that the "name box" is not displayed in **, first click the file in the upper left corner. 2. After entering the file page, click "Options" in the bottom left corner.

3. Then click "Advanced" in the pop-up options dialog box. 4. Enter"In the "Advanced" column, find the "Display" item, select the checkbox in front of "Display Bar", and click OK. 5. You can find that the "name box" in the ** sail has been displayed.

A cell is a cell cell, it can't be a **. Cells are the basic units that make up a worksheet, and it doesn't work logically for a basic unit to contain a whole. Is this possible to ask for a class to put all the students in the same class?

I don't know what kind of situation would have such a peculiar request. And it just so happens that the "insertion**" that you exclude is the only way to fulfill your peculiar request. For example, a classmate can see the whole class in his eyes (**).

Of course, this**can also live** (it's not**, but to record the image of the state), then the missing jujube is the camera of excel (the **function of pasting as a link in the copy and paste) agrees).

This is the "camera" function of excel, this function brings up: File option Quick access toolbar, in the "Commands not in the ribbon", select "Camera Servant Machine", "Add";

How to make the old shed use: Select the data area in the worksheet, press "Camera" in the "Quick Access Toolbar", and then left-click in the target area (e.g., A1 cell) to adjust the size of A1 cell so that it can accommodate this data area, and you can do it.

It's a matter of filtering areas, so it's okay to select all of them first, and then filter them again.

1. Open Excel** on the computer, click on the inverted triangle icon in the upper left corner to select all**.

2. After selecting all**, click Filter in the toolbar.

3. After clicking the filter in the toolbar, click the filter icon in the hand of the cell, and you can see that the data is dismantled.