Table 1 Table 2 excel called a column, such as Table 2, column I wrote a bunch of career, I want a C-column table in each cell has a drop-down menu, and the contents of the drop-down menu is my Table 2 that the fixed column of occupation, how???? to …
How to EXCEL an all cells within the three-digit, automatically from big to small, or small to large order? My objective is to find in the middle of three-digit number. This is not What you wrote the formula Khan …… data in column A, B1 = large (A $ 1:A …
I take the mouse in the form of a dynamic, slide the mouse directly to the bottom to excel then ask you why the brother and sister This is a normal Excel version of a function of high, double-click a selected cell the time frame will jump by double-clicking the …
Click the H, input = f1 * g1 press ctrl + enter like a Thank you cell in the H column enter:= F1 * G1, hit Enter.And then put the mouse on the cell lower right, when the cross is to hold down the mouse into, dragging down the number …
If a cell when the data for the 80-100, in addition to automatically display a cell outstanding need to show that the situation in the cell enter:= if (A1> = 80, “excellent”, (if ( A1> = 70, “good”, (if (A1> = 60, “pass”, “Fail “))))) can display more than 80 …
The A1 – G1 merge cells, in which to write words on end, and the character spacing to be consistent, how to set? Help please help, thank you! A1-A10 will merge cells vertically and write, such as “personnel management” how to write words, following a map, please help, urgently, thank …
Space to see, it is recommended to leave a contact, hehe Thank you strongly recommended, our easy to use good software along well.A very detailed help file and use the video.
I want to fix a cell, type a text.According to the date of the change, automatically fill to a different cell.For example:I am on Dec.13 in cell A1 enter the 123, he will automatically fill the cells B1, to December 14, I also enter 456 in cell A1, he is …
My sheet1 in a month of production as the product name in sheet2 b as product specifications in a, b as the product name and specifications of all reference to what to do when the input product name corresponds to b out in the corresponding product specifications cell in sheet1 …
You to display the number of bits too little and too much is that you store the results of the cell is too narrow bar, pull-point try wide. You install in place, some functions must be fully installed circumstances to use, because some functions are complementary or mutually connectivity .2 …