WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to make excel cells the same height and width

    1612 results for how to make excel cells the same height and width

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

    1612 results for how to make excel cells the same height and width

    Quickly adjust the row height and column width

    Quickly adjust the row height and column width

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

    Spreadsheet 6.3K views
    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 12.2K views
    Adjust row height and column width of tables in word

    Adjust row height and column width of tables in word

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

    Writer 7.5K views
    Get to know WPS Spreadsheet

    Get to know WPS Spreadsheet

    10:26

    Get to know WPS Spreadsheet

    1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

    Spreadsheet 23.8K views
    How to align shapes in WPS Presentation

    How to align shapes in WPS Presentation

    03:26

    How to align shapes in WPS Presentation

    You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint.Learning to align the shapes in WPS Presentation can make the layout easier. So how to use the function of Align?Select the shapes to be aligned, click the Drawing Tool tab, and then click the Align button. In the Align drop-down menu, you can set the alignment as needed.Note: same alignment settings show different effects with different reference objects. Here are three different wa....

    Presentation 2.3K views
    Create a chart from scratch

    Create a chart from scratch

    08:59

    Create a chart from scratch

    In this lesson we have studied the following key points:1. How to create table borders and insert a diagonal line to the table header.l You can click the "Drow border" button to draw the form lines manually, or you can click the "All borders" button, which provides many border styles.l Select the targeted cell first, press the shortcut key "Ctrl+1", select "Border" >select a diagonal line border. 2. How to merge or unmerge cells.WPS Spreadsheet also provides more ways of merging cells....

    Spreadsheet 3.0K views
    How to make a resume to impress picky HR

    How to make a resume to impress picky HR

    04:35

    How to make a resume to impress picky HR

    An amazing resume is a must-have for the employee who wants to stand out among job applications.Today we will learn how to create a resume in excel.First, set the page size.Head to the "Page Layout" tab and set the page as A4 at "Size." Then select the default "Narrow" at "Margins." Step two, decide where to arrange your texts.Before setting the area, click "Page Break Preview" in the lower right corner to change the view mode. So we can better understand the sector locations for the s....

    Spreadsheet 5.2K views
    How to group data in a spreadsheet

    How to group data in a spreadsheet

    02:01

    How to group data in a spreadsheet

    When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

    Spreadsheet 3.3K views
    Prev 1 2 3 ... 201 202 Next
    WPS Academy
    Products
    Partners