![]() |
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 |
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