Excel Topic

Merge and center and auto fill

Merge and Center

Merge and Center is when you want to put something you have typed into a cell in Excel in multiple cells.

1.) Type a word or phrase into a cell

2.) Highlight that cell and the other cells you want to put it in

3.) Make sure you are in the home tab and go to alignment at the top click the button that says merge and center

Big image

Auto fill

Auto fill is when you are typing a list of things like months or numbers that you want in order. You could also use it to continue a formula.

1.) Type the numbers or months into two cells right next to each other on Excel

2.) Highlight both of the cells

3.) Go to the bottom corner of the second cell until you get the plus sign

4.) Drag until you get to the number or month you would like to end at

Big image