Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Excel Dictionary Profile picture
@exceldictionary
Jan 13, 2023 • 10 tweets • 4 min read • Read on X
Scrolly
7 number formatting shortcuts: 🔢
1. CTRL SHIFT !

The CTRL SHIFT ! automatically applies number formatting to the selected cells. Number format rounds numbers to two decimal places and adds commas.
2. CTRL SHIFT @

Never waste your time formatting time values manually again with the CTRL SHIFT @ shortcut. CTRL SHIFT @ automatically applies time formatting to the selected cells for you.
3. CTRL SHIFT #

Efficiently format date values in Excel with the CTRL SHIFT # shortcut! CTRL SHIFT # automatically applies date formatting to the selected cells.
5. CTRL SHIFT %

Formatting data to percentages has never been easier than with the CTRL SHIFT % shortcut. CTRL SHIFT % automatically applies percentage formatting to the selected cells.
6. CTRL SHIFT ^

Easily apply scientific number formatting to the selected cells with the CTRL SHIFT ^ shortcut.
7. CTRL SHIFT ~

We’ve learned a lot of number formatting shortcuts, but what if we need to convert numbers back into their raw format? The CTRL SHIFT ~ has you covered. CTRL SHIFT ~ automatically applies general number formatting to the selected cells.
Never format numbers in Excel manually again now that you've learned these shortcuts!

To learn all of Excel’s shortcuts and productivity hacks like this, make sure to sign up for my new course! #excel

Sign up here 👇🏼 education.morningbrew.com/excel
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, templates, and ebooks.
shop.morningbrew.com/collections/ex…
It appears I forgot number four... so here it is:

4. CTRL SHIFT $

A majority of the time, we work with profitability data in Excel. Make sure your data is formatted correctly with CTRL SHIFT $. The CTRL SHIFT $ shortcut quickly formats numbers as currency values.

• • •

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

Excel Dictionary Profile picture
Oct 1, 2024
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
Excel Dictionary Profile picture
Jun 11, 2024
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
Excel Dictionary Profile picture
May 15, 2024
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
Excel Dictionary Profile picture
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
Excel Dictionary Profile picture
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
Excel Dictionary Profile picture
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!

Send Email!

:(