answersLogoWhite

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.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

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.


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


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


Are the Himalayas also called the Alps?

No, they are two different mountain ranges.


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.


How do you look at 2 different Microsoft Office 2007 Excel files at the same time in separate windows?

In Excel 2007 open both workbooks. From the View tab on the ribbon bar, in the Window section, click on Arrange All and select Vertical to see the two workbooks next to each other. Select horizontal if you would like to see one above the other. If you would like the workbooks to change places, click on the Switch Windows option (View Tab | Window section).


What is Difference between if statement and select case statement in vbscript?

If statements and Select-Case statements are two similar features that allow for code branching. The difference is that each If statement may compare against different variables and different ranges, while Select-Case statements may only compare against one variable at a time, and must compare against discrete values. Select-Case is therefore a specialized form of If statements, and are more efficient in terms of amount of code used and execution speed when used instead of theequivalentIf-Else statements.