214 results for how to keep column fixed in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to draw a column chart in WPS Spreadsheet01:46
How to draw a column chart in WPS Spreadsheet
A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....
Text to Columns: Sort data quickly02:03
Text to Columns: Sort data quickly
When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....
Quickly adjust the row height and column width01:36
Quickly adjust the row height and column width
Adjusting the row height and column width is a necessary skill for the layout of the table content. So, how can we adjust the row height and column width? The easiest way to adjust the row height and column width is to position the mouse on the dividing line of the row number and column label and drag the dividing line to adjust the row height and column width. We will find that using this method is difficult to completely unify the row height and column width in the table, and the ope....
How to use Name Manager01:13
How to use Name Manager
We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....
Layout skill-How can we split columns01:39
Layout skill-How can we split columns
When using WPS Writer to create a layout in Word, we sometimes may want to split the content into two columns. So how are we going to make it? First click the upper tab Page Layout and click Columns. At this time, you can directly select whether you want to spilt the content into one column (One), two columns (Two), or three columns (Three).If you need to customize the column settings, just click More Columns to view more detailed options. There are five column styles in Preset, namely....
How to set the line spacing to a fixed value in WPS Writer
1. Use WPS Office to open the document and select the paragraph that we want to edit.2. Click the right mouse button and select Paragraph from the shortcut menu.3. In the pop-up Paragraph dialog, choose Indents and Spacing. In the Spacing area, choose Exactly in the Line spacing box. And in the At box, we can input a fixed value. For example, we input “40” pt here.4. Click the OK button. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.
Adjust row height and column width of tables in word02:02
Adjust row height and column width of tables in word
When making tables in word, we often need to set their accurate row height and column width. In this video, you'll learn how to adjust table row height and column width in word. · Row height:Select the table for settings. Next, get into the Table Tools tab and click Table Properties. Go to the Row tab of the pop-up dialog. Then, we can adjust the row height at Size. After checking the Specify height option, enter ’0.5’ in the input box. In the category of Row height is..., we can c....
How can we freeze the pane in WPS Spreadsheet02:28
How can we freeze the pane in WPS Spreadsheet
When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....