Show When copying a filtered range in Excel, it will only copy the visible cells by default, and then we can paste it into a new worksheet manually. However, the row height and column width are not reserved. Therefore, how to save filtered data to a new worksheet or workbook, and keep row height and column width simultaneously in Excel? Here we will introduce a couple of methods for you. Normally we can apply the Copy feature and Paste feature to save filtered data into a new worksheet or workbook
directly. You can do as follows: Notes: 2. Select the filtered data, and copy it with pressing the Ctrl + C keys at the same time. 3. Go to the new worksheet or workbook, select a blank cell, and press Ctrl + V keys simultaneously to paste the filtered data. Then you will see only filtered data are copied and pasted into the new worksheet/workbook. However, the row height and column width are lost. See below screen shots: Easily split range based on criteria in a column and save split ranges to new new sheetsKutools for Excel’s Split Data utility can help Excel users easily split a range to multiple worksheets based on criteria in one column of original range. Save filtered data to new sheet with Copy and Move featureIf the filtered data are too huge to select and copy easily, and you have customized column widths and row heights for many columns and rows, the Copying and Pasting may be not a good solution. In these conditions, you should try the Kutools for Excel's Delete Hidden (Visible) Rows & Columns utility. 1. Right click the sheet name which contains the filtered data in the Sheet Tab bar, and select the Move or Copy from the right-clicking menu. Step 2: In the popping up Move or Copy dialog box, specify a workbook in the Move select sheets to book drop down list, check the Create a copy option, and click the OK button. Note: To save filtered data
into a new worksheet, select current workbook name in the Move Selected sheets To book drop down list; to save filtered data into a new workbook, please select (new book). 3. Now you will get into the new worksheet/workbook, please click the Kutools > Delete > Delete Hidden (Visible) Rows & Columns, and then in the opening dialog box, (1) Select In Active Sheet in the Look in drop down list; It will take several minutes to delete all hidden rows if too many hidden rows exist. As deleting completes, a dialog bow will come out and tell you how many hidden rows have been deleted, just click Ok button to close it. Now you will see all filtered data are reserved into the new worksheet, and all cell formatting including row heights and column widths are kept. Demo: Save filtered data to new sheet in Excel Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now! Related articles:The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Comments (0) No ratings yet. Be the first to rate!
Follow UsCopyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. How do I print only the visible rows in Excel?If you are using Excel 2010 or a later version, follow these steps instead:. Press Ctrl+P. Excel displays the Print controls on the File tab of the ribbon.. Click the first button under the Settings heading and choose Print Selection. (You are indicating that you want to print only what you have selected.). Click on Print.. How do I print filtered cells?(2) If you have filtered your data (by clicking on the filter arrow in the column header), make sure that you have also selected ""Filter and Print Area"" in the "What to Print" drop-down menu.
How do you exclude hidden rows from printing in Excel?Create an empty column A, and for each row that you don't want printed, type an "n" (for "no" but any unique character will do). Then before printing, do a Filter in column A to show rows that NOT "n".
|