从 Lemon8 应用程序下载视频和图库的最简单方法
桌面:右键单击并选择“将链接另存为...”进行下载。
PHOTOS | |||
JPEG | 下载 | ||
JPEG | 下载 | ||
JPEG | 下载 | ||
JPEG | 下载 | ||
JPEG | 下载 | ||
JPEG | 下载 | ||
JPEG | 下载 |
It's always a pain when you're tasked to clean up data, especially when there's a bunch of blank rows that you want to delete! Especially at my internships, the dataset that was given to me are usually super huge, with over a thousand rows - and manually cleaning it up one by one just takes too much time. This was a trick that was taught to me by my colleague, which is one of the life saving trick that made hate excel much lesser!
If you're tasked to clean up data again - especially for those painful sales orders, sku list or even the promotion data, you'll become the excel wizard to wow your boss, or still be able to make it to your 2hr lunch when you wfh!
_____________________________________
If you haven't scrolled pass the image, here's a step by step guide on how you can do this!
📌1. Select your Column that you want to clean up!
Since there's always a bunch of columns that has blank rows, you want to pinpoint which column that you want to clean up exactly. I would recommend that you select the entire column «A:A», so that you can clear up those rows that are hidden as well!
📌 2. Find & Select
Under the ribbon, click [Home > Find & Select]! This will eventually prompt a drop-down list, and you can select
📌 3. Go to Special
Click the button
📌 4. Delete Rows
After you click «OK», excel will auto select all the empty spaces, so after you've got the selection - don't click anywhere! Right click the row number «1», and then click delete! It'll then delete all the selected blank spaces that you have!
📌 5. Cleaned up Data
Now you've got your data cleaned up - you can do the same thing again for other columns as well!
_____________________________________
now you're the master at this, you can always share it with your friends and colleagues so y'all wouldn't be as lost in excel anymore!