D
DVanBruggen
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need help with the following:
Selecting, copying and pasting visible cells only
Selecting, copying and pasting visible cells only
What have you tried? What are you trying to select? How are you selectingVersion: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I need help with
the following:
Selecting, copying and pasting visible cells only
Thanks for your reply. I am using 12.2.3. To repeat the problem: filter
any column for a given item in the column. Copy the selected rows. I
want to paste ONLY the rows containing the selection. The standard paste
function pastes all rows spanned by the rows in the filtered list, So,
how does one paste only the filtered values one ses and no more?
many thanks in advance
MANY thanks! This is quite helpful. I am still a bit unclear about the
"usage" of this too. In particular, it appears that putting the icon to
the toolbar makes pasting only visible cells the default behavior
(unless the icon is removed). Is this true? is it possible to toggle
between paste only visible cells and paste all cells without removing
the icon? Or do I misunderstand something basic about what is going on
here??
many thanks again!
S.
Whatever is on the clipboard when you paste, gets pasted.
Maybe an example will help. If you select a cell range and then click
the Select Visible Cells button, only the visible cells within the range
will be copied to the clipboard. So if you dragged over a range that
included columns A through G, but columns D & E were hidden, the values
in D & E will not be copied to the clipboard. When you paste, you'll get
all the values except for those that were in columns D & E. If you
selected entire columns, your result will be different - paste will
include columns D&E even if they are hidden.
-Jim
--
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.