choose a method to adjust column width - to set a column width to a specific setting choose Format ----> Column width on the home tab. Type the exact width you want in the column width dialogue box; then click OK
changing row heights -
select the rows whose height you want to adjust
choose a method to adjust row height - to manually change the row height, position the mouse pointer on the bottom boundary of the row heading until it turns into a double sided arrow. Drag until the row is the height that you want