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

        475 results for show hidden tabs in excel

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

        475 results for show hidden tabs in excel

        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL function: Calculate the data with the hidden value

        Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

        Spreadsheet 23.9K views

        How to show formulas as text in Excel

        How to Show Formulas as Text in Excel-WPS Academy As soon as you write a formula in Excel and hit enter, it'd return the calculated end result, and the formulation might disappear. That’s how it’s supposed to work. But what if you want to reveal formulas inside the cells and no longer the calculated values. To do this, you may use Ribbon or Keyboard shortcut, Function, Putting Apostrophe or Space in front of the Equal sign of a Function. How show Formulas as text in Excel Instead ....

        xls Spreadsheet 14.6K views

        How to show unique values in Excel

        Excel only show unique values WPS (2016/2019/mac/online)? While working on different lists in excel you need that excel only show unique values WPS (2016/2019/mac/online) lists so that you can find out all different/unique/distinct sorts of entries on the list and omitting all the repeated entries. Now this may be a very tricky and time consuming task especially when the lists are very long. But luckily enough there exist quite simple methods in excel that can enable you to do this tas....

        xls Spreadsheet 12.3K views
        How to customize the ribbon in WPS Writer

        How to customize the ribbon in WPS Writer

        02:33

        How to customize the ribbon in WPS Writer

        WPS Writer's built-in tabs in ribbon enable users to explore different functions. We can also customize the ribbon to meet different work demands. · Hide and show the toolbarClick the Hide the toolbar or show the toolbar button in the upper right corner, and you can make the ribbon display or disappear. If Hide the toolbar is selected, you can click any tab to make it display temporarily. · Create customized ribbons and groupsClick Menu, and then click Option to select Customize Ri....

        Writer 21.0K views
        How to customize the ribbon in WPS Presentation

        How to customize the ribbon in WPS Presentation

        02:57

        How to customize the ribbon in WPS Presentation

        WPS Presentation's built-in tabs in ribbon enable users to explore different functions. We can also customize the ribbon to meet different work demands. · Hide and show the toolbarClick the Hide the toolbar or show the toolbar button in the upper right corner, and you can make the ribbon display or disappear. If Hide the toolbar is selected, you can click any tab to make it display temporarily. · Create customized ribbons and groupsClick Menu, and then click Option to select Custom....

        Presentation 15.1K views
        How to customize the ribbon in WPS Spreadsheet

        How to customize the ribbon in WPS Spreadsheet

        02:26

        How to customize the ribbon in WPS Spreadsheet

        WPS Presentation's built-in tabs in ribbon enable users to explore different functions. We can also customize the ribbon to meet different work demands. · Hide and show the toolbarClick the Hide the toolbar or show the toolbar button in the upper right corner, and you can make the ribbon display or disappear. If Hide the toolbar is selected, you can click any tab to make it display temporarily.· Create customized ribbons and groupsClick Menu, and then click Option to select Customi....

        Spreadsheet 22.9K views

        How to show or hide gridlines in Excel

        · Show gridlinesOption 1:1. Click the View tab.2. Check the View Gridlines option. Option 2:1. Click the Menu drop-down list in the upper left corner and click Options.2. In the pop-up dialog, click the View tab, and check Gridlines in the Window options area.3. Click the OK button. · Hide gridlinesOption 1:1. Click the View tab.2. Uncheck the View Gridlines option. Option 2:1. Click the Menu drop-down list in the upper left corner and click Options.2. In the pop-up dialog, click the V....

        xls Spreadsheet 8.2K 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 40.1K views
        Prev 1 2 3 ... 59 60 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