• Tiếng ViệtTiếng Việt
Theo dõi
Lucid Gen
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools
No Result
View All Result
Lucid Gen
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools
No Result
View All Result
Lucid Gen
No Result
View All Result

Lucid Gen › Technology › Computer tips › How to add upper and lower case shortcuts in Excel

How to add upper and lower case shortcuts in Excel

9
SHARES
879
VIEWS
Chia sẻ bài viết lên Facebook

Hi the whole house, office work with Excel certainly makes you tired of switching between: lowercase, Chinese, IN. It’s impossible to manually correct a data list if it’s too much. Using formulas to transfer is too trivial and also takes time to manipulate. Hieu encountered this case, also learn, then know Excel does not support text conversion shortcuts.

After this article, we can set shortcuts to convert lowercase letters to capital letters, printed letters in Excel. Hieu will guide the fastest way, much simpler than online articles.

Related posts

  • How to create a YouTube channel subscription button on a video
  • How to use Grammarly software to correct English grammar
  • How to install Microsoft Office for free on a Macbook
Table of contents
  1. Download an Excel text converter file
  2. Add lowercase to capital and print shortcuts in Excel
  3. Use keyboard shortcuts to switch lowercase, Chinese, IN
  4. Links

Download an Excel text converter file

First you download the PERSONAL file. XLSB

We use VBA in Excel to install the type change shortcut. This file is composed by Hieu after groping with VBA code. So you don’t have to spend your time researching it.

Add lowercase to capital and print shortcuts in Excel

You copy the PERSONAL file. XLSB enters drive C in a path

C:Users/Computer Username/AppData/Roaming/Microsoft/Excel/XLSTART

If you can’t find the AppData folder, it’s hidden. You turn it on by clicking the Organize button on the left corner and selecting Folder and search options. Next on the View tab, click show hidden files, folders and drivers > OK.

You can watch the clip if you find it difficult.

Use keyboard shortcuts to switch lowercase, Chinese, IN

You open a new Excel file to try. Select the cell to switch text to and use the following keyboard shortcuts:

Ctrl J: converted to print (MINH HIEU)

Ctrl M: converted to initial capital (Minh Hieu)

Ctrl Q: converted to lowercase (filial)

With the new Excel file, it’s definitely a success. As for old Excel files that are normal, only some files may not work if it has ever been tweaked something in the VBA. It can be overcome but a little confusing so Hieu does not say in this article.

Links

Thanks to this way, the work with importing data into Excel of Hieu significantly improved, you should try and comment the results below to hieu know.

Share4Pin1Share1
Next Post

How to filter duplicate data in Google Sheets

How to create a list of tables by chapter in Word

How to create an automatic table of contents in Word with heading

Leave a Reply Cancel reply

I will review and reply to all comments within the day. Please feel free to leave your comments on this article!

Your email address will not be published. Required fields are marked *

You will probably need it

Cách viết chữ in đậm trên Facebook và FB chat
Content marketing

How to write bold text on Facebook and FB Messenger

18/10/2020
0

How to write type on Facebook, write in bold, italic on Facebook, change the FB font on status. 100% of...

Read more

Recommended for you

Automatic Google Ads keyword grouping tool

18/10/2020

How to install Windows 10 for Macbook correctly

18/10/2020

How to fix Vietnamese typing error on macOS

18/10/2020
Chia sẻ và hướng dẫn Wordfence Security Premium

How to set up Wordfence Security Premium plugin

12/12/2020
Cách sao chép chiến dịch quảng cáo Google Ads

How to copy a Google Ads ad campaign

18/10/2020

Lucid Gen

Một blog chia sẻ về digital marketing, linh tinh về công nghệ và những gì có thể bạn cần mà tác giả biết.

Phát triển bởi một người thích viết blog
Trần Ngọc Minh Hiếu

Thống kê thời gian thực đã có 63 Bài viết và 1,908 Bình luận

Tiết lộ: Website này đã có quảng cáo. Không có tiền thì viết làm sao.

Recent Comments

  • Minh Hiếu on How to merge multiple Excel and CSV files into 1 sheet
  • Nguyenthoa on How to merge multiple Excel and CSV files into 1 sheet
  • Minh Hiếu on How to merge multiple Excel and CSV files into 1 sheet
  • Nguyenthoa on How to merge multiple Excel and CSV files into 1 sheet
  • Minh Hiếu on How to hide all files and icons on the Mac desktop

Image sources

Lucid Gen edits images from the following sources: Freepik, Unsplash & Pixabay.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

  • About
  • Contact
  • Terms and policies

© 2019 Lucid Gen with by Minh Hieu DMCA Protected

No Result
View All Result
  • Digital Marketing
    • Email Marketing
    • Facebook
    • Google Ads
    • Zalo Marketing
  • Website
    • SEO
    • Website measurement
    • WordPress
  • Technology
    • Computer tips
    • Mobile
    • Utilities
  • Review
  • Marketing tools

© 2019 Lucid Gen with by Minh Hieu DMCA Protected