10 Excel hacks 99% of users don't know: 🤯
1. Creating Barcodes
Creating scannable barcodes may seem like a difficult task, but Excel actually makes it easy. First, add an “*” before and after each product code using the ampersand symbol. Then just update the font to “libre barcode 128” to create the barcodes! Easy.
2. AutoCorrect Symbols
Instead of manually searching for and inserting symbols, you can code them into Excel using AutoCorrect. Hit ALT F T > Proofing > AutoCorrect Options. Enter the phrase that'll represent the symbol next to ‘Replace:’ and the symbol next to ‘With:.’
3. Dynamic Pictures
Instead of retaking pictures of data every time a change is made, you can use the camera tool to take dynamic pictures. Select the data you want to capture > press the Camera icon > click anywhere in the sheet. Now, the image auto-updates the data changes!
4. Sort By Formatting
Excel is known for analyzing and sorting numerical data, but it can also sort by cell formatting! For example, to sort by color, go to Data > Sort > Select field to sort by > Select ‘Cell Color’ to sort on > Choose the color to sort by and hit OK.
5. Emoji Formatting
Give your data some personality by adding conditional Emojis 🙂. To visualize your data using emojis, open the Format Cells dialog box > Number Tab > Custom > enter ‘[Color 10]0.00%🙂;[Color 3]-0.00%☹️’ as type.
6. Slicers
Instead of adding Sort&Filter toggles to data and manually applying filters, you can create filter buttons using slicers. To add slicers, go to the Insert tab > Slicers > select what you want to filter the data by and hit OK. Now just click any button to auto-filter!
7. Custom Lists
Have Excel read your mind and autofill lists for you using custom lists. To create a custom list, Go to File > Options > Advanced > Edit Custom Lists > Enter List > Import > OK. Now, enter any list item, drag down the fill handle, and Excel will fill the rest!
8. Add Text To Numbers
Adding text to numbers, such as ‘Million,’ will convert the number to text and cause errors in calculations. To prevent this, you can actually use custom formatting. Open the Format Cells dialog box > Number Tab > Custom > enter ‘#,, “Million”’ as type.
9. Hide Data
Deleting data out of your workbook can cause endless REF errors throughout your workbook. Instead of deleting the data, you can actually hide it. Just select the data you want to hide, open the Format Cells dialog box > Number Tab > Custom > enter ‘;;;;’ as type.
10. Roman Numerals
Excel makes it easy to convert numbers into Roman Numerals with the ROMAN function. Just enter the number you want to convert as the “number” argument, and it will automatically be converted into its Roman Numeral.
Who actually knew all ten?! 🤚🏼
To learn all of Excel’s shortcuts and productivity hacks like these, make sure to sign up for my new course! #excel
Sign up now 👇🏼education.morningbrew.com/excel
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.