Labels

Sunday 21 August 2011

Applying background to an excel worksheet

To add a picture background to an excel worksheet, Go to Page Layout ribbon >  Page Setup  > Background. (Browse to your image location and press Open)


You may have to adjust the size and resolution of your picture according to requirement


After you have applied a background, the default button changes to "Delete background" button which can be used to remove the background (if required).


You can also remove gridlines for better visibility .(removing gridlines)


Note: The background is only for on-screen display and will not be printed.


Make worksheet fit to printing page size


On the status bar, click the Page Layout button to switch from Normal to Page Layout view.


Or 


Go to Page Layout > Scale to Fit > Width > 1 page, and in the Height box, select Automatic. Excel will adjust the zoom setting to shrink the data to fit 1 page in width.

Removing Gridlines in excel

To remove gridlines in excel. Go to View > Show > Gridlines. (Uncheck the option)