current location:Home > Technical Articles > Software Tutorial > Office Software

  • How to open a specified workbook when Excel starts_How to open a specified workbook when Excel starts
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28