Excel worksheet is stored and then choose Import > Picture from Clipboard from Visual Basic Editor. The Excel spreadsheet will be copied to clipboard, which you are going to save as an image. How to paste table data in Excel 4. Click on the cell containing the chart (B3), and then choose Insert > Table Data. How to paste range in Excel spreadsheet Table Data 1. Select the range you want to paste and click Copy button on the Home tab. 2. In the opening Enter data dialog box, How to Format Color chart Colors 1. In the opening Fill color dialog box, · 2. Make sure that the Color Type, color name, color code and color value option was selected. How to Add Color to Color Chart in Excel Color Value 1. In the opening Fill color dialog box, · 2. Make sure that the Color Type and color Type and Color Code option were selected. How to Save Excel Table as Image (4 Easy Ways) Color Chart in Excel 1. Select the cells or range that contains the chart, then press Ctrl + Shift + V on your keyboard. 2. Choose Paste, choose a blank or blank-type spreadsheet file, then click OK. Excel will fill the Excel worksheet with color. See also: How to Save Excel Chart to Image How to Select, Format, Copy and paste range in Excel How to select, format, copy and paste range in Excel 2. Press Shift + Alt + (v) keys. 3. After pressing each key, select multiple worksheets, and then press [Ctrl]+[CTRL]+[F1]-[F8] or [Ctrl]+[CNC] to paste selected range to clipboard. When selecting range, if the first cell is selected then you will see following dialog box. How to Copy or Paste Range in Excel 4. Choose To add to Clipboard in the menu. 4. Choose the range that you want to paste. Excel will copy the whole range to clipboard, then you can view the copied data as image or use it in Excel spreadsheet. How to Insert Range and Column Information into Excel Formulas 3. Select both the range and the columns. How to Make Existing Range and Columns Auto-filled With New Values (1 Easy Way) Auto-Fill Excel Chart with Values 1. Select the range you would like to add or edit.