NEW
Font size
WorksheetsExcel Topic 2
Total questions: 11
Worksheet time: 22mins
Combines cells into one large cell but deletes all contents except the first (Upper Left) cell of the group.
Multiple Lines of Text
Merge Cells
Move Text
Autofill Series
Highlight the text with your mouse and apply changes from the “font” group just as you would in Word
Copy Text
Formatting
Repeat Text
Autofill Series
Only deletes the data in the cells, the cells will remain in place.
Clearing Content
Copy Text
Unmerge Cells
Autofill Series
Removes the cells and the remaining cells around the ones removed will shift into the space left.
Unmerge Cells
Copy Text
Deleting
Clearing Content
Select a cell that you want, hover your mouse on the green square (or blue dot in Google Sheets), drag “plus sign” in any direction to repeat.
Multiple Lines of Text
Typing
Deleting
Repeat Text
Select a cell(s) that you want, R click “Copy”, move to a new cell, R click clipboard icon.
Unmerge Cells
Copy Text
Formatting
Autofill Series
Select a cell, get a four-headed arrow, drag the text, release the mouse to drop the text.
Move Text
Clearing Content
Autofill Series
Multiple Lines of Text
Select two cells with data that you want, hover your mouse on the green square, drag “plus sign” in any direction to continue the series
Clearing Content
Formatting
Autofill Series
Unmerge Cells
Select the cell by clicking in it then type directly in the cell or type in the formula bar
Typing
Formatting
Copy Text
Autofill Series
Splits a merged cell back into several separate cells.
Clearing Content
Move Text
Unmerge Cells
Multiple Lines of Text
When typing in a cell, hold down “Alt” and press “Enter” on the keyboard at the same time.
Formatting
Repeat Text
Multiple Lines of Text
Merge Cells
