i need to scan 2 bar codes then i want it to automatically drop to the next line to save me arrowing down
2006-11-20 00:50:11 · 7 answers · asked by Anonymous in Computers & Internet ➔ Software
Hide all but 2 columns. Pressing enter should bring you to the next line in the A column.
2006-11-20 01:00:56 · answer #1 · answered by Yo LO! 6 · 0⤊ 0⤋
I'm not really sure you can anyway other than making those columns really wide and not using any others also there is a border function and you could make all of the other borders invisible.
2006-11-20 00:54:08 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Delete all others columns except 2 columns.
2006-11-20 01:03:07 · answer #3 · answered by Answer Answer 4 · 0⤊ 1⤋
if column A is first, column b is midsection and column c is final, and assuming you want + in between midsection and final. In D1 style =B1&"+"&C1 fill down, reproduction the column and paste values
2016-12-17 13:04:16 · answer #4 · answered by ? 3 · 0⤊ 0⤋
bar codes is a tricky thing in excel ,they are a particular font ,apologies if this doesnt help .
2006-11-20 00:59:15 · answer #5 · answered by dick19532003 5 · 0⤊ 0⤋
the colums which u see on the screen is only a guide to creating your spreadsheet. this will not appear while printing. you must create your own table while typing your document.
2006-11-20 02:34:16 · answer #6 · answered by _PeTaL_D`oR_ 2 · 0⤊ 0⤋
Just widen them until they are the desired size.
2006-11-20 00:59:33 · answer #7 · answered by Crazy Diamond 6 · 0⤊ 0⤋