You are learning Microsoft excel
Click to Continue
How do you select nonadjacent ranges?
Click and hold Alt key
Click and hold Ctrl key
Click and hold Delete key
Clicking and holding the Ctrl key allows you to highlight ranges that can be in all different areas of the spreadsheet.
This function saves time and effort when many different areas all need to be formatted the same way.