Explain the two methods of selecting non- contiguous (Multiple selection) range of cells? (Excel-2007)
Q. Explain the two methods of selecting non- contiguous (Multiple selection) range of cells?
Ans. Suppose you want to select multiple ranges of cells. You may first select the first range and then press control and then click and drag the mouse to select additional cells or ranges.
Or From the keyboard select the first range of cells using either F8 or Shift key and then press Shift + F8 to select another range without cancelling the previous range.
Or Enter the range address in the name box separating each range address with a comma and then press Enter key.
Or Press F5 key now GoTo Dialog box appears in the reference box. Enter the range address separated by comma.
Or From the keyboard select the first range of cells using either F8 or Shift key and then press Shift + F8 to select another range without cancelling the previous range.
Or Enter the range address in the name box separating each range address with a comma and then press Enter key.
Or Press F5 key now GoTo Dialog box appears in the reference box. Enter the range address separated by comma.
0 comments:
Post a Comment