Page 90-excel-php.cn

Article Tags

excel

Home

Technical articles

Topics

excel

Where to enable macro settings

How to set up macros: First open Excel, click [File] in the upper left corner, and click [Options]; then click [Trust Center] and open [Trust Center Settings] on the right; finally click [Macro Settings] on the left and Check [Enable all macros] on the right and click [OK] in the lower right corner.

Dec 22, 2020 pm 05:00 PM

宏

How to select two different columns in excel

How to select two different columns in Excel: first open the document, select the two connected columns, hold down the left side of the mouse and rotate the two columns directly; then if there are two columns separated by each other, select one column first, and then hold down the Ctrl key on the keyboard Just don't loosen it.

Dec 22, 2020 pm 03:37 PM

excel不同两列

How to add page breaks in excel

How to add page breaks in Excel: First click "Workbook View - Page Break Preview"; then click the row below which you want to insert a page break; finally, in the "Page Setup" group on the "Page Layout" tab, click Just click "Separator".

Dec 22, 2020 pm 02:44 PM

excel分页线

How to extract the first few numbers in excel

How to extract the first few numbers in Excel: first open the Excel table; then find the data that needs to extract the first few numbers; then enter the formula "=LEFT(A2,11)" in cell B2; finally press the Enter key. Get the extraction results.

Dec 22, 2020 pm 02:22 PM

excel

Where to set row height in excel

How to set excel row height: first use the mouse to select the row of numbers on the left that needs to be set, right-click the selected row, and then click "Row Height" in the pop-up menu; then enter the row height in the "Row Height" dialog box After selecting the value, click the "OK" button to save the settings.

Dec 22, 2020 pm 02:08 PM

excel行高

How to split the contents of a cell into multiple cells

How to split the content of a cell into multiple cells: First open Excel and select the column "B" that needs to be split; then click "Data" in the menu bar; then find "Data" and click "Split columns"; finally select "split symbol" to split.

Dec 22, 2020 pm 02:03 PM

单元格

How to use excel positioning function

How to use the Excel positioning function: first click the triangle on the right side of the file to select Edit, Position, and select the comment that needs to be deleted; then press [Ctrl+G] to pop up the positioning window, click the comment, and click Position; finally select the data that needs to be operated form, press [Ctrl+G] to pop up the positioning function selection data.

Dec 22, 2020 pm 01:47 PM

excel定位功能

How to set the first row in excel to be fixed and not scrollable

How to set the first row to be fixed and non-scrolling in Excel: first open the table that you want to set the first row to be fixed; then select the "View" menu tab, click the "Freeze Panes" button on the toolbar; and finally select from the pop-up drop-down list Just use the "Freeze First Line" command.

Dec 22, 2020 am 11:58 AM

excel首行固定

How to display complete numbers in excel

How to display complete numbers in excel: first open the excel that needs to be processed; then select the cells that need to display complete numbers; finally, in the pop-up "Format Cells" window, select "Text" and click "OK" to display Complete numbers.

Dec 22, 2020 am 11:48 AM

excel

What to do if Excel reading mode cannot be found

How to find the reading mode in Excel: First open the table file and click View; then in the view interface, there is a Reading Mode function in the menu bar in the upper left corner, just click Reading Mode.

Dec 22, 2020 am 11:32 AM

excel阅读模式

How to retain only the filtered data after filtering in excel

How to achieve filtered data in Excel by retaining only the filtered data: First open the Excel table; then click "Filter Data" to filter the data; then click on the cells in the data with the mouse and press "Ctrl+A" to select all data; finally Just press "Ctrl+C" to copy the data and paste it into other cells.

Dec 22, 2020 am 11:23 AM

excel

How to operate reverse order in excel

Operation method: First, select the cell column that needs to be sorted in reverse order; then click the "Data" option on the top navigation bar; then select "Descending Order" in the "Sort" area of the "Ribbon", and a pop-up window will appear. Just click "Sort".

Dec 22, 2020 am 11:10 AM

excel倒序

How to extract pure numbers from excel cells

How to extract pure numbers from excel cells: 1. After entering the corresponding number in the first cell, select the area and press [Ctrl+E] to quickly fill it; 2. Enter the formula [=MIDB(A2,SEARCHB) in the cell ("?",A2),2*LEN(A2)-LENB(A2))】, then fill downward.

Dec 22, 2020 am 10:05 AM

excel纯数字

How to convert numbers to barcodes in excel

How to convert excel numbers to barcodes: First click on the menu bar option "Development Tools/Insert" and click on "Other Controls"; then select "..Control 15.0" and select "7-code-128" in the drop-down box; finally enter Number, click on the "Sex" option.

Dec 21, 2020 pm 03:56 PM

excel数字转换条形码