SmartArt is a powerful feature in Excel that allows you to create visually stunning graphics and diagrams. In this tutorial, we will walk you through the process of creating a vertical box list using SmartArt.
Step 1: Open Excel and navigate to the spreadsheet where you want to create the vertical box list.
Step 2: Select the cells that you want to include in the box list. These cells will serve as the content for each box in the list.
Step 3: Go to the Insert tab in the Excel ribbon and click on the SmartArt button.
Step 4: In the Choose a SmartArt Graphic window, navigate to the Hierarchy category and select the Vertical Box List option.
Step 5: Click on the OK button to insert the SmartArt graphic into your spreadsheet.
Step 6: You can now customize the vertical box list by adding or removing boxes, changing the layout, and modifying the text and colors.
Step 7: To add more boxes, simply right-click on an existing box and select the Add Shape option. You can choose to add a box above or below the selected box.
Step 8: To remove a box, right-click on the box and select the Remove Shape option.
Step 9: To change the layout of the box list, click on the Design tab in the SmartArt Tools ribbon and select a different layout option.
Step 10: To modify the text and colors of the boxes, click on a box and use the options in the SmartArt Tools ribbon.
That’s it! You have successfully created a vertical box list using SmartArt in Excel. You can now use this feature to enhance your spreadsheets and make your data more visually appealing.
