Excel converts the SUBTOTAL functions to values.Īdditional Details: Instead of selecting Go To Special, Visible Cells Only, you can press Alt+ (that is, hold down the Alt key and type a semicolon). You might think that you would have to select Paste, Values instead of just doing a paste. Paste the subtotals only to a new workbook.
The marching ants will surround each row. The white lines indicate the hidden rows are unselected.You've now selected only the visible cells. If you are in Excel 2007, the color of selected cells is too light to make out the white lines. There will be thin white lines above and below each subtotal. In the Go To Special dialog, select Visible Cells Only.ShowAllData To copy and paste special values for columns use the below Columns. To hide a column, right click on the column.
Paste in excel without hidden rows for mac for mac#
Alternatively, you can press the F5 key and click the Special button in the lower-left corner of the Go To dialog. Excel for Mac does not support this method. To unhide rows click the arrow icon that appears over the hidden row numbers.
Gotcha: If you forget to hold shift and press Ctrl+8, Excel will remove the Group & Outline symbols. Choose the 2 Group & Outline button to put the data in subtotal view.Strategy: You can use an obscure command in the Go To Special dialog box to assist with this task.
When I copy and paste, I get all of the detail rows as well. My manager wants me to send him just the total rows in a file. Problem: I've added subtotals and collapsed to the #2 view.
0 kommentar(er)
