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

        2356 results for how to anchor a cell in excel

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

        2356 results for how to anchor a cell in excel

        How can we change the font in a cell

        How can we change the font in a cell

        01:09

        How can we change the font in a cell

        When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

        Spreadsheet 45.8K views
        How to set the cell alignment in WPS Spreadsheet

        How to set the cell alignment in WPS Spreadsheet

        02:31

        How to set the cell alignment in WPS Spreadsheet

        To ensure the beauty of the spreadsheet, sometimes we need to align the contents of it. How can we quickly set the alignment of the spreadsheet?This video could help to solve the problem of How to set the cell alignment in WPS Spreadsheet. There are several alignment shortcut buttons in the ribbon, which are commonly used in the workplace. Now let's demonstrate them one by one.Top Align: Align text to the top of the cell.Middle Align: Align text so that it is centered between the t....

        Spreadsheet 26.1K views
        How to insert shapes in a worksheet

        How to insert shapes in a worksheet

        01:20

        How to insert shapes in a worksheet

        We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

        Spreadsheet 10.9K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 13.1K views
        How to enter a number starting with 0 in the Spreadsheet

        How to enter a number starting with 0 in the Spreadsheet

        01:38

        How to enter a number starting with 0 in the Spreadsheet

        The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

        Spreadsheet 17.2K views
        How to insert a signature in a PDF file

        How to insert a signature in a PDF file

        02:16

        How to insert a signature in a PDF file

        We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....

        PDF 27.8K 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 13.1K views
        How to add a stamp in a PDF file

        How to add a stamp in a PDF file

        01:42

        How to add a stamp in a PDF file

        We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....

        PDF 9.2K views
        Prev 1 2 3 ... 294 295 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