搜索
期初数量期初金额库存数量库存金额数量金额日期数量1WL001规格1503,6602021/1/15912WL002规格2513,2562021/1/22913WL003规格35210,5842021/1/32274WL004规格45311,4402021/1/42755WL005规格5542,0162021/1/53076WL006规格6559,2252021/1/62597WL007规格7569,1362021/1/72618WL008规格85711,8492021/1/86049WL009规格9585,9942021/1/980210WL010规格105914,1742021/1/104631112131617物料名称序号物料编码规格型号物料10物料5物料6物料7物料8物料9物料1物料2物料3物料44314,319期初库存入库明细出入库管理明细表查询编码WL009585,994050100期初数量库存数量自动统计自动查询181920自动统计自动查询802入库金额267,066817出库金额408,092单价金额日期数量单价金额数量366.00216,306.002021/1/5550549.00301,950.0091296.0086,136.002021/1/6251444.00111,444.0091882.00200,214.002021/1/71781,323.00235,494.00101880.00242,000.002021/1/82281,320.00300,960.00100144.0044,208.002021/1/9246216.0053,136.00115615.00159,285.002021/1/10289922.50266,602.5025571.00149,031.002021/1/11257856.50220,120.5060697.00420,988.002021/1/125981,045.50625,209.0063333.00267,066.002021/1/13817499.50408,091.5043746.00345,398.002021/1/144571,119.00511,383.0065--0--0--0--0--0结余明细出库数量入库明细出库明细出入库管理明细表入库数量库存数量0200,000400,000600,000自动查询图表展示--0--0--0自动查询图表展示金额33,306.0026,936.0089,082.0088,000.0016,560.0015,375.0034,260.0043,911.0014,319.0048,490.00-----备注结余明细出入库管理明细表入库金额出库金额图表展示---图表展示快捷键操作效果快捷键Ctrl++R向右填充Ctrl++3Ctrl++D向下填充Ctrl++\Ctrl++G定位Ctrl++F6Ctrl++0隐藏列Ctrl++F9Ctrl++9隐藏行Ctrl++F10Ctrl++1设置单元格格式Ctrl++Shift+0Ctrl++2字体加粗Ctrl++Shift+9EXCEL常用快捷键操作效果文字倾斜快速找不同切换到下一个工作簿窗口最小化窗口最大化取消隐藏行取消隐藏列EXCEL常用快捷键