Locate the picture that you wish to lock to the cell.Here is how to lock a picture to a cell in Excel 2011 – Once you have completed the steps below, the picture in the cell will resize with the rest of the cells in its row or column, and will be included if you cut and paste a row or column to a different location in the worksheet. You can read here to learn about locking pictures to cells in Excel 2010. The steps are similar for Windows versions. The steps in this article were written for and performed on the Excel 2011 version of the software, for the Mac. Locking a Picture to a Cell in Excel 2011 Our guide below will show you how to modify your spreadsheet picture to achieve this result. But if you need to move a row or column that contains pictures, you will probably run into a problem where the data in the row or column moves, but the pictures do not.įortunately you can adjust this behavior by locking a picture to a cell in Excel 2011. Occasionally you will need to add a picture to a spreadsheet, or someone will send you a spreadsheet with pictures in it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |