![]() ![]() How to paste formula values retaining table formatĪlthough the paste special tool is not perfect, you should not underestimate its capabilities. While holding the CTRL key, drag the tab of the sheet. Helpful hint! The quickest way to copy a large and complicated table retaining its column width and row height is to copy it as an entire sheet. Select the all rows and column on sheet (CTRL+A).Note that the paste special menu lacks the option “row height.” Thus, you will need to take the following steps to fulfill such a task: ![]() However, the second method allows to both quickly carry the table over together with the format, and copy the row height. It's rational to use each of the methods depending on the task. ![]() 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |