You will need
- Graphic editor Adobe Photoshop, spreadsheet editor of Microsoft Office Excel.
Prepare to Excel tablethat you want to put on the edited Photoshop image. To do this, run the application and complete the data the desired number of cells is automatically created by the program sheet. In the first stage, no need to care about his appearance, but only on the content. Don't forget about the possibility to merge cells in Excel - this allows you to create complex structures in columns and rows.
Use sorting and conditional formatting the table editor to specify the correct sequence of rows of data. In addition, conditional formatting can be applied to graphic design - this tool allows you to change the background, font, borders, cell in accordance with the data that they contain. For example, you can colorize the cells in the ascending values of the color transition from red to green, to highlight the minimum and maximum values, etc. Button with a dropdown list that contains conditional formatting options that are placed in the command group Styles on the Home tab of the table editor.
When you are finished with filling the tables, pick the frame color, background, text, and other design elements. Select one of the available design options - a list of them reveals you click on "cell Styles" command group "the Styles" on the Home tab. If everyone posted there options don't work for you, highlight the entire table, click selection, right-click and select the context menu "Format cells". In the window that opens on the tab "Font", "Border" and "Fill" placed design tools with which you need to give the desired look to the table.
Place the created table to clipboard. To do this, place the cursor in the rightmost bottom cell (Ctrl+End) to select all filled cells (Ctrl+Shift+Home) and copy them (Ctrl+C).
Switch to the graphic editor and select layers one above which you want to place the table. Then paste the contents of the clipboard - press Ctrl+V. Photoshop will add the copied table in the center of the image by creating a separate layer. After that you can start positioning and processing of the pasted table.
Advice 2 : How to draw a table in Excel
To create a table in Microsoft Excel is easy, because, by and large, opening this program, you can already see in front of him ready dimensionless table with empty cells. It remains only to fill them and a little to convert. How do you do it?
Open Microsoft Excel on your personal computer. To do this, click "start" then "Programs". Find the Microsoft Office menu, it find the program Microsoft Excel. To draw a table, select the some range of cells.
Then on the toolbar click on the menu "Insert" select "Table". This operation can be done much faster if you use the key combination CTRL+L or CTRL+T. In the window that appears, select 'my table has headers". Then, specify the column names, otherwise default will be named "Column 1" "Column 2", etc.
Use the controls below to make changes to a table in Excel. You can find them in the tab "Designer", located on the toolbar. You can change the number of rows, columns, format cells and more.
Use of sorting to change only some part of the table, while leaving the rest intact. To resize it, hover over the dot mark in the lower right corner and pull to the side to shift the boundaries of the cells, giving them new values.
Use the alternative method of creating the table. It is to draw a table in Excel manually. Select a specific range of cells with a formal outline on a blank sheet. Then in the upper right corner on the toolbar, find the button "External borders".
Draw the table outline. Then break the cells inside in its sole discretion. To increase the volume of one cell at the expense of another, use button on the toolbar "Merge cells". You can also change the font color, cell background and other decorative items that will help make your table.
Advice 3 : In Excel insert table
Spreadsheet Microsoft Excel supports the ability to create tables to control related data and analysis. Supports the ability to copy and paste tables and parts with partial or full formatting.
At full copy a table from one sheet to another, click the right mouse button at the intersection of column names and line numbers. In the drop-down menu, select copy. Go to another sheet and paste the clipboard contents the same way by choosing "Paste". All the data will be inserted in full compliance with the original (format, font, column width, row height, etc.).
In cases where not copied the full table, or tables on the sheet, select the desired part. To do this, click the left mouse button and, without releasing it, drag the contour to the desired number of cells. Press Ctrl + c or select in the main menu "edit", "Copy". The same can be done using the context menu using the right mouse button.
Stand with your cursor on the cell from which you want to insert. This is the top left corner of the inserted fragment. Open the context menu by clicking with the right mouse button. In the case where the cells need to just paste as is, select "Paste" (or Ctrl + v). If you need to paste only formulas to keep the width of the cells, to consider any configuration sample, use the command "paste Special". This service allows you to insert a relationship between the data.
If you want to add the copied data to the existing table, then in the context menu select "Add copied cells". In the dialog box specify how to paste a range – with a shift right or shift down.
In the main program menu, locate the "Insert" tab. Click here on the button "table". Start dialog box of the object. Check whether the header, selecting the check box "my table has headers". Click the icon to enter the select cells to specify the location of the table. Select the desired cells. At the end click the icon to exit the selection mode. In the selected range will be a table with headings such as "Column1", "Column2", etc.
Simultaneously with the withdrawal of the new table, run the appropriate constructor. Depending on the task, select the desired service. You can create a pivot table, remove duplicates, convert the selected data into the range. To work with external tables you can export, update, the ability to access a table in the browser, to break the link with the external table.
To change the style of the new object, select the appropriate design in the "table Styles" of the designer. To the right, select the desired options. In particular, check whether a title bar, display the totals row, highlight color: alternating rows or alternating columns. It is possible to specify the color to highlight the first or last column.
To sort data, for example, in the first column, click the triangle in front of the header that opens a menu of additional functions. You can sort data by descending, ascending, by color. Other functions allow you to apply filters to search data directly in this column.
To change the column header, select it by double-clicking the left mouse button and enter a new name in the input line of formulas and data. After you press Enter the title will appear in the right place.