#excel #wraptext #columnwidth | Sharon G.

LinkedIn respects your privacy

LinkedIn and 3rd parties use essential and non-essential cookies to provide, secure, analyze and improve our Services, and to show you relevant ads (including professional and job ads) on and off LinkedIn. Learn more in our Cookie Policy.

Select Accept to consent or Reject to decline non-essential cookies for this use. You can update your choices at any time in your settings.

Helping small businesses get the most out of Microsoft 365 with hands-on training and real life examples that make learning enjoyable and easy by creating bespoke, face to face learning sessions and e-learning materials.

2w

Hello Wednesday! 🤩 Excel tip: Where has all my text disappeared to? 🤦🏽♀️ If you cannot see all the text in a cell and you want to control the width of the column, use the "wrap text" feature. Check out the video attached. If you want to refresh your Excel knowledge, or focus on a specific topice, get in touch via a DM or email me: sharon@sgwebcraft.co.uk. ☺️ #excel #wraptext #columnwidth

3 Comments

Transcript

Did you know that if you wanted your column to stay a certain width, but you had a lot of texts that needed to fit inside that cell, what you could do is use the wrap text feature. That would make your row height a bit deeper and then you can see all the text in there. Give it a go.

JOY Langley, graphic

Mixed-Up Moods, Exhausted Energy, A Messy Mind (But You Don’t Know Why)? Renew Your Zest For Life, Relationships & Business | Have A Conversation With A Therapist Coach | Author of Navigating Stress | Podcast Guest /Host

2w

This is one of the tips I learned a while back ...its been a favourite ever since. The thing I am useless at doing in excel is creating forms! Different boxes and shapes - I am a nightmare Sharon G.

To view or add a comment, sign in

More Relevant Posts

Premium Ready - Made & Custom Excel Applications

178 followers
3w
Report this post
Stop wasting clicks in Excel! 🖱️⛔ Did you know you can repeat your last action with a single key? 👉 Press F4 It repeats whatever you just did (like formatting, inserting rows, adjusting widths, etc.). A massive time-saver for repetitive tweaks — especially when polishing large reports. 🚀 What’s YOUR favorite hidden Excel shortcut? Share it below 👇 #Excel #ExcelTips #Productivity #Shortcuts
Like Comment
To view or add a comment, sign in
Zayn Zafar , ACCA

Turning Data to Direction, Numbers to Navigation | Real Estate & Retail Finance | Management Accountant
1mo
Report this post
"REGEXEXTRACT" Just used this new function in Excel 365 to pull numbers out of a mixed alphanumeric string. No more convoluted LEFT/MID searches. #Excel #ExcelTips #Excel365 #MicrosoftExcel #ExcelCommunity
Like Comment
To view or add a comment, sign in
Ammar Darweesh

Centralized Quantity Surveyor | Civil Engineer | Top-Ranked Civil Engineering Graduate
2w
Report this post
Stop dragging columns and rows in Excel! Two shortcuts that save time every day: 👉 Alt + H + O + A = AutoFit Column 👉 Alt + H + O + I = AutoFit Row Small tricks, big impact. #Excel #Productivity #Shortcuts
Like Comment
To view or add a comment, sign in
Orange Excel

136 followers
2w
Report this post
Text to Columns is useful! But only when the text in the cells follows the same structure. If you try to use Text to Columns to split names, you can run into problems. Sometimes a surname contains more than one name, and then Text to Columns will split the name into multiple columns instead of just two (first name and last name). So, we need to approach this differently. How? With very simple formulas: TEXTBEFORE and TEXTAFTER. Just select the cell, use the space as the delimiter, and you’re done. #Excel #Exceltip
Like Comment
To view or add a comment, sign in
Eric Jacobowitz

Over 25 years experience troubleshooting computers and keeping them working properly. It doesn't matter where you are located, I can fix your computer issues remotely.
3w
Report this post
𝐋𝐢𝐧𝐞 𝐞𝐦 𝐮𝐩 𝐋𝐢𝐧𝐞 𝐞𝐦 𝐮𝐩 𝐋𝐢𝐧𝐞 𝐞𝐦 𝐮𝐩 𝐋𝐢𝐧𝐞 𝐞𝐦 𝐮𝐩 Here is an Excel tip to quickly resize your columns if you have text that is too large for your columns you can quickly auto resize all your columns to auto fit the column width Click the little box in the top left corner of the Excel spreadsheet Click on FORMAT > AUTO FIT COLUMN WIDTH The columns will then auto resize.
Like Comment
To view or add a comment, sign in
Manoj kumar

P2P Specialist | Signify Innovations India Limited | Expertise in End-to-End Procurement | Oracle ERP & SAP |
1w
Report this post
🚀 EXCEL TIP OF THE DAY 🚀 Speed up your work with Flash Fill (CTRL + E) – Excel predicts patterns for you! WHY FLASH FILL? ✅ Splits or combines text instantly ✅ No formulas needed ✅ Saves tons of time with data cleaning EXAMPLE: From John Smith → Auto-split into First Name & Last Name with just CTRL + E. 👉 What’s your favorite Excel shortcut? #exceltips #PRODUCTIVITY #EXCELHACKS #shortcuts
Like Comment
To view or add a comment, sign in
Rawan Thiab

Accounting| PwC | Finance |Tax | Researcher| Trainer| Quality Advisor|
1w
Report this post
⚡ Day 8 – Dynamic Arrays in Excel 🎉 Dynamic arrays are a game changer in modern Excel. No more dragging formulas down — one formula spills results automatically! Here are 3 powerful functions: ✔️ UNIQUE() → Returns a list of unique values ✔️ SORT() → Sorts your list instantly ✔️ FILTER() → Extracts only what you need 💡 Pro Tip: Dynamic arrays eliminate the need for old array formulas (goodbye Ctrl + Shift + Enter ✋). 👉 Have you tried dynamic arrays yet? Which one is your favorite? #Excel #PowerBI #DynamicArrays #ExcelTips #30DayChallenge #DataAnalytics
Like Comment
To view or add a comment, sign in
Bill Bariteau

Marketer and Content Writer Editor | Case Study Writer | I help businesses who want to develop great web content | Quick Turnaround Time | SQL Developer| #WIN
4w
Report this post
The Excel shortcut that saves me hours. Ctrl + ' → Copies the contents from the cell above into your current cell. What’s your favorite time-saving Excel shortcut? I’m building my list.
Like Comment
To view or add a comment, sign in
Abbas Sahily

Freelance Data Analyst · Business Intelligence Specialist · Business Analyst · Data Visualization Expert · Python · SQL · Tableau · Power BI
3w
Report this post
Excel tip that saves hours: Flash Fill (Ctrl + E). Type the pattern once, hit Ctrl + E, and Excel auto-fills the rest. ✅ Split full names into first/last ✅ Format phone numbers ✅ Extract emails from text No formulas. No stress. Just magic. #Excel #DataTips #Efficiency
Like Comment
To view or add a comment, sign in
Sumangla Jain

Data Engineer #MetroInfrasys |IBM Certified | Dual master's
1w Edited
Report this post
✨ Quick Excel Tip! Ever struggled with switching data from rows to columns? The TRANSPOSE function makes it super easy! 📽️ Check out my latest YouTube Shorts where I show how it works: [https://lnkd.in/gC_SFKGu] Stay tuned for more Excel hacks that can save you time every day. ⏱️ #Excel #Productivity #ExcelHacks #Learning #chandigarh #LinkedIn

How to convert row into column in Excel #shortvideo

https://www.youtube.com/
Like Comment
To view or add a comment, sign in

Sharon G.

1,377 followers

290 Posts

View Profile Follow

Explore content categories