#1   Report Post  
rexmann
 
Posts: n/a
Default select database

Hi all

Prob an easy one but is there a keyboard shortcut to select a whole range of
data (database) in excel. Or select just the filled in data. I know ctrl A
selects all - is there a variation on this?

any help greatly appreciated

cheers Rexmann
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Rexmann

You can use Ctrl * to select the current region

--
Regards Ron de Bruin
http://www.rondebruin.nl


"rexmann" wrote in message ...
Hi all

Prob an easy one but is there a keyboard shortcut to select a whole range of
data (database) in excel. Or select just the filled in data. I know ctrl A
selects all - is there a variation on this?

any help greatly appreciated

cheers Rexmann



  #3   Report Post  
rexmann
 
Posts: n/a
Default

Hi Ron de Bruin

Thanks for the help; much appreciated

Rexmann

"Ron de Bruin" wrote:

Hi Rexmann

You can use Ctrl * to select the current region

--
Regards Ron de Bruin
http://www.rondebruin.nl


"rexmann" wrote in message ...
Hi all

Prob an easy one but is there a keyboard shortcut to select a whole range of
data (database) in excel. Or select just the filled in data. I know ctrl A
selects all - is there a variation on this?

any help greatly appreciated

cheers Rexmann




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
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM
When I select "Open" from the "File" menu in Excel, I get only a . dan Excel Discussion (Misc queries) 1 November 30th 04 11:25 PM
How do I save a record from an excel template to a database in a . Fred Smith Excel Discussion (Misc queries) 1 November 30th 04 01:49 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 06:35 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"