How to hide pictures and tables together in Excel

Have you encountered this situation: you need to hide pictures and tables in Excel, but you don’t want to delete them? PHP editor Xiaoxin will solve this problem for you and provide detailed step-by-step guidance, allowing you to easily hide pictures and tables while retaining their data to avoid unnecessary loss. Continue reading below to learn exactly how to hide pictures and tables in Excel.

1. Hidden rows or columns by default

1. Select the column where the picture is located, right-click and select hide:

2. As shown in the figure As shown in the figure, after the column is hidden, the picture is not hidden, but moved to the right to the next column:

2. Method of hiding cells and pictures at the same time

1. Select the picture, press the F5 key on the keyboard, and click the positioning condition:

2. Select the object and click OK to select all objects with the same format as the selected picture:

3. Right-click any picture and select size and properties:

4. Click the properties box on the right and select size and position. Change the cell:

5. Select the row or column where the table is located, right-click, and select Hide:

6. As shown in the figure Display, the picture has been hidden along with the column:

The above is the detailed content of How to hide pictures and tables together in Excel. For more information, please follow other related articles on the PHP Chinese website!