How do I scan in a worksheet so that I can edit or add data?

  • Thread starter Thread starter beacon
  • Start date Start date
B

beacon

I have a worksheet that I can scan but it will not let me enter in any data.
How do I make it work?
 
hi
hard to say. some older scanners only scanned documents as pictures making
them impossible to edit.
some newer scanners come with OCR software (optical character recognition)
making it possible to scan as text. a text file can be opened in xl as a text
file.
check your scanner's documentation for OCR software.
if you don't have OCR software, check this out....

http://www.google.com/search?hl=en&q=OCR+software

regards
FSt1
 
Just a note to add.

It is unlikely that your OCR application will scan 100% but some can get close,
especially with standard fonts.

Expect to have a bit of editing after the scan and dump to Excel.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

scanning worksheet for data then adding it 4
Formulas that recognise data from two worksheets 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Move or Copy Stopped Working? 0
How do I set a formula, that add next cell reference in a Formula 2
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
How do i add a function button to a worksheet? 3
need help on either doing a loop and counting specific values orusing subtotal function 2

Back
Top