Introduction to outbound orders
The outbound order is an indispensable item for every company. When the company needs to conduct an inventory count, the role of the outbound order becomes apparent. The delivery note is filled with the name of the goods, quantity, unit price, transaction amount, buyer, seller, handler, date, etc. It has also been applied to the delivery of goods between departments of some companies and units. The person in charge or leader of the department must sign and approve the delivery, which reduces the payment of cash and makes the accounts more detailed. Huajun Software Park provides downloads of high-quality Excel templates and warehouse-out order excel templates. You can download the source files for you to edit, modify and replace. The warehouse-out order templates can be found at Huajun Software Park.
General tips for outbound orders
1. Quickly select cells
When selecting cells (rows, columns), hold down the Shift key at the same time to select consecutive cells (rows, columns). When selecting cells (rows, columns), hold down the Ctrl key at the same time to select discontinuous cells (rows, columns).
2. Quickly select an Excel area
In Excel, to quickly select a certain area in the workbook, just click the upper-left corner cell of the area you want to select, hold down the Shift key, and then click the right corner of the area you want to select. Just the lower corner cell. In addition: hold down the Ctrl key and use the mouse to select multiple non-adjacent areas. In fact, the selected area has nothing to do with the order. You only need to select a corner cell of the rectangular area first, and click the diagonal cell while pressing Shift.
3. Back up the workpiece book
Click the "File → Save" command to open the "Save As" dialog box, press the drop-down button next to "Tools" in the upper right corner, click "General Options", and in the subsequent pop-up dialog box, select the "Generate Backup" option (), click the "OK" button to save. If you modify the workbook in the future and then save it, the system will automatically generate a backup workbook that can be opened and used directly.
4. Quickly browse long workbooks
When you browse a table with long content, press the "Ctri+Home" key to return to the upper left corner of the current worksheet (i.e. cell A1), and press the "Ctrl+End" key to jump to the worksheet containing The lower right corner of the data section. In addition, if you select some content, you can move clockwise on the 4 corner cells of the selection by repeatedly pressing "Ctrl+. (Period)".
5. Quickly delete empty rows in the worksheet
If the user wants to delete the empty rows in the Excel worksheet, the general method is to find all the blank rows and then delete them row by row, but this operation is very large and inconvenient. The following provides a method to quickly delete empty rows in a worksheet: first open the worksheet where you want to delete empty rows, click the "Insert → Column" command in the open worksheet, thereby inserting a new column X, in The columns are filled sequentially with integers, and then the rows in the table are sorted according to any other column so that all empty rows are concentrated at the bottom of the table. Delete the data in column X in all empty rows, reorder by column X, and then delete column X.
Recommended by the editor of Huajun Software Park
Outbound orderIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need a warehouse release form, download it quickly. also,Production progress tracking form,balance sheet excel, is also a good software, welcome to click to download and experience it!
it works
it works
it works