» Adding a Picture to a Header/Footer
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
1. Select cell A1.
2. From the Insert menu, select Picture, and then select From File.
3. Select the picture you want, and click Insert.
4. Adjust the picture to the height and width of the row.
5. From the File menu, select Page Setup.
6. Select the Sheet tab.
7. Select Rows to repeat at top.
8. Select row 1, and then click OK.
To add a picture (such as a company logo) to the header/footer in Excel 2002 and Excel 2003:
1. From the File menu, select Page Setup.
2. Select the Header/Footer tab.
3. Select Custom Footer.
4. Select Left section.
5. Click the Picture icon (the second icon from the right).
6. In the Insert Picture dialog box, search for and select the logo or picture you want to add.
7. To format the picture, click the Format Picture icon (the first icon from the right).
8. Click OK.
Book Store:
ISERROR Function
Morana Revel Posted on: 31-12-1969
Wouldn't it just be easier to use the ISERROR function nested in an IF function to print a blank space if the function produces an error? If it is done one the first formula and copied to the rest of the spreadsheet, it doesnt really take that much extra time to do.
EX:
=IF(ISERROR((B4*5)/S4)," ",(B4*5)/S4)
or
=IF(T4="","",IF(ISERROR((B4*5)/T4),B4*5,(B4*5)/T4))
While this may seem complicated, it covers many different errors. It is one of the most useful functions I know for making spreadsheets look professional.
Reply: ISERROR Function - Morana Revel from Magnolia, KY wrote on February 7, 2003 6:35 AM EST
Alan Posted on: 31-12-1969
Hi Morana,
Personally, I think you shoudn't hide the errors - you should address and eliminate them!
With all due respect, tt doesn't sound very professional to hide the fact that a model is returning errors?
Just my opinion!
Alan.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
