Traditional Culture Encyclopedia - Hotel accommodation - How to make hotel inventory table

How to make hotel inventory table

1, excel is the best software to make tables, and now almost all spreadsheets are made by excel. Here are some points to explain how to make an inventory list easily.

2. Create a new form and enter all the text items needed in the form according to your own ideas.

3. Then select the cells to be merged, and click Center after merging.

4. Click the center after merging and then modify the font size and thickness of the title, so that the header is ready. In the same way, all other projects are merged and centered.

5. After setting all the table items, use the mouse to select all the tables and right-click to set the cell format.

6. Select the border, then select a thick line, and then click the outer border to set the outer border of the table.

7. Then set an inner box for the table and click OK.

8. You can see the effect after setting the border.

9. Then you can set the background color according to the project for easy viewing. Select a subitem, right-click to open and format the cell, click Fill, select the background color, and click OK.