WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2527 results for how to adjust columns in excel

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        2527 results for how to adjust columns in excel

        How to adjust the picture position

        How to adjust the picture position

        02:06

        How to adjust the picture position

        After inserting a picture in the document, to perfect the layout, we will adjust the position of the picture in the process of typesetting. Take this document as an example. If we want to move the picture to the lower right corner of the page margin, click the picture first. Then click the Layout Options button in the upper right corner of the picture. And then click View More, now the Layout dialog box will pop up. WPS has provided us a large variety of alignment methods in the Positi....

        Writer 37.7K views
        How to adjust line spacing of the text

        How to adjust line spacing of the text

        01:18

        How to adjust line spacing of the text

        After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....

        Writer 23.1K views
        How to use the Smart Split Columns feature

        How to use the Smart Split Columns feature

        02:34

        How to use the Smart Split Columns feature

        The Smart Split Columns feature of the WPS Spreadsheet can divide the table content into columns according to the table content in four ways.· Delimiter:Take this table as an example. If we look through the table carefully, we can find that although the cells contain a lot of data, the data are all separated by space. 1. Now click Text to Columns in the Data tab, and click Smart Split Columns.2. After a dialog box pops up, we can view the result of Smart Split Columns in the preview wi....

        Spreadsheet 27.2K views
        How to adjust the size and position of pictures accurately

        How to adjust the size and position of pictures accurately

        01:54

        How to adjust the size and position of pictures accurately

        WPS Presentation includes advanced animation, slide transitions, and support for video, images, audio, and even Flash. We usually drag the mouse to adjust the size and position of the inserted picture in the presentation.This is a convenient yet inaccurate method. Today we will learn a method to adjust the size and position of the picture accurately. Right-click the picture to be adjusted, then click Format Object.In the task pane that pops up on the right side of the screen, click SIZ....

        Presentation 13.8K views
        How to Process data with Text to Columns

        How to Process data with Text to Columns

        07:31

        How to Process data with Text to Columns

        The main knowledge points of this lesson are the following 3 points1. Smart Split Columns can identify the contents and split them. There are four techniques for splitting columns based on text features: Delimiter, Text Type, Keyword, and Fixed Width. 2. Data formats can be standardized in addition to splitting columns. For example, numerical dates can be standardized dates, and numerical formats can be turned into text formats. 3. Ampersand operator and smart filling(Ctrl+E) can merg....

        Spreadsheet 11.7K views
        How to adjust the overall width and font position of the table in WPS Writer

        How to adjust the overall width and font position of the table in WPS Writer

        01:33

        How to adjust the overall width and font position of the table in WPS Writer

        After we create the table in a document, we can adjust the size of the cells and the position of the text in the table.Take this table as an example. We move the mouse cursor to where the table is located and click the cross button in the upper left corner to select all cells. Click the Table Tools tab and the Table Properties button, then a dialog box will pop up.In the Cell tab, find Size and check Preferred width. We can also adjust the width of all cells after entering the value ac....

        Writer 16.2K views
        Use format painter to adjust the styles in batches

        Use format painter to adjust the styles in batches

        01:28

        Use format painter to adjust the styles in batches

        Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

        Spreadsheet 12.7K views
        How to draw a column chart in WPS Spreadsheet

        How to draw a column chart in WPS Spreadsheet

        01: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....

        Spreadsheet 16.7K views
        Prev 1 2 3 ... 315 316 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube