It will select only the visible cells in your selected range, then you can copy and paste to exclude the hidden cells. To avoid this and only paste the visible rows and columns we can use this select visible cells command. When you copy a range that contains hidden rows or columns and then try to paste it somewhere, the entire range including the hidden rows and columns will be pasted. Look for the command called Select Visible Cells from the All commands menu. It can be pretty handy for quickly copying and pasting the location of a file to send to a colleague. You can add this document location bar to the quick access toolbar to allow you to quickly copy and paste the full folder path and workbook name of the current active workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |