ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   shortcut key for selecting the inactive cells surrounding a range (https://www.excelbanter.com/excel-worksheet-functions/181750-shortcut-key-selecting-inactive-cells-surrounding-range.html)

Michele

shortcut key for selecting the inactive cells surrounding a range
 
I thought I used a shortcut for selecting all the outside cells surrounding
an active area of a worksheet, but I can't remember it and I'm not finding it
in any of the shortcut key lists.

Héctor Miguel

shortcut key for selecting the inactive cells surrounding a range
 
hi, Michele !

I thought I used a shortcut for selecting all the outside cells surrounding an active area of a worksheet
but I can't remember it and I'm not finding it in any of the shortcut key lists.


could it be selecting the activecell's current region ?
{ctrl}{asterisk}
{ctrl}{shift}{asterisk}

hth,
hector.




All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com