It is very easy to make list of item, task, schedule, etc by using Excel, because excel has powerful tool for making table, counting formula, also filtering data. But there is little problem if we insert some pictures in the list we've made.
If you insert the picture directly into the table without any setting and you try to filter the data the picture you insert won't be following your filter, the size and placement of your inserted picture will be disorganized.
Why Picture in Excel Disorganized When Filtering Data?
When you insert picture in to excel cell, on default it will formatted as "don't move or size with cells". Means if the cell is moving or resized because of filter, the picture won't follow it, that's why the picture become disorganized.
Of course, this will be a big problem if you made a list which contain a lot of picture included in it, but don't worry there is easy way to lock picture on excel cells.
How To Lock Picture On Excel & Spreadsheet Cells?
To lock picture on excel cells we need to change the picture format into "move and size with cells" so, the picture will be follow cells position & size when you do filter. To change it you can follow below steps.
1. How To Lock Picture On MS. Excel
- Click one of your picture.
- On Keyboard press CTRL + A, which will make all picture will be selected.
- Right click, and select Format Picture
- Click properties
- Then choose "move and sizes with cells".
2. How To Lock Picture On WPS Spreadsheet
- Click one of your picture.
- On Keyboard press CTRL + A, which will make all picture will be selected.
- Right click, and select Format Object
- Choose Size & Properties Tabs
- On Property menu, choose "Move and size with cells".
Now you can try to filter your data, the picture should be well organized now.
Picture Still Not Organized Well?
If you filter the data but the picture still disorganized, you should check your picture & cells dimension. The picture height & width should inside the cells, not exceed it.
Summary
The picture on excel cells default format is "don't move or size with cells" which made the picture disorganized when you filter it. To make the picture follow your filter you should change the picture format into "Move and size with cells".
That is How To Lock Picture On Excel & Spreadsheet Cells Filter, I hope it can help you to ease your task, feel free to share and comments if you have any question, thanks for visiting.