7 Excellent tips in Excel
Excel Tips and Tricks

7 Excellent tips in Microsoft Excel

In this article, we have explained the seven useful tips and features of Microsoft Excel. You can improve your productivity using these features.

Below is the list of these features:

 

1.Select visible cells only:

If you want to copy the visible cells data only not the hidden cells, then you can select the visible cells data only. You can select the visible cells in your selected range using the below steps-

  • Click Home > Find & Select, and pick Go to Special.
  • Choose the option Visible cells only
  • Click on OK
  • Or press Shortcut Key: Alt+;

2.Full Screen

To put the full screen mode in Excel you can press Shortcut Key Ctrl+Shift+F1. To come back from the full screen, you can again press Ctrl+Shift+F1

 

3.Auto Correct:

To add any new text for auto correct you can follow the below path

  • Open from Excel options (Alt+T+O) >> Proofing>>Auto correct options

 

4.Workbook Statistics

To see the workbook details, you see this information. Follow the below steps:

  • Go to the Review Tab >> Workbook statistics
  • Shortcut Key: Alt R+B or Ctrl+Shift+G

 

5.Translator

To translate the selected range with the desired language, you can use the Translate feature. Follow the below steps:

  • Go to the Review Tab >> Translate
  • Shortcut Key: Shift+Alt+F7 and Alt+R+L

 

6.Custom View

To create the custom view in excel, follow the below steps:

  • Go to the View tab >> Custom View
  • Shortcut Key: Alt+W+C

 

Zoom to Selection

To zoom to the selected range, you can follow the below steps:

  • Go to the View tab >> Zoom to Selection
  • Shortcut Key: Alt+W+G
  • Back to 100%: Alt+W+J

Watch the step-by-step video tutorial:

Click here to download the practice file

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com