How To Change the Image Size of a Workbook Step 1: Right-click on your Excel sheet. The image changes in size. You can set the value of the width and height of the workbook using the following formula: =IF(B6,1,30,”",”") Where: B 6 — The width of the image B 7 — The height of the image The formula should look like this: (Width in millimeters) (Height in millimeters) Step 2: Drag your selected sheet into the worksheets' area, click and drag the width and height to set the size of the workbook. How To Change the Image Size of Worksheets By default your spreadsheet has an image named “C:\\Users\\Administrator\\Desktop\\myworksheet.gif” or your image is “C:\\Documents AND Settings\\[username]\\Desktop\\myworksheet.png” These types of values are displayed on the Excel worksheets. To display a different image on each worksheet click the image from your file explorer and select “View…” (or “Properties” in older versions of Excel). Then you will find the “Image” button in the Properties window. How To Change the size of a worksheet You can change the image properties like image size or the background color of your worksheets by using these methods: 1. Click the image of your choice (the image should be in the same folder as the “WORKBOOKS\\[username]\\Desktop\\myworksheet.gif” or “C:\\Documents AND Settings\\[username]\\Desktop\\myworksheet.jpg” file in the example above). The new image will appear next to the current worksheet. 2. Double-click the “WORKBOOK” tab at the bottom of the Properties window (right click and select “Properties”). 3. Click the “Image Properties” button. 4. Click Edit at the bottom of the “Picture” section. Click the size that you want your worksheet to be displayed at the moment. Click OK. How to save multiple Excel sheet to separate PDF files 1. Download the Excel files. How to change the image of a worksheet Just click on the “image” you want to add or remove. How to change the image properties like image size or the background color of worksheets 1.