526 results for how to expand and collapse rows in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to delete blank rows of table in batches00:51
How to delete blank rows of table in batches
When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....
How to print slides in black and white00:53
How to print slides in black and white
Printing black and white slides helps to reduce printing costs and save resources. Next, I will share how to print black and white slides with you.Take this slide as an example. Click the Print Preview shortcut button at the top left of the screen.At this point, the slide shows the colored style.Click the drop-down button of Color above, and then click Pure Black and White so that the slide is set to be printed in black and white.In addition, we can also set the printing color in the P....
How to set header and footer in WPS Presentation02:26
How to set header and footer in WPS Presentation
When using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....
How to insert and set pictures in WPS Spreadsheet02:19
How to insert and set pictures in WPS Spreadsheet
When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....
How to insert a background image and print it out in WPS Spreadsheet01:31
How to insert a background image and print it out in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....
Collapse or expand rows or columns in a sheet
We can group the rows or columns to collapse or expand parts of the details. The following screenshots compare a worksheet before and after grouping data.Before grouping data Group data to collapse or expand columns Here are the steps to group the data.1. Select the rows or columns to be grouped.2. Go to the Data tab → click Group.Steps to group data You can also further group the data following the previous steps. Here is an example to further group the data. Further group the data T....
How to set header and footer in odd and even pages respectively03:08
How to set header and footer in odd and even pages respectively
What can we do if we want to set the header and footer in odd and even pages respectively? Take this article as an example. Double-click the header of the home page, and click the Header and Footer Options in the Header/Footer tab, then you will see a pop-up dialog box. l Page different settings 1.Check Different first page in the Page different settings to set the header and footer of the first page separately. 2.Check Different odd and even pages to set the header and footer of odd....
How to add and set the numbering in WPS Presentation00:55
How to add and set the numbering in WPS Presentation
WPS Office is a comprehensive office suite that includes writer, spreadsheet, presentation and PDF editor all within one single software.When using WPS presentation, we may want to add numbering to make our slides look more organized. So, how can we add numbering?Select the text content that needs to be added with numbering, click the Home tab above, and then click the Numbering button. Here, we can see a variety of preset numbering provided by WPS. Click to select a style to add. If w....