WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • excel how to make columns same size

    223 results for excel how to make columns same size

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

    223 results for excel how to make columns same size

    Rows and columns tools in WPS Spreadsheet

    Rows and columns tools in WPS Spreadsheet

    02:34

    Rows and columns tools in WPS Spreadsheet

    Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....

    Spreadsheet 0.1945 views
    Insert a table into the text & convert between text and table

    Insert a table into the text & convert between text and table

    02:48

    Insert a table into the text & convert between text and table

    When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....

    Writer views
    Layout skill-How can we split columns

    Layout skill-How can we split columns

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

    Writer 0.1151 views
    How to insert a table in WPS Presentation

    How to insert a table in WPS Presentation

    01:47

    How to insert a table in WPS Presentation

    When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....

    Presentation views
    How to view two sheets side by side

    How to view two sheets side by side

    01:09

    How to view two sheets side by side

    When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

    Spreadsheet views

    How to transpose columns to rows in Excel

    1. Select the table area that needs to be transposed.2. Right-click, and choose Copy in the pop-up shortcut menu, or press Ctrl+C.3. Select a blank area where we want to paste the transposed table. Right-click, and place the cursor behind the Paste Special option in the pop-up shortcut menu. Finally, click Transpose.4. Then, we can transpose columns to rows in Excel, and vice versa. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    Spreadsheet views
    How to set the slide size in WPS Presentation

    How to set the slide size in WPS Presentation

    01:28

    How to set the slide size in WPS Presentation

    When using WPS Presentation to make slides, we need to set the slide size first. So how can we set the slide size? First, click the Design tab above, and then click the Slide Size button. Here, we can quickly adjust the slide size, such as the commonly used Standard Screen 4:3 or Wide Screen size 16:9.If we need to set other sizes, we can click Custom Size to open the Page Setup dialog box for more detailed slide settings. By clicking the Page Setup button in the Design tab, we can als....

    Presentation 0.2183 views

    How to hide columns in excel

    · Hide a single column1. Right-click on the target column for operation.2. Choose Hide from the pop-up list. · Hide a columns within a continuous range range1. Right-click to select a continous column range.2. Choose Hide from the pop-up list. · Hide multiple column selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the columns for operation.2. Right click on the last column(s) selected, and choose Hide from the list. To be office excel advanced, you cou....

    Spreadsheet 0.1025 views
    Prev 123...2728 Next
    WPS Academy
    Products
    Partners