Copy and paste to quickly obtain the desired result.Select the columns containing the initial data.This method has a secret: if you select the columns together with their headings before copying the table, the width of every column will also be copied when you paste it. The table now features the initial parameters and looks perfect. In the dialog window, select the option «Column widths», and click «ОК».Find the line «Paste Special» (CTRL+ALT+V) in the drop-down menu. Select the new (already copied) table, where you need to apply the column width format, and right-click on a cell.Select the initial table that needs to be copied, and press Ctrl+C.
However, there is a way to significantly reduce your loss of time. If the table is large, you will be fiddling around for quite a while. You will have to adjust the column width manually, whipping it into the convenient shape. When you copy it to a different spreadsheet using the usual Ctrl+C – Ctrl+V method, the result is far from desired: Let's assume we have a table, the format of which needs to be preserved when you copy it: How to copy a table retaining column width and row height This unsophisticated tool is employed to quickly apply the same format to all tables and achieve the necessary result. It's a simple tool that allows for solving complicated tasks quickly and mastering the basics of its usage. For this, we will use the function «Paste Special». How to paste a formula in an Excel table retaining the format? It's possible to save a truckload of time solving this task. Those who regularly work in Microsoft Excel often wonder how to copy the table data properly, retaining the format, formulas or their values. How to copy a table in Excel by saving the format cells
0 kommentar(er)
