Excel教學 E70 | 十字光標格式設定，避免看錯資料行 | CROSSHAIR HIGHLIGHT | CELL、ROW、COLUMN函數

Hello everyone, today I will share with you the setting of this cross cursor. After students see which address the teacher moved to , press F9 and the crossed column and column will display the color of High Light. This usage is convenient for students to read materials. Sometimes, avoid reading the wrong line. Sometimes when the information is too complicated, you really need the cross cursor to assist . In this place, the teacher does not click on any address, and the cursor will appear immediately. The reason is because if you want to set it to click it immediately. When the cursor appears, it must be matched with a program of VBA. If we use VBA, we have to save the file as a macro file. However, Microsoft is now stricter about the requirements for macro files. You must lower your security. Some companies also filter out The file of macros, so the teacher will not use macros today. When you need to see the cross cursor, you can press F9 and you can immediately see the rendering of the cross cursor. Let's go to the function description page first, and then I Now let's say I'm in the address of C1 this place. This place if I use a Cell function Cell and then the left parenthesis Cell it can return the content we specified. For example , I now want it to return the column number where I am now. So we You can select this ROW and click twice, we can see that there are two primes before and after the ROW, and then the right bracket Enter ok, it will transmit that we are now on the 1st column number, then I will now put the cursor after the 8th column, and I press F9 Let it update it, it will know that my cursor is currently on the 8th column. If I click on the 15th column and F9 again , he will tell me that your cursor is above the 15th column. The same is true of the part. I now if the cursor is placed in the D column , here we are =Cell and then the left bracket. I want to return which column my cursor is in now. We choose this COL and click twice . After the right bracket, he tells me you Now the cursor is in the 4th column and 1234 is in the 4th column. My cursor is in this place in the Q column . I don't know what column it is. We hit F9 so it can return that my cursor is on the 17th column. My cursor is at A1, then F9 and he tells me that your cursor is on column 1 and then on column 1. Then we know this function, it can return the address where your cursor is now, we can use this Concept Apply it to our formatting conditions. Let's go back to the S page first. We select all in the data with Ctrl+A. We go to the common tab to find the conditional formatting settings. After selecting this management rule, we add a new rule and then use The formula here is =Cell and then the left parenthesis, and the two apostrophes have to be ROW and two apostrophes. In this way , it only returns which column your cursor is in now, right? But we have to tell him what you want to be equal to, which is equal to the column where my cursor is located. No. So we want =ROW then left parenthesis right parenthesis That is to say, the returned address is equal to the address where I am now. There is no problem. Then we give it a color. After the format comes in, fill it up. Give it a color I want. OK, our function will judge that part of the column has not yet been formed, so the cross has not formed only the column part. We first press OK to see the effect. Which column is our cursor on, and then press F9 ok, it will jump the color, right? Only that column has color. After there is no problem, we will do the part of the column Ctrl+A and then we will go to the formatting conditions. Common tags, conditional formatting, management rules After entering, we will repeat the rules and click the above two times. Let 's change the part of this column to a column COL ok , what should be equal to the back of the column ? The part of the column must be typed , so it can't be abbreviated COLUMN ok Ok , after the color is the same, we can confirm and then confirm that we are the same. Which one do we have punctuation now? Save the cell and then press F9 ok to see the cross cursor. The setting of the cross cursor is very simple, so if you need it, you can open your file and follow the settings . Then share it with you today and see you next time. , bye~*

Channel: Meiko微課頻道

Views: 82,884

Keywords: 溢位 #SPILL錯誤, excel, 跨頁合併, 合併工作表, 彙整工作表, 跨页合并, 合并工作表, 工作表合并, 汇整工作表, excel vba教學視頻, excel vba範例, microsoft excel, Excel行事曆, Excel列表記事, excel 行事历制作, excel 行事历设定, vlookup, Excel月曆, excel 公式及函數運用, excel 公式鎖定, Excel年度行事曆, excel 月曆製作, 取出字串內的文字, 尋找取代, 班表, 員工出勤記錄表, 自動排班表, 補班日, 樞紐分析, 透視表, 取出工作表名稱, 儲存格串接, 串接儲存格, 多條件加總, sumifs函数, sumif, dsum, 甘特圖 excel, gantt chart, 鎖住圖片, 溢位 excel, #SPILL錯誤, 三層下拉清單, Filter, 進階篩選, 陣列, 擷取PDF文字, 提取PDF文字, 多欄轉單欄, 十字光標, CROSSHAIR HIGHLIGHT

Id: hq26Vld62GM

Length: 4min 59sec (299 seconds)

Published: Sun Sep 11 2022