how to copy and past to the bottom of a spreadheet with gaps
it has lots of gaps going down so whats the best way to highlight all the way to the bottom in one go?
how to copy and past to the bottom of a spreadheet with gaps
it has lots of gaps going down so whats the best way to highlight all the way to the bottom in one go?
Perhaps F5-Specal-Last Cell?
Administrative note
Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks
Hi, I assume that you want to paste a formula/value in one column which has many gaps, you can try as follows:
(1) make sure there is value in the last cell of that column
(2) copy the formula/value that you want to paste
(3) click the column you want to paste in (whole column)
(4) press F5, click "special" in the left bottom, choose "Blanks", click "OK"
->then all the gaps in that column will be chosen
(5) paste your formula/value
Hope it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks