Excel Tips - Copy & Paste Visible Cells Only - AzchanneL

preview_player
Показать описание
Excel Tips - Copy & Paste Visible Cells Only - AzchanneL

1. Select the entire range you want to copy.
2. Press Alt+: to select the visible cells only. You will notice that the selection is cut up to skip the hidden rows and columns.
3. Copy the range – Press Ctrl+C or Right-click Copy
4. Select the cell or range that you want to paste to
5. Paste the range – Press Ctrl+V or Right-click Paste
-----------------------------------------------------------------------------------------------------------
☘️ Thank for watching my video!
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------
#azchannel #exceltips
Рекомендации по теме