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

  • How to copy the same text box in Word Steps to quickly copy multiple identical text boxes in Word
    How to copy the same text box in Word Steps to quickly copy multiple identical text boxes in Word
    Method 1: Select the text box, hold down the Ctrl key, and click the letter D at the same time. If you want to copy N identical text boxes, click the letter D N times. The result is as shown in the figure: Method 2: Select the text box, hold down the Ctrl key and the Alt key , drag the text box to the specified position at the same time, and release the mouse, thus completing a copy. If you want to copy N identical text boxes to different specified locations, just hold down the Ctrl key and Alt key while dragging the newly generated text box multiple times to the specified location.
    Office Software 492 2024-06-02 15:40:46
  • How to use multi-person editing of Tencent documents
    How to use multi-person editing of Tencent documents
    1. Preparation work: Create a new EXCEL document. Before you can officially start multi-person editing of Tencent documents, you first need to create a new document, such as an EXCEL document. Tips: Click the [New] button in the upper right corner of the homepage to start creating a new document. After the new creation is completed, you can edit the document. Revise until you have completed your personal edits. Tencent document permission settings After editing the document, click the [Share] button in the upper right corner of the page to open the [Document Rights Sharing] setting interface and pay attention to the interface. The upper part is where the file permissions are set. After opening, set the permissions to [ Anyone who obtains the document link can edit] Tencent Document Sharing Click the QQ icon below [Share to] to open the [QQ Friend Sharing] interface and find friends by clicking on the group or searching directly in the search bar.
    Office Software 707 2024-06-02 15:34:02
  • How to match Excel table data to another table How to match Excel table data to another table
    How to match Excel table data to another table How to match Excel table data to another table
    Enter [=vl] in the cell. Click on the blue icon in the picture. The interface as shown in the figure appears. Click on the student name that matches the gender, then add a [,] after the data. In another table, select all data. Fill in the data appearing in Sheet1 in the overall evaluation table. Since the data that needs to be matched is in the second column of Sheet1, add [,2,] after the data (where [,] is a comma in English), and then click Enter. A row of gender matching is completed, as shown in the figure. Place the cursor in the lower right corner of the gender cell in the first row. When the plus sign appears, double-click the left button. This way all genders are matched, as shown in the picture.
    Office Software 489 2024-06-02 15:19:15
  • How to add endnotes in Word_One setting
    How to add endnotes in Word_One setting
    1. First, we set the cursor to the position in the document where we want to insert the endnote. 2. Then click [Citation]-[Insert Endnote] above. 3. In this way, the endnote is inserted into it, and you can add the content of your endnote inside. If you want to remove the lines above the endnotes, you can do this: 1. First click [View] - [Outline View] above, and then click [References] - [Show Notes] above. 2. In this way, the endnotes can be displayed in the outline view. 3. Then select [Endnote Separator] in the endnote and delete the underline. It is very simple. If you want to delete the endnote, you need to notice that there is a small i icon where the endnote was previously inserted. Delete this icon and the endnote will be deleted.
    Office Software 368 2024-06-02 15:00:10
  • How to adapt Word pictures to tables_One setting is all it takes
    How to adapt Word pictures to tables_One setting is all it takes
    First, we delete the picture, and then right-click on the grid in the table where the picture is to be inserted and select [Table Properties]. In the menu of table properties, we click [Options] and uncheck [Automatically resize to fit content] in the table options. Then click OK, and then we insert the picture again and find that the picture will automatically adapt to the size of the table. You do not need to adjust it manually. The size of the inserted picture will be as large as the table.
    Office Software 426 2024-06-02 14:50:26
  • Where are the placeholders in ppt_ppt setting placeholder tutorial
    Where are the placeholders in ppt_ppt setting placeholder tutorial
    1. Click View and click Slide Master. 2. After selecting the first chapter slide, click on the slide master and click on the master format to see the placeholders that the page has. If you have all the placeholders, you cannot check them in the master layout. The button can only be used when the placeholder is used.
    Office Software 1018 2024-06-02 14:46:31
  • How to set sharing permissions for WPS documents Introduction to WPS document sharing permissions
    How to set sharing permissions for WPS documents Introduction to WPS document sharing permissions
    2) When the collaborating user (document creator) opens the document and clicks "Collaborate" in the upper right corner of WPS, he will first enter the WPS online collaboration service Kingsoft document interface. Then please click "Share" in the upper right corner to freely set permissions. The default permissions are "Anyone can edit". After sharing, others can click to directly enter the collaboration mode, where multiple people can edit online and save changes in real time.
    Office Software 435 2024-06-02 14:44:35
  • How to make an organization chart in Word_Can be done in half a minute
    How to make an organization chart in Word_Can be done in half a minute
    First we need to write the text content of the organizational chart, and then use the TAB key to classify the organization. Then CTRL+A selects all and CTLR+X cuts. And select [Insert]-[SmartArt] and select [Hierarchy]-[Organization Chart]. Then directly CTLR+V in the text box where the text is entered to paste. In this way, all the organizational structures are copied into one chart, which is very simple.
    Office Software 835 2024-06-02 14:42:39
  • Where is the clipart in PowerPoint 2016? Introduction to the location of clipart in PowerPoint 2016
    Where is the clipart in PowerPoint 2016? Introduction to the location of clipart in PowerPoint 2016
    1. First ppt, after entering the ppt interface, click the format option above, and then select the slide layout option in the menu that opens. 2. Next, the slide layout menu will appear on the right side of the ppt software. Choose a blank layout. 3. Click the insert option above the ppt software, and then select the picture in the menu that opens. Next select the Clip Art option in the image's extended menu. 4. Then we can see that the clip art menu appears on the right side of the ppt software. 5. You can search in the menu according to the clipart you want to insert. After the search is complete, find the clipart you want to insert and click it. 6. Then you can see that the clip art has been inserted into the blank ppt interface on the left.
    Office Software 722 2024-06-02 14:34:38
  • How to compress 7Z format compressed files?
    How to compress 7Z format compressed files?
    7Z is a compressed file format. If you want to compress the file into a 7Z format compressed package, you can use 7-ZIP decompression software to compress the file. 7-Zip is a completely free and open source decompression software. We can download it from the official website or related software stores. Compression steps: After downloading the software, select the files or folders that need to be compressed, then right-click the mouse and select [Add to compressed package] in the 7-Zip list to compress. After the dialog box pops up, select the "7Z" format in the [Compression Format] column, and then click [OK] to start compression. Of course, we can also set related options during compression as needed. For example, set the compression volume through [Volume size, bytes] to compress the file into several large and small formats.
    Office Software 947 2024-06-02 14:12:49
  • How to use the vlookup function How to use the vlookup function
    How to use the vlookup function How to use the vlookup function
    If there is duplicate data in the table, conditions must be added to limit the query. The formula used to find Class 2 Li Bai in the picture is [=VLOOKUP(F5&G5,IF({1,0},A3:A11&B3:B11,D3:D11),2,FALSE)]. 3. Reverse search We want to use VLOOKUP to query Li Bai’s job number, which is a reverse search. We use the known name to find the job number on the left. The formula is [=VLOOKUP(F5,IF({1,0},B3 :B11,A3:A11),2,FALSE)]. 4. One-to-many query: One information matches multiple employees, and the employees’ names are viewed according to the section. The picture below takes the marketing department as an example to query all the employees in the marketing department.
    Office Software 676 2024-06-02 14:12:04
  • How does Excel prompt that table highlighting is disabled when importing web data?
    How does Excel prompt that table highlighting is disabled when importing web data?
    When importing data again, select [Data] - [Get Data] - [Traditional Wizard] - [From Web (W) (old version)] to import web page data. Import weather data here and you can see that it is imported normally.
    Office Software 1095 2024-06-02 13:58:45
  • How to merge cells in Tencent documents_How to merge cells in Tencent documents
    How to merge cells in Tencent documents_How to merge cells in Tencent documents
    First, click on the cell on the Tencent document page. Then drag to select the area you want to merge. Then on the toolbar, click Merge Cells. Finally, click Yes, and the cells will be merged successfully.
    Office Software 503 2024-06-02 13:55:44
  • How to set up the presenter view in ppt_How to set up the presenter view in ppt
    How to set up the presenter view in ppt_How to set up the presenter view in ppt
    1. Open the ppt document and click [Show]. 2. Check [Show Presenter View].
    Office Software 1031 2024-06-02 13:54:31
  • How to align table of contents page numbers in Word_No need to teach you how to quickly align them in a minute
    How to align table of contents page numbers in Word_No need to teach you how to quickly align them in a minute
    First, we select the entire table of contents text, then right-click the menu, select the paragraph in it, and click the tab stop below. The tab position is filled with 38, which is where the table of contents page is. If the page size is not the default, please use the ruler above your page to determine it. Then select right alignment for alignment, select 2 for leader, and finally click OK. Next, position the cursor in front of the table of contents page number, and then press the TAB key to align the table of contents to the far right.
    Office Software 1443 2024-06-02 13:40:19

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