Urgent!!! WHO KNOWS HOW TO SOLVE THE FOLLOWING SEVERAL PROBLEMS IN EXCEL USAGE?

1.Create a separate table for the parts to be copied to Word, and delete the rows and columns of the hidden parts of the table (unhide). Redraw the border and copy it to Word. Hiding doesn't work when copying to word.

2.Use the formula function. Point on the cell that needs to be associated, and the destination is anywhere on another table.

3.Copy-New Cell Right-Click - "Paste Special" - "Numeric".

First question.

Save excel as a web page.

Use word as the tool for a web page to open the page.

You can get ** that conforms to the word format.

Second question.

OK. For example, L20 in Worksheet 12 needs to be associated with A1 in Worksheet 1.

In Worksheet 1, enter A1 with "=".'12'!L20", the result is shown as the L20 content in Table 12.

Convert to PDF format first, connect directly in it, and then turn it back.

After reading it, you can understand it all, and you can learn more skills that you don't know).

2. After associating two worksheets, can I only enter the same content in the same position, and can I realize worksheet association in different locations?

Yes, as long as the two tables are in the same workbook, you can use the connection in the tool.

The third question:

After copying, select in the new cell: "Paste Special", after which select "Numeric", and then it's good to go.

The first problem is that you need to remove the excel hide before copying it. Because, copying contains hidden content. This is not the case for Word.

The second problem is that when you choose to link, you can choose the location you want to link, then that's fine.

The third problem is that when pasting, select "Paste Special" and then select "Value", and you can achieve it.

Let me come to question 3: if you use paste special when pasting, you only need "value" instead of "all". You go and give it a try.

I agree with what the 2nd floor said, although it's not specific, but that's probably what it means.

The second problem is to enter the same content in different cells of different **, you can associate the cells with the same content, as long as the content is entered on the associated **, the content on the other table will naturally be there.

You will know that you need to use hyperlinks and macros in a few more attempts, and these things are rarely mentioned in the book, so you have to try them yourself.

Simple. Suppose the column in which the locker cell is located (the name column) is in column B and the quantity is in column C, as if:

a b c name quantity.

Locker 8 computers 1

Desk 2 I. Add the formula to the column before the name column. In this example, in column A, add "1" to cell A2 before the first name, and add "=A2+C2" to cell A3, and copy the formula of cell A3 down until it exceeds column B (name column). If the last "desk" is in cell B4, then the formula in column A is copied to cell A5.

2. Add "1" to cell E2, "2" to cell E3, and "3" to cell E4......That is, column e is sequentially filled down until it is equal to or greater than the sum of the quantities, which is greater than or equal to the maximum value of column a.

3. Add the formula "=vlookup(e2,$a$2:$b$5,2)" to cell F2 and copy it downward. where "$a $2:

"b$5" refers to the range of cells with data in columns A and B. The formula can also be "=vlookup(e2,$a:$b,2)".

Copy all the way to the same as the maximum serial number in column E.

ok!That's it!

It is displayed as: a b c d e f g

Serial Number Name Quantity Serial Number Name.

1 Locker 8 1 Locker.

9 computers 1 2 lockers.

10 Desks 2 3 Lockers.

12 4 Lockers.

To be on the safe side, make one copy first, select all, click the Merge Cells button on the toolbar once, and then fill in the split cell data according to the data before splitting.

1.You check that the file you open is not shared on the server.

2.Check to see if you have an invalid printer connected.

3.Have you ever set it up or something?

4.Either reinstall or repair Office.

The first question is that you check whether all excel files are like this, if it is just a specific file, then there is no problem, sometimes the formula function used is recalculated every time you open it, so there will be no operation after opening, but the report file has been modified;

The second problem is estimated to be that your office program is not good (the 2007 version of Word is very unstable on some computers), and it is recommended to use 2010 to feel much more stable.