Insert checkbox, combo box, radio button etc.

If you are designing a form in Microsoft Word, Excel or Powerpoint and want to restrict user data entry using checkboxes, combo boxes, radio buttons, date picker, toggle buttons etc.

Go to Office Home/File  >  Options  >  Customize Ribbons  >  Check Developer in Main Tabs category (if not already checked). Developer ribbon will appear now.

Go to "Developer" ribbon. Select  Controls  >  select desired object from the list of options available.

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.