| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using F2 - How do you do 3,000 entries all at once?
I have discovered I need to change cell formatting from Text to General in
order to get my VLOOKUP to work properly. The problem is is that I would prefer to do this all at once as my column contains well over 3,000 entries. Imagine pressing F2, Enter, F2, Enter, F2, Enter into each individual cell (I can't keep the beat going!) Is there a better way to perfom this task in one step? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting remaining entries | Excel Discussion (Misc queries) | |||
| Formula to display last few entries | Excel Worksheet Functions | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| Merge, update, and add only new entries into a list from other she | Excel Worksheet Functions | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
Threaded Mode
