close

Hello,

If you could tell me how to do the following it would be appreciated.
If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
showing. If I highligh these row numbers, copy, and paste, it pastes rows
1-7, not the odd rows that are showing. Any help is appreciated.

We could copy only the visible rows using F5 gt; Special

After you select the rows 1-7,
press F5 gt; Special gt; Check quot;Visible cells onlyquot; gt; OK
then right-click to copy (and paste elsewhere)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Access101quot; gt; wrote in message
news
gt; Hello,
gt;
gt; If you could tell me how to do the following it would be appreciated.
gt; If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
gt; showing. If I highligh these row numbers, copy, and paste, it pastes rows
gt; 1-7, not the odd rows that are showing. Any help is appreciate
That's it. Max, thanks so much.

quot;Maxquot; wrote:

gt; We could copy only the visible rows using F5 gt; Special
gt;
gt; After you select the rows 1-7,
gt; press F5 gt; Special gt; Check quot;Visible cells onlyquot; gt; OK
gt; then right-click to copy (and paste elsewhere)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Access101quot; gt; wrote in message
gt; news
gt; gt; Hello,
gt; gt;
gt; gt; If you could tell me how to do the following it would be appreciated.
gt; gt; If I hide rows 2, 4, 6 in a 7 row spreadsheet, then rows 1,3,5, 7 are
gt; gt; showing. If I highligh these row numbers, copy, and paste, it pastes rows
gt; gt; 1-7, not the odd rows that are showing. Any help is appreciate
gt;
gt;
gt;

Pleasure` ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Access101quot; gt; wrote in message
...
gt; That's it. Max, thanks so much.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()