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:
-
- A simple tutorial on using a brush to modify table line styles in Word
- 1. Click the left mouse button in the table where you want to modify the line style. 2. After clicking, when the active cursor flashes in the table, the [Design] tab will appear in the word menu bar. Mouse click on this tab. 3. The location shown in the figure in the design tab is the option to modify the table style. The first row is the line style, the second row is the line thickness, and the third row is the line color. 4. After setting the line style, thickness, and color, click the [Draw Table] button. 5. While holding down the left mouse button, slide on the table line whose style you want to modify. 6. Release the left mouse button and the line style of the table will be modified.
- Office Software 713 2024-04-26 09:31:30
-
- A simple tutorial to quickly switch between upper and lower case in word
- Using Word to design EDM, I wanted to change the English letters in the title to capitalize the first letter and lowercase the rest. I thought it was a font problem at first, but I changed it several times and found that it didn't help at all. I want the following effects, but the above situation always occurs. What is going on? In fact, this is a misunderstanding. This problem is just because the template sets an option for the title text: font → all capital letters. Select this text, right-click - Font, and check [all capital letters] in the effect to solve the above problem. When editing English documents, you may often encounter the problem of case switching. Later in the writing, I realized that I had to change the lowercase letters in the front to all uppercase letters. Click Start - Change Case. You can see that you can change any mode of capitalization here. A more advanced way to play is Shif
- Office Software 1289 2024-04-26 09:31:22
-
- An introduction to how to make the exclamation point occupy two lines in Word
- 1. Select menu-Insert-Text Box-Draw Text Box, the result is as shown in the figure. 2. Enter [! 】, set the text box to have no fill color and no border color, the effect is as shown in the figure
- Office Software 1164 2024-04-26 09:31:13
-
- How to create composition draft paper in word2007
- It is also very simple to use the table function to make your own. After running Word2007, click [Insert] in the ribbon to switch to the [Insert] panel, click [Table] and select the [Insert Table] command in the drop-down menu to insert a 2 rows and 20 columns table; usually the line between two rows of the manuscript paper is called the "separator area", so select the second row, right-click and select "Merge Cells" in the pop-up shortcut menu to merge the second row. Drag the mouse to select these two lines, press CtrlC to copy, position the mouse cursor before the carriage return character below the table, press CtrlV to paste, and repeat the same operation (you can also press the F4 or Ctrly key) until you reach the desired up to the number of rows. Click on the upper left corner of the table to select the entire table, then right-click and select [
- Office Software 1233 2024-04-26 09:31:06
-
- Steps to set drop-down options in WPS Office 2016 table
- First create a new excel table. After saving the excel, click the [Insert] option above. At this time, you will see an icon similar to a drop-down list in the toolbar on the right, called [Combo Box]. Click this combo box icon. Then hold down the left mouse button and drag it in excel. When you let go, you will see that a drop-down list box has been drawn. At this time, the drop-down list is still empty. We fill in a column of text elsewhere, and this text will serve as the content options of the drop-down list. Then right-click on the drop-down list and select the [Format Object] option. Then you will see the data source option in the pop-up window. Click the icon behind it, and then a long box will pop up. After the method of making drop-down menu list in wps table
- Office Software 1275 2024-04-25 19:50:16
-
- Specific steps to set up repeated automatic prompts in Excel
- First we select the entire column or row that we do not want to enter repeatedly. Then click [Data Validity] in the [Data] column to ensure the [Data Validity] in this column. The version above 2013 is called [Data Validation]. In the pop-up data validity window, set [Allow] to [Custom], and then enter the formula =COUNTIF(A:A,A1)=1 in the formula below. The same content in column A of the table is only allowed to appear once. Then enter the information to be prompted in [Error Warning], such as [Duplicate content! 】. After finally clicking OK, the data verification in the list is set up. Next time you enter duplicate content, you will be prompted for duplicate information!
- Office Software 975 2024-04-25 19:40:14
-
- Simple tutorial to set background image in word2010
- Click the [Image Watermark] option. Click the [Select Image] button. Click on the picture you want to set in the browser window that opens. You can set the zoom size and [Erosion] option of the image. If you click to check the [Erosion] option, the image will become lighter. After setting, click the [Apply] button and then close the watermark dialog box.
- Office Software 1157 2024-04-25 19:00:23
-
- How does WinRAR software compress files?
- WinRAR is a powerful compressed file management tool that supports multiple compressed file formats. So how to use WinRAR to compress files? For those who don’t know, let’s take a look! Compression method: First, install the WinRAR tool, then select the file or folder that needs to be compressed, right-click the mouse, and select [Add to compressed file] in the WinRAR list. After the [Compressed File Name and Parameters] dialog box pops up, we can set different options as needed, such as clicking the [Browse] option to set the save directory, set the compressed file name, select the compressed file format, etc.; if the compressed file is relatively large, you can select [Cut into volumes, size], compress the file into multiple volume files; if you want to protect the security of the file
- Office Software 1034 2024-04-25 19:00:10
-
- How to set the default font in Excel to Song Dynasty
- 1. Open Excel and create a new table. 2. Enter the content that needs to be set as a font. 3. Click on the cell that needs to be set, expand the font style, find [Song Dynasty] and click Set. 4. The effect is as shown in the figure. 5. Or select the cell, right-click the mouse and select [Format Cells]. 6. Select [Songti] in the [Font] window, and then click the [OK] button to complete.
- Office Software 860 2024-04-25 18:50:25
-
- Specific steps to set print titles in Excel tables
- 1. For everyone’s convenience, the content of the first page in Excel is [I am the first page], the second page is [I am the second page], and the screenshot of the original table is shown in the view, and the title is [I am the title]. 2. Before the modification, the preview title was evenly distributed between the two tables. 3. After that, we need to make settings. First, we need to modify the printing area. Exclude the original title from the printing area. The specific setting method is: select all print areas except the title - page layout - print area - set print area. 4. After the settings are completed, preview again. At this time, there will be no title. Select again: Page Layout—Print Title—Page/Header—Custom Header. 5. Enter the custom header. The title is divided into left, center and right. Generally, the title is centered. Here I take the center as an example.
- Office Software 1299 2024-04-25 18:28:05
-
- How to add artistic effects to Chinese text in WPS Office 2016
- 1. In the newly created document, select [Insert]---------[WordArt] on the toolbar. click to enter. There are many styles of word art, just choose one at will. 2. After entering, a text input box will be displayed, enter your own text, and a [Text Tool] will appear on the toolbar, where there are detailed settings for text fill, text outline, and text effects. 3. In the more settings in WordArt, after clicking Confirm, you can see the [Properties] on the right, the [Shadow] color, size, distance, angle and other settings for the text effect. 4. In the text direction of word art, you can change whether the font is vertical or horizontal. 5. To set the text effect, you can choose directly from the options on the toolbar, or you can choose from the properties on the right. It depends on what you are used to
- Office Software 1075 2024-04-25 18:20:15
-
- Steps to add arrow symbols to word 2010 formulas
- Open the word2010 document window, click the formula to which you need to add an arrow symbol to put it in the editing state, position the insertion bar cursor at the target position, and click the [Other] button in the [Symbol] group of the [Formula Tools/Design] ribbon Open the Symbols panel and click the drop-down triangle button at the top. Select the [Arrow] option in the open drop-down menu, and select the desired arrow symbol in the opened arrow symbol panel.
- Office Software 1159 2024-04-25 18:10:19
-
- How to set the number of digits in Excel cells to be fixed within a range_How to set the number of digits to be fixed within a range in Excel
- 1. Select the cell, select Data - Data Validity - Data Validity in the menu bar at the top, and an edit box will pop up. 2. In the edit box, select Settings. In the validity condition, select [Text Length] in the [Allow] column, and select [Data] in the [Data] column as needed. If you want to be between certain digits, choose between; if you want a fixed number of digits, choose equal to. 3. Here is an example. If you are entering a mobile phone number, you are required to enter 13 digits. After setting this option, don’t rush to click OK. 4. The next step needs to be taken. Select Error Warning in the menu bar and set the warning message to ensure that the system prompts when inputting inconsistent data. As for the settings of style [, title], error message [, etc.], they can be
- Office Software 709 2024-04-25 18:01:29
-
- How to handle error 1004 when running Excel macro
- After running Excel, click the [Macro] option in the Tools tab, and then select the [Security] option! After opening the security settings interface, lower all security levels and use the developer to leave them blank. If this error is also prompted when creating a new document while using Excel, then we can click the [VB Editor] option in the [Macro] tab under the Advanced tab! Method 3: Some users use some wrong codes or formulas during use. In this case, 1004 error code will also appear. At this point we need to check all codes and formulas!
- Office Software 1061 2024-04-25 17:46:21
-
- How to use Boolean operations in PPT_Operation content of Boolean operations in PPT
- 1. Open the [Home] tab and draw a shape you like. 2. As shown in the picture, the editor drew two shapes. Here I choose an object at random. 3. Click the Format tab at this time, and you can see [Merge Shapes] below it. In fact, this is a Boolean operation. 4. But everyone will find that this one is gray, which means it is unavailable. What is the reason? In fact, the editor just selected one object. If you select multiple objects, you can use it. For operation, there must be at least two objects. 5. There are five operations for merging shapes, which are actually similar to addition and subtraction in PS or CAD. 6. Look at the effect of the combination. We can see that two objects change into one object. Equivalent to addition. 7. You can see that the combined functions intersect.
- Office Software 686 2024-04-25 17:40:40