WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • ctrl f in excel

    2080 results for ctrl f in excel

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

    2080 results for ctrl f in excel

    How to find the specified text content in WPS Presentation

    How to find the specified text content in WPS Presentation

    01:06

    How to find the specified text content in WPS Presentation

    When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....

    Presentation 2.1K views
    Ctrl+E smart filling

    Ctrl+E smart filling

    02:50

    Ctrl+E smart filling

    After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

    Spreadsheet 7.3K views
    Change horizontal data to vertical and make data clearer

    Change horizontal data to vertical and make data clearer

    01:06

    Change horizontal data to vertical and make data clearer

    In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

    Spreadsheet 12.3K views
    Superscript and subscript in WPS Presentation

    Superscript and subscript in WPS Presentation

    01:32

    Superscript and subscript in WPS Presentation

    In WPS free PowerPoint tutorial, learn how to use themes and background styles of preseatations, and do more to create standout presentations. All WPS Presentation tutorials are free for students, teachers, business users and more and can be downloaded free in Windows, PC, Mac, Linux, Android, and iOS devices. Chemical elements and mathematical formulas are sometimes needed in slides during the learning process. These coursewares cannot be separated from the superscript and subscript f....

    Presentation 2.1K views
    Four View Modes in WPS Writer

    Four View Modes in WPS Writer

    02:26

    Four View Modes in WPS Writer

    No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. We can choose different view modes according to the needs of our daily file reading. Take this document as an example. I will demonstrate four view modes of text. First, click the View tab. 1.Full Screenl If we only want to display the editing area, click Full Screen or use the shortcut Ctrl+Alt+F.l The document will be displayed on full screen,....

    Writer 2.7K views
    How to insert an attachment in WPS Spreadsheet

    How to insert an attachment in WPS Spreadsheet

    01:28

    How to insert an attachment in WPS Spreadsheet

    When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

    Spreadsheet 1.7K views
    Hyperlink in WPS Office Spreadsheet

    Hyperlink in WPS Office Spreadsheet

    02:22

    Hyperlink in WPS Office Spreadsheet

    When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

    Spreadsheet 55.0K views
    Must-have shortcut tricks in making slides

    Must-have shortcut tricks in making slides

    02:24

    Must-have shortcut tricks in making slides

    During study and work, WPS Presentation is often needed to make a PPT. What makes a high-quality PPT during a short time? In today's tutorials, we will learn a few quick tips commonly used in creating slideshows and thus improving efficiency. · Create a new slideSelect any slide, use the shortcut key Enter, or press Ctrl+Enter together to quickly insert a blank slide. · Delete the current slideSelect the current slide and use the shortcut key Delete or press Ctrl+Delete to remove i....

    Presentation 1.4K views
    Prev 1 2 3 ... 259 260 Next
    WPS Academy
    Products
    Partners