0
Select the first range as normal. Then press and hold the Ctrl key and select the other range with the mouse. The first range will stay selected. You can select as many ranges as you want using this method.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What are two methods of applying the same format to different ranges in Excel?
You can use the Format Painter to copy the formatting from one range to another. You could copy a range and then using Paste Special, pick the Formats in the options. You can also just select the two ranges at the same time, and then apply the formatting to both ranges. Select the first range as normal, then press and hold the Ctrl key and use the mouse to select the second range.
How do you apply two themes fonts together in Excel?
You can select only one theme at a time in Excel. Select the primary theme you want to display on the entire worksheet, then change the fonts for the cells you want to display a font different than the theme.
Describe the two types of cell ranges in Excel 2007?
Adjacent and nonadjacent
What are the two ranges of Excel?
You may be referring to a contiguous range and a non-contiguous range.
What key do you use in Excel to pick two different groups of cells?
Hold down the Ctrl key as you click on the cells or group of cells you want to select.
Write the functions of ms Excel that are different from Microsoft Word?
They are two completely different types of programs. MS Excel is a spreadsheet, while MS Word is a word processor. For example, it is not possible to create a pivot chart in MS Word that automatically updated every time you change a value in a related cell. It is not possible to click a button to "select all" in MS Excel.
What are the two different names of the mountain ranges in the US?
Blue Ridge, Rocky Mountain ranges
What are the Names of two different mountain ranges in the us?
The Rocky Mountains and the Appalachian Mountains are two prominent mountain ranges in the United States. The Rocky Mountains stretch from Canada to New Mexico, while the Appalachian Mountains run from Georgia to Maine.
Are the Himalayas also called the Alps?
No, they are two different mountain ranges.
How do you use Excel for typing Microsoft Word?
Excel and Microsoft word are two different programs. To ask how to you use excel for typing ms word does not make sense
What is a contiguous range in Excel?
There is no such thing as a non-contiguous range. A range is a group of cells that are together in a rectangular block. Non-contiguous refers to cells that are not touching. So you can have more than one range which do not touch, so what you have are non-contiguous ranges. It is possible to select non-contiguous ranges by first selecting one range and then while holding the Ctrl key, select other ranges.
Can you have two different column widths on one excel worksheet?
Yes. Every column on the worksheet can have a different width, if you like.
