EXCEL skills and methods?
Teach you the latest speed-up method of Excel tables-12. Excel is an all-powerful spreadsheet with powerful functions and simple operation. In addition to quickly generating and formatting various forms, it can also perform many database functions on the data in the form. Here are some tips for using Excel quickly. 1, quickly start Excel. If you often use Excel in your daily work, you can start it when you start Windows. Setting skills: (1) Start "My Computer" to enter the Windows directory, and open the "Start" folder according to the path "StartMenuPrograms"; (2) Open the folder where Excel is located and drag the Excel icon to the "Start" folder with the mouse, then the shortcut of Excel will be copied to the "Start". If Windows is already started, you can use the following tips to quickly start Excel. Tip 1: Double-click any Excel workbook in the Document command on the Go menu. Tip 2: Drag the Excel application from "My Computer" to the desktop with the mouse, and then select "Create Shortcut in Current Location" in the shortcut menu to create its shortcut. Just double-click its shortcut when starting. 2. Ask for help quickly. For the toolbar or screen area, just press Shift+F 1, and then click the toolbar button or screen area with the mouse, and a help window will pop up, which will tell the detailed help information of the elements. 3. Move or copy cells quickly. First select a cell, then move the mouse pointer to the cell border, press the left mouse button and drag it to a new position, and then release the button to move. To copy a cell, just press Ctrl before releasing the mouse. 4. Find the workbook quickly. You can search using any word in the worksheet. The trick is as follows: (1) Click the "Open" button in the toolbar, and in the "Open" dialog box, enter the full name or partial name of the file, which can be replaced by wildcards; (2) In the "Text Attribute" edit box, enter the text you want to search, preferably the only word or phrase you think, so that the search is easier and more successful; (3) Select "Search". The message "0 files found" will be displayed in the status bar of the Open dialog box until a file that meets the requirements is found. You have to wait patiently, and the search will end only when the open button changes from gray to available. 5. Print the worksheet quickly. If you choose the "Print" command in the "File" menu to print, a "Print" dialog box will appear for you to choose, and the program is cumbersome. To skip this dialog box, you can click the Print button on the Standard toolbar, or press the Shift key and click the Print Preview button. Excel will use the selected worksheet to select the print. 6. Quickly switch worksheets. Press Ctrl+PageUp to activate the previous worksheet, and Ctrl+PageDown to activate the next worksheet. You can also use the mouse to control the tab scroll button at the bottom of the worksheet to quickly move the worksheet name, and then click the worksheet to switch. 7. Quickly switch workbooks. To reduce the number of workbook switches, click the window where the workbook is located. To switch multiple tasks under multiple windows, it is most convenient to use the window menu. The name of the open workbook is listed at the bottom of the window menu. To switch directly to a workbook, simply select its name from the Window menu. The Window menu can list up to 9 workbooks. If there are more than 9 workbooks, the Window menu contains a command called Multiple Windows. If you choose this command, a dialog box will appear, listing all open workbooks in alphabetical order. Just click on the desired name. 8, quickly insert the Word form. Excel can process the data listed in Word tables. You can insert a Word table quickly by the following skills: (1) Open the file where the Word table is located; (2) Open the Excel file to process the Word form, and adjust the positions of the two windows, so that you can see the form and the area to be inserted into it; (3) Select a table in Word; (4) Hold down the left mouse button, drag the table into the Excel window, release the left mouse button, and put the table in the required position. 9. Quickly link online data. You can quickly establish a link with the data in the online workbook by using the following skills: (1) Open the workbook containing the data to be linked on the Internet, select the data in the workbook, and then click Copy on the edit menu; (2) Open the Excel workbook that needs to be linked, and click the cell in the upper left corner in the area where the linked data needs to be displayed; (3) Click Paste Special on the edit menu, and in the Paste Special dialog box, select the Paste Link button. If you want to create a link without opening the Internet workbook, you can click the cell you want to link, and then type (=) and the URL address and workbook location, for example: =. 10, quickly create a toolbar. Through the toolbar, you can quickly access common commands or custom macros, and you can quickly create your own toolbar as needed. The trick is: Click the Tools menu excel table. Take care of my website.