How to make a food menu in WPS Office Excel

February 11, 2022
841 Views 0

Are you struggling to make an elegant food menu? This tutorial will show you how to create a neat and beautiful menu in WPS Office Excel quickly. Four simple steps are as following:

Step1Set the print pattern and show print grid lines

Sept2Input all the contents of the food menu

Sept3Beautify the food menu

Sept4Export the food menu

How to make a food menu in  WPS Office Excel1.png 


Now lets make a food menu step by step.

Remember you are free to adjust the cells anytime according to actual needs.


· Step 1: Set the print pattern and show print grid lines

If you design your menu on the sheet freely, sometimes you may not get the expected results when printing. For example, if there is too much content, it would be separated into two pages with its layout changed. To avoid similar problems, you can set the print pattern first.

1. Input anything into one cell first to successfully enter the print preview mode. Then click Menu > the triangle on the right of the Print button > Print Preview.

How to make a food menu in  WPS Office Excel2.gif  

2. Choose a paper size from the Paper Sizes drop-down menu.

(Here we choose B4.)

How to make a food menu in  WPS Office Excel3.gif 

3. Set its orientation, margin, zoom pattern and so on in the ribbon as needed. You can also check or uncheck Print Gridlines (the gridlines of cells in the sheet) as needed. Then click Close to quit the print preview mode.

(Here we choose Portrait, No Zoom and uncheck Print Gridlines.)

How to make a food menu in  WPS Office Excel4.gif 

4. You can also set margins by inputting arguments. Go to the Page Layout tab > Margins. You can choose from presets or click Custom margins to input desired arguments.

(Here we choose Narrow.)

How to make a food menu in  WPS Office Excel5.gif 

To learn more about print page setup, click here to watch the tutorial in WPS Academy.

 

5. Head to the View tab > check Print Gridlines to show the split lines (in the form of dotted lines) between pages.

How to make a food menu in  WPS Office Excel6.gif 

· Step 2: Input all the content

You can visualize the menu in the mind and then input all the content into the right cells as you want.

Note that the content that you want to print on the same page should be filled in cell range of the same page.

How to make a food menu in  WPS Office Excel7.gif 

· Step 3: Beautify the menu

Merge Cells

Some names of the dishes are too long to be displayed in one cell, so you can merge cells to show them entirely. WPS Office provides many types of merging for efficient operations.

1. Select the cells to be merged, click the Merge and Center and here we click Merge Across to merge these cells in batches.

How to make a food menu in  WPS Office Excel8.gif  

2. You can also choose other merging methods as needed.

To learn more about merging, you can click here to watch the tutorial in WPS Academy.

How to make a food menu in  WPS Office Excel9.gif 

Format Cells

1. Select the cell range, and set the font style, font size, font color, fill color, alignment, etc.

(Here we set Brush Script MT, font size 24, Bold, Dark red, Center.)

How to make a food menu in  WPS Office Excel10.gif 

2. You can also use Format Painter to apply the format quickly to the targeted cell range.

How to make a food menu in  WPS Office Excel11.gif  

3. Then we finish the cell formatting.

How to make a food menu in  WPS Office Excel12.gif 

To learn more about cells formatting, click here to watch the tutorial in WPS Academy.

 

Insert Images

1. Click the Insert tab > the Picture drop-down button.

2. You can select Floating Picture or Embed to Cell as needed.

Floating Picture: You can move the picture freely.

Embed to Cell: The picture is embedded into the selected cell and cannot be moved freely.

(Here we choose Floating Picture.)

How to make a food menu in  WPS Office Excel13.gif 

3. Click From File to insert a picture from you computer. Then you can change its size and position as needed.

How to make a food menu in  WPS Office Excel14.gif 

4. You can also choose from the preset pictures in the WPS Office. Note that these templates are only for template premium users. You click here to subscribe.

How to make a food menu in  WPS Office Excel15.gif  

Insert background

1. Head to the Page Layout tab > Background.

2. Choose a picture as background.

How to make a food menu in  WPS Office Excel16.gif  

· Step 4: Export the menu

Since we have set the printing pattern in advance, we can print the menu directly. To learn more about printing in WPS Office, click here to watch the tutorial in WPS Office Spreadsheet in WPS Academy.

 

In WPS Office Spreadsheet, however, the background cannot be printed in the normal printing method. If we need to print out the background, the Camera function can help.

1. Head to the View tab > uncheck View Gridlines.

How to make a food menu in  WPS Office Excel17.gif 

2. Select the cell range, and click the Insert tab and click Camera to shoot this cell range.

3. Go to sheet 2 and click on any position to insert the image.

How to make a food menu in  WPS Office Excel18.1.gif 

3. Left-click the image and you can print the image directly by clicking Save as Picture.

How to make a food menu in  WPS Office Excel19.gif 

 

To learn more about how to print the background in WPS Office Spreadsheet, you can click here to watch the tutorial in WPS academy.

 

With these four steps, you are able to make an elegant menu in excel quickly and freely. Did you get it?

 

· Terms Explanation

1. What is Camera in WPS Spreadsheet?

The Camera function is used to shoot the range in a sheet and save it as an image. The image is synchronized with the source data, which means the image will change as the source sheet. It would be helpful when you need to compare two sheets.

 

2. What is WPS Spreadsheet?

WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal basic version is free to use and it also provides abundant functions and unique features for you to explore.

 

Learn more advanced skills about editing in WPS Spreadsheet:

WPS Spreadsheet basic editing | WPS Academy Free Office Courses

Content layout basics | WPS Academy Free Office Courses

 

WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.

Was this helpful?