ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP - unable to highlight cell range (https://www.excelbanter.com/excel-worksheet-functions/110086-vlookup-unable-highlight-cell-range.html)

Jane

VLOOKUP - unable to highlight cell range
 
I am unable to highlight the cell range on the document I am seeking data....

If I try to highlight A1:G733, I can not start the highlight in cell A1. I
CAN however highlight my range if I start at cell G733.

anu explantion?

thanks! jane

Max

VLOOKUP - unable to highlight cell range
 
Not sure what's the phenomena happening there <g .. maybe there's a
well-masked transparent object placed over cell A1 thereabouts which is
preventing direct selection of the cell with the mouse, etc .. , but perhaps
you could just type the range in the namebox*: A1:G733, then press ENTER
*box with the drop arrow above col header "A", left of the formula bar

The above will select A1:G733 with A1 active.

Especially for large ranges, it might be easier/faster to use the namebox to
select. Of course, this presumes the range is known.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jane" wrote:
I am unable to highlight the cell range on the document I am seeking data....

If I try to highlight A1:G733, I can not start the highlight in cell A1. I
CAN however highlight my range if I start at cell G733.

anu explantion?

thanks! jane



All times are GMT +1. The time now is 11:43 PM.

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