Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to select multiple areas with keyboard only

I rather use my keyboard than my mouse. I know how to select a rectangular
area on a worksheet, using only the keyboard.

I often want to select several areas on a worksheet. Using the mouse, it's
simple: select an area by dragging, then hold control while selecting the
next area.

How do I do this *without* the mouse?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default How to select multiple areas with keyboard only

Hi,

Highlight the first range with the keyboard and press Shift F8, then move to
and select the second range with the keyboard. Repeat as necessary. Add
will appear on the right side of the status bar during this operation.
--
Cheers,
Shane Devenshire


"Rotaluclac" wrote:

I rather use my keyboard than my mouse. I know how to select a rectangular
area on a worksheet, using only the keyboard.

I often want to select several areas on a worksheet. Using the mouse, it's
simple: select an area by dragging, then hold control while selecting the
next area.

How do I do this *without* the mouse?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to select multiple areas with keyboard only

Wow, thanks Shane!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
USE KEYBOARD TO SELECT ALL SHEETS enos newt gribble Excel Worksheet Functions 4 August 22nd 06 08:50 PM
how to select cells with keyboard if the arrows don't let you go out of the formula [email protected] Excel Worksheet Functions 2 June 15th 06 07:23 PM
keyboard command used to select a range of nonadjacent cells? Jessizzle123 Excel Discussion (Misc queries) 2 November 9th 05 09:19 PM
keyboard command used to select a range of nonadjacent cells? Ron Coderre Excel Discussion (Misc queries) 0 November 9th 05 07:16 PM
Using keyboard to select using excel 02 data... pdow Excel Worksheet Functions 1 December 16th 04 12:37 AM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"