Excel Dictionary Profile picture
Oct 13, 2022 9 tweets 4 min read Read on X
7 must-know number formatting Excel tips:
1. Custom Format (with emojis)

Tired of boring data? Give it some personality by visualizing your data with Emojis 🙂. Open the Format Cells dialog box > Number Tab > Custom > enter ‘[Color 10]0.00%🙂;[Color 3]-0.00%☹️’ as type.
2. Add Text to Numbers

Adding text to numbers such as ‘Million’ manually is time-consuming and will cause calculation errors because the values are read as text. Instead, use custom formatting. Open the Format Cells box > Number Tab > Custom > enter ‘#,, “Million”’ as type.
3. Disguise Numbers as Text

Words can speak louder than numbers in Excel. For ex., we may not need to know a student’s exact score, but just whether they passed or failed. To disguise numbers, open the Format Cells box > Number Tab > Custom > enter ‘[<70]”Fail”;”Pass”’ as type.
4. Create Invisible Data

Have you ever deleted distracting data from your worksheet, and then all of a sudden, all you see are #REF! errors? To prevent this, you can just hide the data by opening the Format Cells dialog box > Number Tab > Custom > enter ‘;;;’ as type.
5. Convert Numbers -> Percentages

If you’ve ever converted integers to percentages by selecting the percentage icon on the Home tab, you’ve noticed it adds two decimal places. Here's a solution: Open the Format Cells dialog box > Number Tab > Custom > enter 0\% as type.
6. Add Leading Zeros

When entering data with leading zeros, you may have noticed Excel automatically omits the leading zeros from the number. To keep the leading zeros, open the Format Cells dialog box > Number Tab > Custom > enter ‘00000’ (# of digits in the number) as type.
7. Add Ending Zeros

Instead of counting out zeros when entering large numbers, we can use exponential formatting to add the zeros for us. Just type the number followed by ‘e7’ (7 being the number of zeros), and then update the number format to general.
Don’t get lost in the numbers with these formatting tricks! 😏

Follow me @exceldictionary for even more Excel tips and tricks.

And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com/collections/ex…

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Excel Dictionary

Excel Dictionary Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @exceldictionary

Oct 1
Top data cleaning functions you need to know. 🤓📊
1. UNIQUE

=UNIQUE(array, [by_col], [exactly_once])

The UNIQUE function removes duplicate values by returning a unique list of values in an array.
2. TEXTSPLIT

=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])

The TEXTSPLIT function splits text into multiple rows or columns at a specified delimiter.
Read 9 tweets
Jun 11
The future of Excel is officially here. 🤖

You can now send prompts to AI directly in Excel to 10x your productivity.

Here are the top 7 new AI driven functions you need to know:
1. AI.ASK

Meet your new built-in Excel assistant: AI.ASK. AI.ASK allows you to ask AI questions by sending a prompt to AI directly from the grid. Just enter the question you want to ask as the prompt argument and send it off to AI!
2. AI.LIST

Just when you thought it couldn’t get better, it does. AI.LIST allows you to generate a list of data by sending a prompt to AI from the grid. Just enter the prompt describing the list you want to create as the prompt argument, and let AI.LIST do the rest!
Read 9 tweets
May 15
10 must-know Excel shortcuts:
1. CTRL E

CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.
2. ALT =

Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
Read 12 tweets
Sep 21, 2023
Formatting is key to creating professional-looking spreadsheets. Here are the top 10 Excel formatting shortcuts:
1. ALT H O I

Have you ever opened a workbook and not been able to see the data? Instead of manually adjusting the column widths in the header, try ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
2. ALT H O A

Now that we know how to automatically adjust our cells' column widths, let's learn how to adjust their row heights! ALT H O A automatically adjusts the selected cells’ row heights to equal the size of their contents.
Read 12 tweets
Sep 14, 2023
5 Excel mouse shortcuts you don't know but should:
1. Copying Data

99% of Excel users copy and paste data daily, so why not do it as efficiently as possible? Just select the data you want to copy, hold CTRL, and drag the data to where you want it to be pasted.
2. Moving Data

Now that we know how to quickly copy data, let’s learn how to quickly move it. Instead of cutting and pasting, select the data you want to move, hold SHIFT, and drag the data to its new location.
Read 7 tweets
Sep 7, 2023
If you use Microsoft Excel, you need to know these 6 text formatting hacks:
1. Split Cell

Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
2. Rotate Text

Rotating text is a great way to clean up your worksheet by removing unnecessary space in cells caused by long data headers. To rotate text, simply select the cells containing the text you want to rotate > Home tab > Orientation > Select desired orientation.
Read 8 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(