Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Cell address in a range | Excel Discussion (Misc queries) | |||
Convert Range name in cell for VLookup | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |