current location:Home > Technical Articles > Software Tutorial > Office Software
- Direction:
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify:
-
- How to open a specified workbook when Excel starts_How to open a specified workbook when Excel starts
- 1. Open the Excel table, and then click [File] → Excel Options on the toolbar 2. Click the [Advanced] menu in the Excel options, pull down in the Advanced and find [Open all folders in this directory at startup] in [General] ], and then we can set the folder content. 3. In this way, when we close Excel and reopen it, the specified workbook can be automatically started.
- Office Software 704 2024-04-25 13:28:28
-
- How to use wps to make a table_How to use wps to make a table
- Step 1: Open the wps software, click [Table] at the top, and then click [New Blank Document], as shown in the figure below. Step 2: Enter the wps table, select the 10 rows and 6 columns of cells as an example, find the symbol like [田] at the beginning, and add a border line to the cell, as shown in the figure below. Step 3: Then select the first line and use the combined sentence to enter a concluding word. You can also add a background color, as shown in the figure below. Step 4: Just enter your own data in other blank cells, and a simple wps table will be created, as shown in the figure below.
- Office Software 1232 2024-04-25 13:28:13
-
- Graphics and text steps for inserting Internet graphics into wps
- Open the wps software, enter the wps operation interface and find the insert option from the top main menu bar. After opening the insert option, you can see the shape function. Click to open the shape and you can find the Internet graphic. After selecting the Internet in the shape, We need to click the left mouse button in the blank space of WPS, which can also be said to be the place where we want to add the Internet graphic. We can adjust the size of this Internet graphic by clicking on the small points on the boundary of the graphic and then clicking on these points. By stretching, you can change the size of the graphic at will. You can also set the specific layout of the graphic. After clicking on the graphic, a small operation bar will appear next to it. Click on the layout option at the top to select a specific layout.
- Office Software 443 2024-04-25 13:22:30
-
- A simple way to set up automatic document saving in word 2010
- Click the [File] button in the upper left corner of the word window and select [Options] in the opened panel. A [Word Options] window will pop up, select [Save], and then set the time interval and path location for automatic document recovery.
- Office Software 607 2024-04-25 13:22:19
-
- How to add fonts in WPS_How to add fonts in WPS
- First, we go to the official forum of WPS to search and download. This is the font we need to add. This is a writing habit. Running script looks more real. If follow the font. Here are the fonts owned. Here is what we wrote using this font. Click on the attachment to download the font. Click to install and restart WPS, and you can use WPS fonts.
- Office Software 726 2024-04-25 13:20:34
-
- Where is the location of the temporary file automatically saved by ppt_List of temporary file locations automatically saved by ppt
- Step 1: Click on the file in the upper left corner of the ppt document and click [Options]. Step 2: There is an [Automatic recovery file location] in the [Save] tab. This path is the address of the automatically saved file.
- Office Software 979 2024-04-25 13:19:26
-
- How to locate bookmarks in word 2003 documents
- Open the word2003 document window, click the [Edit] → [Locate] menu command (you can also press the F5 key directly), open the [Find and Replace] dialog box, in the [Location Target] list in the [Locate] tab Select the [Bookmark] option, then click the [Please enter the bookmark name] drop-down triangle button, select a specific bookmark in the opened bookmark list, and click the [Locate] button. Through the above steps, the insertion point cursor in the word2003 document will be Navigate to the location of the selected bookmark. Tip: You can also locate bookmarks through the [Bookmark] dialog box in word2003. Click the [Insert] → [Bookmark] menu command in sequence to open the [Bookmark] dialog box, select a specific bookmark in the bookmark list and click the [Go to] button
- Office Software 389 2024-04-25 13:16:30
-
- How to create pinyin field grid in excel
- 1. Select the entire table, place the mouse on the column mark, right-click the mouse, and click [Column Width] to set the column width to [2]. 2. Select [Merge across rows] to merge separately. 3. Select the border button and click [Other Borders]. 4. Select the straight line style as solid line, set [Color], click [Outer Border], [Inner] to set the border, and finally click OK. 5. Select the first three rows, place the mouse on the row mark, right-click the mouse, and click [Row Height] to set the row height to [9]. 6. Select four cells, open the border setting window, first select [Straight Line Style] as solid line, click [Outer Border], then select [Straight Line Style] as dotted line, click [Inner], and finally click OK. 7. Select the four cells that have been set, place the mouse in the lower right corner, turn it into a cross shape, and drag to the right to fill in the
- Office Software 1150 2024-04-25 13:16:11
-
- Introduction to how to create a cylindrical shape in word
- 1. Click "Insert" on the menu bar. 2. Click "Shape" in the "Insert" toolbar. 3. Find "Basic Shape" in the "Shape" drop-down option. 4. Click "Cylinder" in "Basic Shape". 5. Drag the mouse to draw a cylindrical shape.
- Office Software 972 2024-04-25 13:13:05
-
- How to set the outside alignment of page numbers in Word_How to set the outside alignment of page numbers in Word
- The first step is to open the document and click [Page Layout] in the menu bar and click the small icon of [Page Setup]: The second step is to select the [Layout] tab, header and footer in the [Page Setup] dialog box Check [Odd and even pages are different] and click [OK]: The third step is to click [Insert] - [Page Number], and select [Outside Footer] in the page number preset style: As shown in the figure below, after the setting is completed, the odd-numbered pages The page number is displayed in the lower right corner, the even page number is displayed in the lower left corner, and the page number is on the outside after printing:
- Office Software 1127 2024-04-25 13:10:34
-
- How to make Excel risk coordinate chart_Excel risk coordinate chart method
- 1. Select the data area - click Insert - Recommended chart. 2. All charts – scatter plots. 3. Double-click - Set axis format - Unit (set as needed). 4. Double-click - Format data series - Mark (adjust the size of data mark options). Padding – No padding. Border - solid line. 5. Right-click - Add data label. 6. Double-click - Set data label format - Label options - Pass the data label area (select as needed). Label position - centered. 7. Use PPT to create a table as shown in the picture and save it as a picture. 8. Double-click the drawing area - format the drawing area - fill with pictures or text - insert pictures from files.
- Office Software 810 2024-04-25 13:10:25
-
- How to count inventory in Excel
- First we enter -1 in a cell next to the table, then copy it, and then select the inventory quantity. Right-click and select [Paste Special], and select [Multiply] in the operation. In this way, the inventory count will temporarily become a negative number. Then find [Consolidated Calculation] in the [Data] tab. Then add the two data areas respectively, and check the lower label position as [Leftmost Column]. Finally, click OK, and an inventory table will be generated. Except for data other than 0, everything else is the difference! Isn’t it very intuitive?
- Office Software 1103 2024-04-25 13:10:05
-
- How to hide or show bookmarks in word 2010 document
- Open the word2010 document window and click the [File] → [Options] button. Open the [Word Options] dialog box and switch to the [Advanced] tab. In the [Show document content] area, cancel or select the [Show bookmarks] check box, and click the [OK] button.
- Office Software 1286 2024-04-25 13:07:28
-
- How to convert pdf format to ppt_How to convert pdf format to ppt
- 1. First use WPS to open the pdf document. 2. Then click Start, click the inverted triangle icon next to [pdf to office], and finally click [pdf to ppt].
- Office Software 857 2024-04-25 13:04:05
-
- How to limit the Excel table to only enter dates before 2019_Excel table to limit the entry of only dates before 2019 operation tutorial
- 1. First find the Excel document that needs to be edited, double-click to open it and enter the editing interface. 2. In the editing area, select the cells that need to limit the date input range. 3. In the upper ribbon, click the [Data] tab. 4. Click the [Data Validation] button in the [Data Tools] group. 5. In the pop-up [Data Verification] dialog box, select [Date] in the [Allow] drop-down box. 6. Select [Less than or equal to] in the [Data] drop-down box, enter [2018/12/31] in the [Date] box, and click OK. 7. Return to the editing area. When you enter a date that is not before 2019 (for example: 2019/1/1) in the set cell, an error message will appear, indicating that the setting is successful.
- Office Software 964 2024-04-25 12:58:35